I am loading data from sequential file to SQL Server database. The Design of the job is,
SEQUENTIAL FILE->TRANSFORMER->ODBC
The job aborted due to the following error.
APT_CombinedOperatorController(1),0: [IBM(DataDirect OEM)][ODBC
SQL Server Driver][libssclient23]Timeout Expired.
The data in the sequential file is around 14 lakhs. Approximately 400000 records gets passed to transformer, and around 3,96000 records moved from transformer to ODBC.
The job ran for 6 mins and aborted. The source file has enough records. What could be the possible reason for the job to get timed out, since it has records to read and the source is not empty.
If the error is not reproduceable if you run with a single-node configuration, or repartition to your database key column, or commit each row then you might hazard a guess that you have a database deadlock issue at the heart of the problem.