error during import from ase to ase db

[former_member641698]

Hi,

While we are importing the sap, we get below error. the import phase cannot create the OCSCMPLOBJ~0 index. You can have a look at the full logs below

A2 ETSK 005 Starting create for object "OCSCMPLOBJ~0" of type "primary index" #20210328124906 A2 EIMP 004 OCSCMPLOBJ~0 dropped #20210328124906 A1EEIMP 008 Task failed with error: (SYB) DDL statement failed A1EEIMP 008 (CREATE UNIQUE INDEX "OCSCMPLOBJ~0" A1EEIMP 008 ON "OCSCMPLOBJ" A1EEIMP 008 ( "TRKORR" , "AS4POS" ) A1EEIMP 008 with consumers = 3, statistics hashing) A1EEIMP 008 DbSlExecute: rc = 99 A1EEIMP 008 (SYB) (SQL error 5702) A1EEIMP 008 Error message returned by DbSl: A1EEIMP 008 (SYB) SQL error = 5702 A1EEIMP 008 (SYB) [ASE Error SQL5702]ASE is terminating this process. A2EETSK 012 Finished create for object "OCSCMPLOBJ~0" of type "primary index" with error in 9.67 sec #20210328124916 A2 ETSK 013 ------------------------------------------------------------------ A2 ETSK 005 Starting create for object "OCSCMPLOBJ~TA1" of type "index" #20210328124916 A1WEIMP 002 Ignoring failed drop: (SYB) DDL statement failed A1WEIMP 002 (DROP INDEX "OCSCMPLOBJ"."OCSCMPLOBJ~TA1") A1WEIMP 002 DbSlExecute: rc = 99 A1WEIMP 002 (SYB) (SQL error 30273) A1WEIMP 002 Error message returned by DbSl: A1WEIMP 002 (SYB) SQL error = 30273 A1WEIMP 002 (SYB) [ASE Error SQL30273:08003][SAP][ASE ODBC Driver]Attempting to use a dead connection in Commit. A1EEIMP 008 Task failed with error: (SYB) DDL statement failed A1EEIMP 008 (CREATE INDEX "OCSCMPLOBJ~TA1" A1EEIMP 008 ON "OCSCMPLOBJ" A1EEIMP 008 ( "PGMID" , "OBJECT" , "OBJ_NAME" , "TRKORR" ) A1EEIMP 008 with consumers = 3, statistics hashing) A1EEIMP 008 DbSlExecute: rc = 99 A1EEIMP 008 (SYB) (SQL error 30273) A1EEIMP 008 Error message returned by DbSl: A1EEIMP 008 (SYB) SQL error = 30273 A1EEIMP 008 (SYB) [ASE Error SQL30273:08003][SAP][ASE ODBC Driver]Attempting to use a dead connection in Commit. A2EETSK 012 Finished create for object "OCSCMPLOBJ~TA1" of type "index" with error in 0.00 sec #20210328124916 A2 ETSK 013 ------------------------------------------------------------------ A1 EGEN 002 ==================================================== A1 EDMP 008 Resource usage: GENERAL times: 0.437/ 0.031/ 0.141 4.3%/50.0%/100.0% real/usr/sys A1 EDMP 008 Resource usage: DATABASE times: 9.681/ 0.031/ 0.000 95.7%/50.0%/ 0.0% real/usr/sys A1 EDMP 007 Memory usage: 24/0/0 MB buffer/objectcache/disk (1 reused buffers) A1EEGEN 000 A1EEGEN 026 Number of error(s): 2 A1EEGEN 027 Exit code: "8" A1 EGEN 005 C:\Program Files\sapinst_instdir\BS2013SR2\ERP607SR2\SYB\COPY\SYSTEM\STD\AS-ABAP\R3load.exe: END OF LOG: 20210328124916

[hrollizo]

Hi,

maybe you index is corrupted. Before continue, make a DB backup.

Try to rebuild using something like this:

1. Create the unique temporary new index on table OCSCMPLOBJ~0.
create index idx_tmp on OCSCMPLOBJ~0(add here your index fields like MSG_ID, DIRECTION, LOG_LOCATION)
go

2. Get the name of primary key, so that we can drop it.

sp_helpconstraint OCSCMPLOBJ~0
go


3. Drop the Primary Key from table OCSCMPLOBJ~0
-- replace the “PRIMARY_NAME” with real PK‘s name we get above

alter table OCSCMPLOBJ~0 drop constraint PRIMARY_NAME

4. Recreate the primary key

alter table OCSCMPLOBJ~0 add constraint PRIMARY_NAME primary key(add here your index fields like MSG_ID, DIRECTION, LOG_LOCATION)

5.Check the PK is created

sp_helpconstraint OCSCMPLOBJ~0

6. Drop the temporary index from OCSCMPLOBJ~0

drop index OCSCMPLOBJ~0.idx_tmp

Best regards

[former_member641698]

Thank you guys the error has been solved. I cancelled the OCSCMPLOBJ step during the import. so there was a OCSCMPLOBJ packets in the export file. I took them out after that I repeat the step again and it worked. When the import has been done, Ive created the index by myself in the sap