Installation (Error in ABAP Import Phase )

[Former Member]

Hi All,

I am getting the following error at Import ABAP phase when performing the system copy function (Import) via ./sapinst ( OS - LINUX and DATABASE-ORACLE 10g)...

In Abap import phase , it shows 81 jobs,out of which 79 jobs run successfully but last two jobs are hangs.

the log shows the below mentioned information :

[root@isrxi AS-ABAP]# cat import_monitor.java.log

java version "1.4.2"

Java(TM) 2 Runtime Environment, Standard Edition (build 2.2)

IBM J9SE VM (build 2.2, J2RE 1.4.2 IBM J9 2.2 Linux amd64-64 j9xa64142ifx-20070808 (JIT enabled)

J9VM - 20070807_1500_LHdSMr

JIT - r7_level20070315_1745)

Import Monitor jobs: running 1, waiting 1, completed 79, failed 0, total 81.

Loading of 'SAPDFACT' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 79, failed 1, total 81.

Kindly suggest for the same.

Regards,

Amit

[Former Member · Accepted solution]

Hi,

You can do onething.. in the sapinst dir log files check for the SAPDFACT.TSk.. in this task file check for the err status.. change it to ok.. and run the installation again.. Hope this will helps.

Mahesh C

[Former Member · Accepted solution]

Hi Mahesh,

This is the SAPDFACT LOG;

[root@isrxi AS-ABAP]# tailf SAPDFACT.log

(CREATE INDEX "/BI0/E0FIAP_C03~P" ON "/BI0/E0FIAP_C03" ( "KEY_0FIAP_C03P" , "KEY_0FIAP_C03T" , "KEY_0FIAP_C03U" , "KEY_0FIAP_C031" , "KEY_0FIAP_C032" , "KEY_0FIAP_C033" , "KEY_0FIAP_C034" , "KEY_0FIAP_C035" , "KEY_0FIAP_C036" , "KEY_0FIAP_C037" ) TABLESPACE PSAPSR3FACT 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

/usr/sap/RXT/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/RXT/SYS/exe/run/R3load: END OF LOG: 20090105173026

From where I change the status OK as per your mail.

Regards,

Amit

[Former Member · Accepted solution]

Hi,

In sapinst dir you can find SAPDFACT.TSK file.. check in that where is the err status and change it to OK..

Mahesh

[former_member204746 · Accepted solution]

try this:

sqlplus / as sysdba

try one of the two:

connect sapr3/password

connect saprxt/password

select index_name from dba_indexes where index_name like '/BI0/E0FIAP_C03%';

supply results.

do not bypass checking as suggested earlier. find a real solution.

[Former Member · Accepted solution]

Hi Eric,

Yes you are right.. I think it was trying to creating an index on the same field which was created earlier on the same fileld. I am not supposed to give a wrong solutions in future i will try to give a appropriate suggestion.

Mahesh

[Former Member · Accepted solution]

Hi Eric,

This is the result of command send by you.

SQL> connect sapsr3

Enter password:

Connected.

SQL> select index_name from dba_indexes where index_name like '/BI0/E0FIAP_C03%';

INDEX_NAME

-

---

/BI0/E0FIAP_C03~0

/BI0/E0FIAP_C03~01

/BI0/E0FIAP_C03~02

/BI0/E0FIAP_C03~03

/BI0/E0FIAP_C03~04

/BI0/E0FIAP_C03~05

/BI0/E0FIAP_C03~06

/BI0/E0FIAP_C03~07

/BI0/E0FIAP_C03~08

/BI0/E0FIAP_C03~09

/BI0/E0FIAP_C03~10

11 rows selected.

Kindly suggest the same.

regards,

Amit

[former_member204746 · Accepted solution]

this is a BW system? index "0" should not be created.

try this:

drop index "/BI0/E0FIAP_C03~0";

then, try again.

[Former Member · Accepted solution]

Dear Eric and Mahesh,

Thanx for your kind support.Now the problem is solved by the suggestion provided by you.

Regards,

Amit

[Former Member · Accepted solution]

Dear Eric/Mahesh,

But now I m stuck in last step Run Abap Reports.Kindly find the log for the error.

-rw-r----- 1 root sapinst 947 Jan 6 09:58 dev_rfc.trc

-rw-r----- 1 root sapinst 69K Jan 6 09:58 controllerKdbClient.dmp

[root@isrxi AS-ABAP]# more dev_rfc.trc

• ERROR file opened at 20090105 200343 IST, SAP-REL 700,0,47 RFC-VER 3 814228

MT-SL

T:46912508409888 ======> >>>>>>>>>>> DB-Error - 0

T:46912508409888 <* RfcReceive [1] : returns 3:RFC_SYS_EXCEPTION

T:46912508409888 ======> >>>>>>>>>>> DB-Error - 0

T:46912508409888 <* RfcReceive [2] : returns 3:RFC_SYS_EXCEPTION

>TS> Tue Jan 6 09:30:41 2009

T:46912508409888 ======> >>>>>>>>>>> DB-Error - 0

T:46912508409888 <* RfcReceive [3] : returns 3:RFC_SYS_EXCEPTION

T:46912508409888 ======> >>>>>>>>>>> DB-Error - 0

T:46912508409888 <* RfcReceive [4] : returns 3:RFC_SYS_EXCEPTION

• ERROR file opened at 20090106 095845 IST, SAP-REL 700,0,47 RFC-VER 3 814228

MT-SL

T:46912508409888 ======> Exception condition "WRITE_FAILED" raised.

T:46912508409888 <* RfcReceive [2] : returns 3:RFC_SYS_EXCEPTION

T:46912508409888 <* RfcCallReceive [2] : returns 3:RFC_SYS_EXCEPTION

>TS> Tue Jan 6 10:25:12 2009

T:46912508409888 ======> Exception condition "WRITE_FAILED" raised.

T:46912508409888 <* RfcReceive [3] : returns 3:RFC_SYS_EXCEPTION

T:46912508409888 <* RfcCallReceive [3] : returns 3:RFC_SYS_EXCEPTION

Regards,

Amit

[former_member204746 · Accepted solution]

update your kernel and its DB library. it should resolve your problem.

and... you should have started a new topic as this one is resolved.

[Former Member · Accepted solution]

HI Eric,

As per your suggestion I have dropped the indexes as shown in SAPDFACT.TSK files.

I have dropped following indexes and then retry

drop index "/BI0/E0RSTT_C02~0"

drop index "/BI0/E0RSTT_C05~0"

drop index "/BI0/E0RSTT_C06~0"

drop index "/BIC/EZEMPLOYEE~0"

Then ABAP IMPORT PASE IS COMPLETED WITHOUT ANY ERROR.

Regards,

Amit

[Former Member · Accepted solution]

I got the same issue.

It works, thank you. Mahesh

If you find errors like below in the log file, then this will helps.

-

---

error message returned by DbSl:

ORA-01408: such column list already indexed

(DB) INFO: disconnected from DB

-

---

Regards

[former_member204746]

check for file contents of SAPDFACT.log

This is probably due to some kind of Oracle error such as tablespace full, out of shared memory or missing constraint.