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.
IIS-CONN-TERA-005057 problem loading Teradata
Moderators: chulett, rschirm, roy
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.
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.
pandeeswaran
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,
You will need to remove duplicates from your data before loading it.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.