User creates a heterogeneous query with Oracle and Sybase databases in Query Builder. Query can be consistently executed successfully. User sends the query to the Automation module and exports query results to an Excel sheet. User can run a test on the automation successfully. However, once he schedules the automation, the following error occurs in the log file and automation does not complete:
"[Microsoft][ODBC Microsoft Access Driver] ODBC--call failed"
Add the two ODBC connections separately to the Automation model. Add these connections as Parallel activities to the existing Quest Stage connection.