SQL1505][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Create unique index aborted on duplicate key

394 Views

Hi All,

System copy export completed but while importing into the Target system getting below error.

Error:

(SQL error 3701)

error message returned by DbSl:

[ASE Error SQL3701][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Cannot drop the index '/BI0/F0SMD_PED1./BI0/F0SMD_PED1~0', because it doesn't exist in the system catalogs.

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "/BI0/F0SMD_PED1~0" ON "/BI0/F0SMD_PED1" ( "KEY_0SMD_PED1P", "KEY_0SMD_PED1T", "KEY_0SMD_PED1U", "KEY_0SMD_PED11", "KEY_0SMD_PED12", "KEY_0SMD_PED13", "KEY_0SMD_PED14", "KEY_0SMD_PED15", "KEY_0SMD_PED16", "KEY_0SMD_PED17", "KEY_0SMD_PED18", "KEY_0SMD_PED19" ) with sorted_data )

DbSlExecute: rc = 99

(SQL error 1505)

error message returned by DbSl:

[ASE Error SQL1505][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Create unique index aborted on duplicate key. Primary key is '18, 160, 0, 66, 31, 67, 4, 17, 175, 3, 2, 2'

Import Monitor jobs: running 1, waiting 1, completed 42, failed 0, total 44.

Loading of 'SAPDFACT_2' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 42, failed 1, total 44.

Please advice.

Regards,

Karthik