cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

IDES installation error

Former Member

on ‎06-05-2009 8:28 AM

0 Kudos

Hi,

I am installing ECC6SR3 IDES on NT-32bit. I am installing IDES according to Note 1244548 using saytem copy. I am getting an error in ABAP import pahse after 98 jobs have been completed.I am pasting few error logs from failed jobs.

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC
(DB) ERROR: DDL statement failed
 (DROP INDEX "STERM_REF~0")
 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 1452 in exec_immediate() from oci_execute_stmt(), orpc=0

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

(DB) ERROR: DDL statement failed
 (CREATE UNIQUE INDEX "STERM_REF~0" ON "STERM_REF" ( "CONCEPT", "OBJECT", "OBJ_NAME" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 24148656 NEXT 0000000080K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )
 DbSlExecute: rc = 99
  (SQL error 1452)
  error message returned by DbSl:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
(DB) INFO: disconnected from DB

SAPSSEXC_3.log errorLOG
**************************
DbSl Trace: Error 1452 in exec_immediate() from oci_execute_stmt(), orpc=0

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

(DB) ERROR: DDL statement failed
 (CREATE UNIQUE INDEX "DOKIL~0" ON "DOKIL" ( "ID", "OBJECT", "LANGU", "TYP" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 634245361 NEXT 0000000640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )
 DbSlExecute: rc = 99
  (SQL error 1452)
  error message returned by DbSl:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

I have also tried to find duplicate entry but did not get success.

SQL> desc DOKIL;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 ID                                        NOT NULL VARCHAR2(2)
 OBJECT                                    NOT NULL VARCHAR2(60)
 LANGU                                     NOT NULL VARCHAR2(1)
 TYP                                       NOT NULL VARCHAR2(1)
 VERSION                                   NOT NULL VARCHAR2(4)
 MASTERLANG                                NOT NULL VARCHAR2(1)
 TXTLINES                                  NOT NULL VARCHAR2(5)
 DOKSTATE                                  NOT NULL VARCHAR2(1)
 SELFDEF                                   NOT NULL VARCHAR2(1)

SQL> select alldata.rowid, alldata.*
  2    from SAPSR3.DOKIL alldata,
  3         (SELECT ID,OBJECT,LANGU,TYP,VERSION,MASTERLANG,TXTLINES,DOKSTATE,SEL
FDEF FROM SAPSR3.DOKIL GROUP BY ID,OBJECT,LANGU,TYP,VERSION,MASTERLANG,TXTLINES,
DOKSTATE,SELFDEF
  4                        HAVING COUNT(*) > 1) keydata
  5    where alldata.ID=keydata.ID
  6      and alldata.OBJECT=keydata.OBJECT and alldata.TYP=keydata.TYP and allda
ta.VERSION=keydata.VERSION and alldata.MASTERLANG=keydata.MASTERLANG and alldata
.TXTLINES=keydata.TXTLINES and alldata.DOKSTATE=keydata.DOKSTATE and alldata.SEL
FDEF=keydata.SELFDEF;

no rows selected

I have also tried to drop & recreate unique index at sql level.But i did not get success.

SQL> drop index "DOKIL~0";
drop index "DOKIL~0"
           *
ERROR at line 1:
ORA-01418: specified index does not exist

SQL> CREATE UNIQUE INDEX "DOKIL~0" ON "DOKIL" ( "ID", "OBJECT", "LANGU", "TYP" )
 TABLESPACE PSAPSR3700 STORAGE (INITIAL 634245361 NEXT 0000000640K MINEXTENTS 00
00000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS
  2  ;
CREATE UNIQUE INDEX "DOKIL~0" ON "DOKIL" ( "ID", "OBJECT", "LANGU", "TYP" ) TABL
ESPACE PSAPSR3700 STORAGE (INITIAL 634245361 NEXT 0000000640K MINEXTENTS 0000000
001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS
                                 *
ERROR at line 1:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

Thanks & Regards

Rudra

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
‎06-16-2009 5:56 AM
0 Kudos

Hi All,

sorry for late reply. I have reinstall from scratch . Now IDES is installed successfully. Thanks all of you for help.

Regards

Rudra

Show replies
Show replies
Former Member
‎06-06-2009 9:36 AM
0 Kudos

Try

drop index sapsr3."DOKIL~0";

Show replies
Show replies
Former Member
‎06-06-2009 6:30 AM
0 Kudos

Hi,

Any idea/solution for this problem.

Regards

Rudra

Show replies
Show replies
Former Member
‎06-06-2009 6:47 AM
0 Kudos

Can you post the sapinst.log , or if it so big get link to check it?

Try to check this link

I/m have such situation when using Rload import during homogeneous system copy, and for one of indexes i'm edit the corresponding TOC, TSK and STR-Files,

if you can better open OSS to SAP.

Regards.

Former Member
‎06-06-2009 8:12 AM
0 Kudos

Hi,

I am pasting sapinst logs

INFO 2009-06-05 12:23:43.656
Creating file C:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\x.

INFO 2009-06-05 12:23:43.656
Removing file C:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\x.

INFO 2009-06-05 12:23:45.875
Creating file C:\Program Files\sapinst_instdir\x.

INFO 2009-06-05 12:23:45.875
Removing file C:\Program Files\sapinst_instdir\x.

INFO 2009-06-05 12:23:48.187
Copied file 'C:/Program Files/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/statistic.xml' to 'C:/Program Files/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/statistic.9.xml'.

INFO 2009-06-05 12:23:50.125
Copied file 'C:/Program Files/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/statistic.xml' to 'C:/Program Files/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/statistic.10.xml'.

WARNING 2009-06-05 12:24:04.000
Unable to get information about path \\LABEL.ASC\ using GetVolumeInformation. Operating system error message: The filename, directory name, or volume label syntax is incorrect.

INFO 2009-06-05 12:24:08.828
Copied file 'C:/Program Files/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/inifile.xml' to 'C:/Program Files/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/inifile.4.xml'.

INFO 2009-06-05 12:24:09.109
Execute step 
Component  W2K_ServicePack_Check|ind|ind|ind|ind
Preprocess  of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_First_Steps|ind|ind|ind|ind|0|0|W2K_ServicePack_Check|ind|ind|ind|ind|2|0

Former Member
‎06-06-2009 8:13 AM
0 Kudos 
INFO 2009-06-05 12:24:17.125
Copied file 'C:/Program Files/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/keydb.xml' to 'C:/Program Files/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/keydb.4.xml'.

INFO 2009-06-05 12:24:17.281
Copied file 'C:/Program Files/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/statistic.xml' to 'C:/Program Files/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/statistic.11.xml'.

INFO 2009-06-05 12:24:17.375
Execute step runMigrationMonitor of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|5|0|NW_ABAP_Import|ind|ind|ind|ind|0|0

INFO 2009-06-05 12:24:22.140
Switched to user: idsadm.

INFO 2009-06-05 12:24:22.187
Creating file C:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\import_monitor.java.log.

INFO 2009-06-05 12:24:22.203
Switched to user: idsadm.

INFO 2009-06-05 12:24:22.234
Working directory changed to C:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP.

INFO 2009-06-05 12:24:22.234
Output of C:\j2sdk1.4.2_19\bin\java.exe -classpath migmon.jar -showversion -Xmx1024m com.sap.inst.migmon.imp.ImportMonitor -sapinst is written to the logfile import_monitor.java.log.

WARNING 2009-06-05 12:28:52.687
Execution of the command "C:\j2sdk1.4.2_19\bin\java.exe -classpath migmon.jar -showversion -Xmx1024m com.sap.inst.migmon.imp.ImportMonitor -sapinst" finished with return code 103. Output: 
java version "1.4.2_19"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_19-b04)
Java HotSpot(TM) Client VM (build 1.4.2_19-b04, mixed mode)
Import Monitor jobs: running 1, waiting 13, completed 98, failed 0, total 112.
Import Monitor jobs: running 2, waiting 12, completed 98, failed 0, total 112.
Import Monitor jobs: running 3, waiting 11, completed 98, failed 0, total 112.
Former Member
‎06-06-2009 8:15 AM
0 Kudos 
Loading of 'T100' import package: ERROR
Import Monitor jobs: running 2, waiting 11, completed 98, failed 1, total 112.
Import Monitor jobs: running 3, waiting 10, completed 98, failed 1, total 112.
Loading of 'RSMPTEXTS' import package: ERROR
Import Monitor jobs: running 2, waiting 10, completed 98, failed 2, total 112.
Import Monitor jobs: running 3, waiting 9, completed 98, failed 2, total 112.
Loading of 'D021T' import package: ERROR
Import Monitor jobs: running 2, waiting 9, completed 98, failed 3, total 112.
Import Monitor jobs: running 3, waiting 8, completed 98, failed 3, total 112.
Loading of 'SAPSSEXC_3' import package: ERROR
Import Monitor jobs: running 2, waiting 8, completed 98, failed 4, total 112.
Loading of 'SAPAPPL2_7' import package: ERROR
Import Monitor jobs: running 1, waiting 8, completed 98, failed 5, total 112.
Loading of 'RFBLG' import package: ERROR
Import Monitor jobs: running 0, waiting 8, completed 98, failed 6, total 112.
Import Monitor jobs: running 1, waiting 7, completed 98, failed 6, total 112.
Import Monitor jobs: running 2, waiting 6, completed 98, failed 6, total 112.
Import Monitor jobs: running 3, waiting 5, completed 98, failed 6, total 112.
Loading of 'SAPAPPL2_9' import package: ERROR
Import Monitor jobs: running 2, waiting 5, completed 98, failed 7, total 112.
Loading of 'SAPAPPL2_8' import package: ERROR
Import Monitor jobs: running 1, waiting 5, completed 98, failed 8, total 112.
Import Monitor jobs: running 2, waiting 4, completed 98, failed 8, total 112.
Import Monitor jobs: running 3, waiting 3, completed 98, failed 8, total 112.
Loading of 'SAPAPPL2_6' import package: ERROR
Import Monitor jobs: running 2, waiting 3, completed 98, failed 9, total 112.
Loading of 'SAPAPPL2_10' import package: ERROR
Import Monitor jobs: running 1, waiting 3, completed 98, failed 10, total 112.
Former Member
‎06-05-2009 8:58 AM
0 Kudos

Hi. Very unreadable format ... Can you recreate the meesage, and before posting presson "preview"

button.

P.S. provide information about your Oracle Release, patch level, the DVD paths from here you trying install your IDES : for example

D:\IDES_Master_dvd , and other.

Regards.

Show replies
Show replies
Former Member
‎06-05-2009 10:15 AM
0 Kudos

HI,

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

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

(DB) ERROR: DDL statement failed
 (CREATE UNIQUE INDEX "DOKIL~0" ON "DOKIL" ( "ID", "OBJECT", "LANGU", "TYP" ) TABLESPACE PSAPSR3700 STORAGE (INITIAL 634245361 NEXT 0000000640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )
 DbSlExecute: rc = 99
  (SQL error 1452)
  error message returned by DbSl:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

I have also tried to find duplicate entry but did not get success.

I have also tried to find duplicate entry but did not get success.

SQL> desc DOKIL;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 ID                                        NOT NULL VARCHAR2(2)
 OBJECT                                    NOT NULL VARCHAR2(60)
 LANGU                                     NOT NULL VARCHAR2(1)
 TYP                                       NOT NULL VARCHAR2(1)
 VERSION                                   NOT NULL VARCHAR2(4)
 MASTERLANG                                NOT NULL VARCHAR2(1)
 TXTLINES                                  NOT NULL VARCHAR2(5)
 DOKSTATE                                  NOT NULL VARCHAR2(1)
 SELFDEF                                   NOT NULL VARCHAR2(1)
SQL> select alldata.rowid, alldata.*
  2    from SAPSR3.DOKIL alldata,
  3         (SELECT ID,OBJECT,LANGU,TYP,VERSION,MASTERLANG,TXTLINES,DOKSTATE,SEL
FDEF FROM SAPSR3.DOKIL GROUP BY ID,OBJECT,LANGU,TYP,VERSION,MASTERLANG,TXTLINES,
DOKSTATE,SELFDEF
  4                        HAVING COUNT(*) > 1) keydata
  5    where alldata.ID=keydata.ID
  6      and alldata.OBJECT=keydata.OBJECT and alldata.TYP=keydata.TYP and allda
ta.VERSION=keydata.VERSION and alldata.MASTERLANG=keydata.MASTERLANG and alldata
.TXTLINES=keydata.TXTLINES and alldata.DOKSTATE=keydata.DOKSTATE and alldata.SEL
FDEF=keydata.SELFDEF;

no rows selected

I have also tried to drop & recreate unique index at sql level.But i did not get success.

SQL> drop index "DOKIL~0";
drop index "DOKIL~0"
           *
ERROR at line 1:
ORA-01418: specified index does not exist

Former Member
‎06-05-2009 10:19 AM
0 Kudos

Hi,

I have also tried to drop & recreate unique index at sql level.But i did not get success.

SQL> drop index "DOKIL~0";
drop index "DOKIL~0"
           *
ERROR at line 1:
ORA-01418: specified index does not exist

SQL> CREATE UNIQUE INDEX "DOKIL~0" ON "DOKIL" ( "ID", "OBJECT", "LANGU", "TYP" )
 TABLESPACE PSAPSR3700 STORAGE (INITIAL 634245361 NEXT 0000000640K MINEXTENTS 00
00000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS
  2  ;
CREATE UNIQUE INDEX "DOKIL~0" ON "DOKIL" ( "ID", "OBJECT", "LANGU", "TYP" ) TABL
ESPACE PSAPSR3700 STORAGE (INITIAL 634245361 NEXT 0000000640K MINEXTENTS 0000000
001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS
                                 *
ERROR at line 1:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

I am installing on oracle 10.2.0.2 & the DVD path is 

D:\ECC6IDES\masterSR3\SAP_ERP_6.0_SR3_IDES_Inst._Master\IM_WINDOWS_I386
sapinst.exe

Regards

Rudra

Former Member
‎06-05-2009 10:44 AM
0 Kudos

Can you explain how you do the installation step by step, and please past the all DVD paths as export and other. Are you have any error doing this installation before and you rerun it? Any other information , for example how much memory you have and SWAP space are ? Are you trying to retry ?Regards.

Former Member
‎06-05-2009 10:57 AM
0 Kudos

Hi,

I am installing IDES SR3 on NT-32 bit But we can not install SR3 on 64 bit by straight method. So i follow the Note 1244548-IDES ERP6.0 ECC 6.0 SR3.According to this note 

Now move all files from DVD2/EXP2/DATA to DVD1/EXP1/DATA
Now move all files from DVD3/EXP3/DATA to DVD1/EXP1/DATA

And change the LABEL.ASC

Change the text line in the file with an editor from
SAP:ECC:600SR3:EXPORT(1/11):Installation Export:CDxxxxxxxx_1
to
SAP:MIG:*:EXPORT(1/:*:*

Now i select the System copy>Target System Installatio>Based as ABAP-->central from installation master. AndWhen SAPinst asks for the 'Installation Method' choose

'Standard System Copy / Migration (load based)'

When SAPinst asks for the 'Migration Export' choose

the path to ../DVD1/EXP1'

Path of export DVD is D:\ECC6IDES\export\51034985_1\EXP1

Path of kernel D:\ECC6IDES\kernel\NW_7.0_SR3_Kernel_WINDOWS__LNX_X86\KN_WINDOWS_I386

No i did not get any error before.I did not rerun this installation.I have 6GB ram & 13GB swap space.

Regards

Rudra

Former Member
‎06-06-2009 8:21 AM
0 Kudos 
Loading of 'ATAB' import package: ERROR
Import Monitor jobs: running 0, waiting 3, completed 98, failed 11, total 112.
Import Monitor jobs: running 1, waiting 2, completed 98, failed 11, total 112.
Import Monitor jobs: running 2, waiting 1, completed 98, failed 11, total 112.
Loading of 'SAPSDIC_1' import package: ERROR
Import Monitor jobs: running 1, waiting 1, completed 98, failed 12, total 112.
Loading of 'SAPAPPL0_9' import package: ERROR
Import Monitor jobs: running 0, waiting 1, completed 98, failed 13, total 112.

ERROR 2009-06-05 12:28:52.687
CJS-30022  Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.

ERROR 2009-06-05 12:28:52.718
FCO-00011  The step runMigrationMonitor with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|5|0|NW_ABAP_Import|ind|ind|ind|ind|0|0|runMigrationMonitor was executed with status ERROR ( Last error reported by the step :Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.).

I search crossponding TSK file but i did not find STR & TOC file.I changed entry in TSK file & rerun the installation but i get the gollowing error

DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC
(TSK) ERROR: file C:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\SAPSSEXC_3.TSK.bck already seems to exist
             a previous run may not have been finished cleanly
             file C:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\SAPSSEXC_3.TSK possibly corrupted

Thanks & Regards

Former Member
‎06-06-2009 8:35 AM
0 Kudos

From your first post I thought that you have problem only for one Index, but for this last post you can check the 13 jobs are aborted, you have so more problem.

Are you have enough space on device ? about J2se version :

C:\j2sdk1.4.2_19 , for 64 bit platform it really not works 18 and 19 (some releases)

Note 716604 - Access to Sun J2SE and recommended J2SE options

, i do not know how it work on 32 bit , try to downgrade to 1.4.2_17 (or 13).

and restart ... On this time are Brtools available to check the tablespace size's or not?

Regards.

Ask a Question