IIS-CONN-TERA-005057 problem loading Teradata

bart12872 · Post by **bart12872** » Mon Jun 27, 2011 3:57 am

Hi,

I encounter the following error message

[IIS-CONN-TERA-005057] RDBMS code 2794 in error table 2 (CC_TeraAdapter::selectUpdateErrorTable2, file CC_TeraAdapter.cpp, line 7,883)

The database is Teradata version 12.
The loading is a Bulk.
The job run in production but can failed sometimes. Very strange.

thanks for your help.

pandeesh · Post by **pandeesh** » Mon Jun 27, 2011 4:57 am

This is the frequent error occured while doing mload.
The reason for this is unique constraint violation.
This error is very much similar to ORA-0001.

So find out, how that value already got inserted into the table.

Check is there any other jobs loading into the same table.

Let me know if you need any more information.

jwiles · Post by **jwiles** » Mon Jun 27, 2011 5:39 am

A simple <a href=http://www.google.com/search?sourceid=c ... >Google</a> would reveal to you that your data has duplicates.

You will need to remove duplicates from your data before loading it.

Regards,