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
Timeout Expired
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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)?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>