Import ABAP error in ECC6 system copy targert

[Former Member]

Hi Experts,

I am istalling SAP Ecc 6 in System copy targrt, ABAP import fail in 2/87. I got the error Loading of 'SAPDFACT' import package: ERRORImport Monitor jobs.

My OS Windows 2003 64 bit and Oracle 10.2. Please find the log files belo. Please help me to solve this issue

:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20100325173244

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

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

Compiled Jul 17 2007 00:40:17

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe -ctf I H:\MVGK IDESBackup-march2010\ABAP\DATA\SAPDFACT.STR C:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS\DDLORA.TPL SAPDFACT.TSK ORA -l SAPDFACT.log

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: job completed

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100325173244

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20100325173244

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

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

Compiled Jul 17 2007 00:40:17

G:\usr\sap\AT2\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 = "AT220100325020343 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "KENKI "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "KENKI"

(GSI) INFO: release = "5.2"

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

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

(DB) INFO: /BI0/E0RSTT_C01 created #20100325173245

(IMP) INFO: import of /BI0/E0RSTT_C01 completed (0 rows) #20100325173245

(DB) INFO: /BI0/E0RSTT_C01~0 created #20100325173245

(DB) INFO: /BI0/E0RSTT_C01~01 created #20100325173245

(DB) INFO: /BI0/E0RSTT_C01~02 created #20100325173245

(DB) INFO: /BI0/E0RSTT_C01~04 created #20100325173245

(DB) INFO: /BI0/E0RSTT_C01~05 created #20100325173245

(DB) INFO: /BI0/E0RSTT_C01~06 created #20100325173245

(DB) INFO: /BI0/E0RSTT_C01~07 created #20100325173245

(DB) INFO: /BI0/E0RSTT_C01~08 created #20100325173245

(DB) INFO: /BI0/E0RSTT_C01~09 created #20100325173245

(DB) INFO: /BI0/E0RSTT_C01~10 created #20100325173245

(DB) INFO: /BI0/E0RSTT_C01~11 created #20100325173245

(DB) INFO: /BI0/E0RSTT_C01~12 created #20100325173245

(DB) INFO: /BI0/E0RSTT_C01~13 created #20100325173245

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=57)

(DB) ERROR: DDL statement failed

(CREATE INDEX "/BI0/E0RSTT_C01~P" ON "/BI0/E0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" ) 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

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

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100325173245

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20100325174158

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

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

Compiled Jul 17 2007 00:40:17

G:\usr\sap\AT2\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 = "AT220100325020343 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "KENKI "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "KENKI"

(GSI) INFO: release = "5.2"

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

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

(DB) ERROR: DDL statement failed

(DROP INDEX "/BI0/E0RSTT_C01~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=57)

(DB) ERROR: DDL statement failed

(CREATE INDEX "/BI0/E0RSTT_C01~P" ON "/BI0/E0RSTT_C01" ( "KEY_0RSTT_C01P" , "KEY_0RSTT_C01T" , "KEY_0RSTT_C01U" , "KEY_0RSTT_C011" , "KEY_0RSTT_C012" , "KEY_0RSTT_C013" , "KEY_0RSTT_C014" , "KEY_0RSTT_C015" , "KEY_0RSTT_C016" , "KEY_0RSTT_C017" , "KEY_0RSTT_C018" , "KEY_0RSTT_C019" , "KEY_0RSTT_C01A" ) 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

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

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100325174158

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20100325180802

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

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

Compiled Jul 17 2007 00:40:17

G:\usr\sap\AT2\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

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

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100325180808

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20100325182246

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

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

Compiled Jul 17 2007 00:40:17

G:\usr\sap\AT2\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

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

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100325182251

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20100325183259

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

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

Compiled Jul 17 2007 00:40:17

G:\usr\sap\AT2\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

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

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100325183304

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20100326100904

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

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

Compiled Jul 17 2007 00:40:17

G:\usr\sap\AT2\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

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

G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100326100910

Thanks in Advance

Jose H

[Former Member]

Hi,

The way I am reading your log file is that your R3loads were doing there job until and R3load went over with

1408 in exec_immediate() from oci_execute_stmt(), orpc=0 DbSl Trace: ORA-1408 occurred when executing SQL stmt (parse error offset=57) (DB) ERROR: DDL statement failed (CREATE INDEX "/BI0/E0RSTT_C01~P" ON 

I have seen this before(duplicate, already there) never understood why why doing a fresh DB install from an export Dump does this.

I have alsways commented these to 'OK' in the TSK file and continued.....

But then it seems your database disappeared hence the rest of the R3loads went over with the OCI failures

Mark

[Former Member]

Hi,

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 G:\usr\sap\AT2\SYS\exe\uc\NTAMD64\R3load.exe: 
job finished with 1 error(s)

Check if the following environment variables are set:

ORACLE_HOME

ORACLE_SID

DBMS_TYPE,

dbs_ora_schema,

dbs_ora_tnsname,

NLS_LANG,

Next thing, check the if the LISTENER service is running....

Try to login to database using "sqlplus / as sysdba" and see if the database is running or not...

Then retry the installation.

If it again fail, STOP the installation and START it again with "Continue Old Installation" Option...

Regards.

Rajesh Narkhede

[Former Member]

Hi Rajesh,

Listener is running , and checked the database also data base is in idle mode. How to check the environment variable and what is the command adn which file i have to check

Please guide me how to solve this issue

Thanks in Advance

Jose H

[Former Member]

Hi,

You can check the defined enviornment variable using command prompt and System properties.

Open Command Prompt and give "set" command. It will show you active environment variable.

You can also set missing environment variables in system properties.

Start -->Control Panel --> System

On Advanced Tab --> Environment Variables.

After logging to the database if it shows message "Connected to idle instance", that means your database is not started.

Please start the database using below SQL command.

Open Command Prompt
C:\Sqlplus / as sysdba
SQL>startup

Once it says "Database opened", retry SAP installation.

You can also check the database status in SQL prompt using below command:

SQL> select instance_name,status from v$instance;

It must show output like:

INSTANCE_NAME    STATUS
---------------- ------------
<SID>              OPEN

Regards.

Rajesh Narkhede