DSXchange

Hello All,

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.

Please share your thoughts on getting this fixed.

Thanks

Hanging on locks (a lock?) in the database?

ray.wurlod wrote:Hanging on locks (a lock?) in the database? ...

May be .. But currently i do not have access, to the database. Will a job re-run help?

Thanks

Yes, re-running might help to diagnose the problem. Are you running on a 1-node configuration file or more? Are you inserting or updating (or both)?

Hi ArndW,

Yes, it is a multi node configuration job. And it is an insert to database.

Write Method : Write
Write Mode :Append


Thanks

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.