any one plz give me brief explain about this error

Tools & Utilities
Enthusiast

any one plz give me brief explain about this error

iam trying to load data in set and multiset tables with mload ( i tried both ways)

i am getting the following error..

**** 00:35:00 UTY0805 RDBMS failure, 2801: Duplicate unique prime key error in databasename_tablename_Log.
12 REPLIES
Enthusiast

Re: any one plz give me brief explain about this error

Hi,
What you should look at is that you have probably set the Table with a UPI. No matter whether it is SET or MULTISET, if a UPI is set on the table, it will not accept duplicate values for the keys defined in the Primary Index if it is assigned as UNIQUE. Follow one of the 2 approaches:
1. Remove UPI and make it PI and load the data. It should load fine
2. Find th duplicate data row and eliminate it and then load. That way the remaining data will load.
Use appropriate method as this may affect the data you are loading.
Enthusiast

Re: any one plz give me brief explain about this error

Hi,
thank you for the reply..
but i tried PI with set table and PI with multiset table also, i am getting the same error,
and second solution I have 2 millions of records in my source file(txt), plz let me know if there is an easy way to find the duplicate records.
Enthusiast

Re: any one plz give me brief explain about this error

Hi,
I am not sure if this issue is with the data or the logging. Can you please drop all UV, ET, LG and WT tables, release mload on the table and start the job again and try. Let me know what happens. If it still fails, please look at the Log file and paste the exact error message you see with Failure code and we can trace this back to its source.
Enthusiast

Re: any one plz give me brief explain about this error

Hi,
thank you for immediate reply
i dropped UV,ET,WT,LOG and table also and i recreate the table againg
now iam trying to load only one record also getting the same error msg

Enthusiast

Re: any one plz give me brief explain about this error

If you have duplicates in the input file, they will go to the error table - not give a duplicate table violation.

Table databasename_tablename_Log. Is this the LG table for mload, or is this a table you use to record mload progress?
Send the mload output if you still have a problem.
Enthusiast

Re: any one plz give me brief explain about this error

This is very strange, wouldlike to see the mload script. Please paste here.
Enthusiast

Re: any one plz give me brief explain about this error

Can you post the actual error message you are getting...
Enthusiast

Re: any one plz give me brief explain about this error

this the error msg

**** 00:35:00 UTY0805 RDBMS failure, 2801: Duplicate unique prime key error in
database.table_Log.
========================================================================
= =
= Logoff/Disconnect =
= =
========================================================================
**** 00:35:02 UTY6212 A successful disconnect was made from the RDBMS.
**** 00:35:02 UTY2410 Total processor time used = '0.3125 Seconds'
. Start : 00:34:35 - THU NOV 19, 2009
. End : 00:35:02 - THU NOV 19, 2009
. Highest return code encountered = '12'.

Enthusiast

Re: any one plz give me brief explain about this error

Please also paste mload script and show table output of target table