Error Loading tablehaving identity column with INSERT/SELECT using TPT DDL_OPERATOR

Tools
Fan

Error Loading tablehaving identity column with INSERT/SELECT using TPT DDL_OPERATOR

I am trying to load a target TABLE  having an IDENTITY column as an UPI from another table.  I am using INSERT/SELECT in a DDL operator however I am getting the following error

DDL_OPERATOR2: Rows Inserted: 1500000

DDL_OPERATOR2: RDBMS Warning: 5860  Values targeted at the Identity Column are replaced by system-generated numbers.

DDL_OPERATOR2: TPT10507: CLI Error 306: CLI2: BADPARCEL(306): Invalid parcel received.

DDL_OPERATOR2: disconnecting sessions

DDL_OPERATOR2: Total processor time used = '0.03 Second(s)'

DDL_OPERATOR2: Start : Tue Jan 31 03:18:19 2012

DDL_OPERATOR2: End   : Tue Jan 31 03:18:31 2012

Job step STEP2 terminated (status 12)

Job root terminated (status 12)

NOTE : The rows are  getting inserted in the table successfully though. Can anyone shed light on this TPT behavior?

2 REPLIES
Fan

Re: Error Loading tablehaving identity column with INSERT/SELECT using TPT DDL_OPERATOR

The INSERT/SELECT runs fine in SQL assistant. Also I am able to load tables which do not have an IDENTITY column just fine with the same code.

Teradata Employee

Re: Error Loading tablehaving identity column with INSERT/SELECT using TPT DDL_OPERATOR

I met with the exact same problem earlier today. I was using TPT (TTU 13.10) to load data into a TD14.0 database.

Once I upgraded to TPT (TTU 14.0) the error changed into just a warning and subsequent TPT steps were executed without any problems.


Teradata Parallel Transporter SQL DDL Operator Version 14.00.00.04

DDL_OPERATOR: private log specified: ddl_log07

DDL_OPERATOR: connecting sessions

DDL_OPERATOR: sending SQL requests

DDL_OPERATOR: RDBMS Warning: 5860 Values targeted at the Identity Column are rep laced by system-generated numbers.

DDL_OPERATOR: Rows Inserted: 5

DDL_OPERATOR: disconnecting sessions

DDL_OPERATOR: Total processor time used = '0.17 Second(s)'

DDL_OPERATOR: Start : Thu Oct 18 01:04:14 2012

DDL_OPERATOR: End   : Thu Oct 18 01:04:15 2012

Job step MERGE_INTO_CORE_TBL terminated (status 4)