ABAP IMPORT in error

[Former Member]

Dear All,

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(GSI) INFO: dbname = "QAS20090525050503 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "BCHQAS "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "BCHQAS"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 Service Pack 2"

(GSI) INFO: machine = "4x AMD64 Level 6 (Mod 23 Step 6)"

(DB) INFO: /BI0/E0PPM_VC1 created #20090528101413

(IMP) INFO: import of /BI0/E0PPM_VC1 completed (0 rows) #20090528101413

(DB) INFO: /BI0/E0PPM_VC1~0 created #20090528101413

(DB) INFO: /BI0/E0PPM_VC1~010 created #20090528101413

(DB) INFO: /BI0/E0PPM_VC1~020 created #20090528101413

(DB) INFO: /BI0/E0PPM_VC1~030 created #20090528101413

(DB) INFO: /BI0/E0PPM_VC1~040 created #20090528101413

DbSl Trace: Error 1408 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-1408 occurred when executing SQL stmt (parse error offset=55)

(DB) ERROR: DDL statement failed

(CREATE INDEX "/BI0/E0PPM_VC1~P" ON "/BI0/E0PPM_VC1" ( "KEY_0PPM_VC1P" , "KEY_0PPM_VC1T" , "KEY_0PPM_VC1U" , "KEY_0PPM_VC11" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 65536 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 1408)

error message returned by DbSl:

ORA-01408: such column list already indexed

(DB) INFO: disconnected from DB

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090528101413

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090528103013

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(GSI) INFO: dbname = "QAS20090525050503 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "BCHQAS "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "BCHQAS"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 Service Pack 2"

(GSI) INFO: machine = "4x AMD64 Level 6 (Mod 23 Step 6)"

(DB) ERROR: DDL statement failed

(DROP INDEX "/BI0/E0PPM_VC1~P")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

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

DbSl Trace: Error 1408 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-1408 occurred when executing SQL stmt (parse error offset=55)

(DB) ERROR: DDL statement failed

(CREATE INDEX "/BI0/E0PPM_VC1~P" ON "/BI0/E0PPM_VC1" ( "KEY_0PPM_VC1P" , "KEY_0PPM_VC1T" , "KEY_0PPM_VC1U" , "KEY_0PPM_VC11" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 65536 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 1408)

error message returned by DbSl:

ORA-01408: such column list already indexed

(DB) INFO: disconnected from DB

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090528103014

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090528103708

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(GSI) INFO: dbname = "QAS20090525050503 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "BCHQAS "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "BCHQAS"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 Service Pack 2"

(GSI) INFO: machine = "4x AMD64 Level 6 (Mod 23 Step 6)"

(DB) ERROR: DDL statement failed

(DROP INDEX "/BI0/E0PPM_VC1~P")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

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

DbSl Trace: Error 1408 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-1408 occurred when executing SQL stmt (parse error offset=55)

(DB) ERROR: DDL statement failed

(CREATE INDEX "/BI0/E0PPM_VC1~P" ON "/BI0/E0PPM_VC1" ( "KEY_0PPM_VC1P" , "KEY_0PPM_VC1T" , "KEY_0PPM_VC1U" , "KEY_0PPM_VC11" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 65536 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 1408)

error message returned by DbSl:

ORA-01408: such column list already indexed

(DB) INFO: disconnected from DB

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090528103708

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090528104002

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8

(GSI) INFO: dbname = "QAS20090525050503 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "BCHQAS "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "BCHQAS"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 Service Pack 2"

(GSI) INFO: machine = "4x AMD64 Level 6 (Mod 23 Step 6)"

(DB) ERROR: DDL statement failed

(DROP INDEX "/BI0/E0PPM_VC1~P")

DbSlExecute: rc = 103

(SQL error 1418)

error message returned by DbSl:

ORA-01418: specified index does not exist

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

DbSl Trace: Error 1408 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-1408 occurred when executing SQL stmt (parse error offset=55)

(DB) ERROR: DDL statement failed

(CREATE INDEX "/BI0/E0PPM_VC1~P" ON "/BI0/E0PPM_VC1" ( "KEY_0PPM_VC1P" , "KEY_0PPM_VC1T" , "KEY_0PPM_VC1U" , "KEY_0PPM_VC11" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 65536 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )

DbSlExecute: rc = 99

(SQL error 1408)

error message returned by DbSl:

ORA-01408: such column list already indexed

(DB) INFO: disconnected from DB

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090528104002

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090528104224

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DbSl Trace: CONNECT failed with sql error '12541'

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DbSl Trace: CONNECT failed with sql error '12541'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DbSl Trace: CONNECT failed with sql error '12541'

DbSl Trace: OCI-call 'OCIServerAttach' failed with rc=12541

DbSl Trace: CONNECT failed with sql error '12541'

(DB) ERROR: DbSlErrorMsg rc = 99

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090528104228

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090528104401

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090528104401

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090528104442

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090528104442

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090528113749

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090528113749

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090528114151

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT.cmd -dbcodepage 4103 -l SAPDFACT.log -stop_on_error

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: OCI-call 'OCISessionBegin' failed with rc=1034

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

D:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090528114151

Regard's

vinod

[Former Member · Accepted solution]

Hi,

Check your Database Listner is running or not. if it is not running then start it with lsnrctl start command.

check database status also. is it running or not. if not then start it with dbstart command on sql prompt by sys user.

Thanks

Presu

[Former Member]

if it is related to Index then log on at Sql Prompt drop the index or rebuild the index of that table of respective columns.

Thanks

[markus_doehr2]

Is this a migration? If yes, then you forgot to run SMIGR_CREATE_DDL before the export...

Markus

[Former Member]

Restart the Oracle listener and try again..

Mahesh

[former_member204746]

restarting the listener WILL NOT help.

error is:

ORA-01408: such column list already indexed

This means that another index has the same columns as the one trying to be created.

[former_member10630]

Can you summarise this error?

Regards,

Ankit Baphna