DSXchange

Hi,

I am working with ODBC stage to connect progress 4GL database.

I am able to run a sequence in the 1 node configuration.
But the same sequence is not running successfully in 4 node configuration.

the sequence aborts at the 3rd job among the 3 jobs in the sequence.

errors are:

APT_CombinedOperatorController,3: Failure during execution of operator logic.

APT_CombinedOperatorController,3: Fatal Error: Could not connect to datasourcereturn code -1 from SQLConnect(handle, infousr, ****, info_systest) with message [OpenLink][ODBC]unknown error
:


when the we run the job individually instead of the sequence it runs fine both in 1 node and 4 node

May be there is limitation on the no of connection you can make to your Progress database simulataneously. Hence when you run all the job parallely the no of connection requested from datastage is more than the limit specified at the database level. Please do check with DBA.