teradata connector stage

[ramesh_inform]

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.

[ramesh_inform]

when i tried to view performance statistics it is showing 1080105 records got loaded.

I could see only 1077570 records from the table(select count(*) from tablename)

[hamzaqk]

in which error tables are the record going in ? i think its error table one which means you have data issues. if its going in error table 2 then they are duplicates.

[toshea]

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.

[Ashwini]

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.