After Successfully Running LOAD IDT > Getting Unique Key Error (Doc ID 1928819.1)

Last updated on APRIL 10, 2016

Applies to:

Siebel CRM - Version 8.1 [21039] and later
Information in this document applies to any platform.

Goal

After granting the permissions for the Siebel tables LOAD IDT Customer got unique key error as below


---------------
  1:0066 MG3600 060000 20140812175935
loadit> Error: Load IDT 'IDT_ACCOUNT' failed
loadit> ErrorLog: [812175935 18] loadit > It is now 20140812175935
loadit> ErrorLog: [812175935 18] loadit.c 4546 rc 4 9081403*100
loadit> ErrorLog: [812175935 18] error in loader_thread
loadit> ErrorLog: [812175935 18] loadit.c 3957 rc 3 60090814*100
loadit> ErrorLog: [812175935 18] loader_thread: process_loader_queue failed
loadit> ErrorLog: [812175935 18] loadit.c 3667 rc 14 110600908*100
loadit> ErrorLog: [812175935 18] loadit.c 3606 rc 8 381106009*100
loadit> ErrorLog: [812175935 18] Load IDT 'IDT_ACCOUNT' failed
loadit> ErrorLog: [812175935 18] Load IDT 'IDT_ACCOUNT' failed
loadit> ErrorLog: [812175935 18] dbldr.c 4903 rc 9 1381106*1000
loadit> ErrorLog: [812175935 18] dbops.c 5458 rc 6 13811*100
loadit> ErrorLog: [812175935 18] ssaodbc.c 24916 rc 11 138*100
loadit> ErrorLog: [812175935 18] ssadb8_ssaxld_record: create_pk_index failed
loadit> ErrorLog: [812175935 18] ssaodbc.c 24455 rc 38 1*100
loadit> ErrorLog: [812175935 18] ssadb8_create_pk_index: [03] Reason: [SSAOCI,2] Stmt: 'CREATE UNIQUE INDEX IDS_01_IDT_ACCOUNT_I1 ON IDS_01_IDT_ACCOUNT (IDS_RowId,IDS_PAccountAddressID,IDS_CL_ID)'
loadit> ErrorLog: [812175935 18] ssadb8_create_pk_index: [02] Reason: [SSAOCI,1] OCIStmtExecute ssaoci.c 3561 failed 'ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found'
loadit> ErrorLog: [812175935 18] ssadb8_create_pk_index: [01] SQLExecDirect ssaodbc.c 24445 failed SQLRET=-1 SQLSTATE=' ' NATIVE_ERR=0
loadit> ErrorLog: [812175935 18] ssadb8_create_pk_index: create unique index failed
loadit> ErrorLog: [812175935 18] Error creating IDT PK Index
loadit > Erro
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms