Timeout Expired

Harini · Post by **Harini** » Mon Nov 22, 2010 1:03 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Nov 22, 2010 1:31 am

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

Harini · Post by **Harini** » Mon Nov 22, 2010 2:56 am

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

ArndW · Post by **ArndW** » Mon Nov 22, 2010 3:24 am

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)?

Harini · Post by **Harini** » Mon Nov 22, 2010 7:02 am

Hi ArndW,

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

Write Method : Write
Write Mode :Append

Thanks

ArndW · Post by **ArndW** » Mon Nov 22, 2010 8:41 am

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.