we are replacing DB2 stage with teradata connector stage.
the design is as follows
dataset--->modify----->teradata connector
Iam getting the following error.
CC_TeraAdapter::selectLoadErrorTable1, file CC_TeraAdapter.cpp, line 7,056) [pxbridge.C:2833
I observed the data and it is fine
I have 1080105 in the dataset i am able to load only 1077570 records and the job is getting aborted.
I've tested with few records say 7992 and iam able to load only 7970 records.
I even used replace table. but my attempt became futile.
teradata connector stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 57
- Joined: Mon Dec 03, 2007 12:43 am
- Location: hyderabad
teradata connector stage
ramesh.n.
-
- Participant
- Posts: 57
- Joined: Mon Dec 03, 2007 12:43 am
- Location: hyderabad
You should report the problem to IBM support. That error is not normal. The connector should have reported the error code retrieved from error table 1. Look in error table 1 to see what rows could not be loaded and what their errors were. If error table 1 was dropped, try setting the connector's Cleanup mode property to Keep.
Re: teradata connector stage
ramesh_inform wrote:we are replacing DB2 stage with teradata connector stage.
the design is as follows
dataset--->modify----->teradata connector
Iam getting the following error.
CC_TeraAdapter::selectLoadErrorTable1, file CC_TeraAdapter.cpp, line 7,056) [pxbridge.C:2833
I observed the data and it is fine
I have 1080105 in the dataset i am able to load only 1077570 records and the job is getting aborted.
I've tested with few records say 7992 and iam able to load only 7970 records.
I even used replace table. but my attempt became futile.
Please check the Job parameter default value thorougly. I had same problem after correcting them got resolve.
Thanks.