Teradata Connector TPT- Sync Timeout errors
Posted: Fri Sep 03, 2010 2:57 pm
I am using Teradata connector with Bulk/Update using Parallel Syncronization on a 8 node Grid config. The job is some times failing with following error:
"Sync timeout of 200 seconds expired while waiting for the other instances to reach state 9,000 (CC_TeraAdapter::waitForState, file CC_TeraAdapter.cpp, line 5,816)"
When I looked at the sync table (created by Datastage job). it has primary index: SyncID and Uniqu Secondary Index: SyncID, PartitionNo, StartTime.
This sync table is standalone specific to this job.
Interestingly when ever the job fails with Sync timeout error, every time the Partition number =0 is in controlstate of 1006 and all other remaining 7 partitions in controlstate of 9000.
Please suggest what may be going wrong. At this point of time I am not sure if it is Datastage or Teradata.
Thanks.
"Sync timeout of 200 seconds expired while waiting for the other instances to reach state 9,000 (CC_TeraAdapter::waitForState, file CC_TeraAdapter.cpp, line 5,816)"
When I looked at the sync table (created by Datastage job). it has primary index: SyncID and Uniqu Secondary Index: SyncID, PartitionNo, StartTime.
This sync table is standalone specific to this job.
Interestingly when ever the job fails with Sync timeout error, every time the Partition number =0 is in controlstate of 1006 and all other remaining 7 partitions in controlstate of 9000.
Please suggest what may be going wrong. At this point of time I am not sure if it is Datastage or Teradata.
Thanks.