SAP Netweaver 7.0 / EHP3 Installation: Loading of 'DOKCLU' import package is interrupted with R3load error

[Former Member]

Hello all,

We are running on HP-UX 11.31 / Oracle 11. We are installing SAP SCM 7.0 EHP 2 which run On SAP Netweaver 7.0 EHP 3.

During the sapinst execution, Import ABAP Phase 17 / 31 we get the following error:

An error occurred while processing option Enhancement Package 2 for SAP SCM 7.0 > SAP Application Server ABAP > Oracle > Central System > Central System( 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

The when we look for the file import_monitor.java.log we get the next info:

Loading of 'SAPPOOL' import package: ERROR

Import Monitor jobs: running 2, waiting 1, completed 25, failed 1, total 29.

Loading of 'DOKCLU' import package: ERROR

Import Monitor jobs: running 1, waiting 1, completed 25, failed 2, total 29.

Loading of 'SAPAPPL0' import package: ERROR

Them we search for SAPPOOL.log, DOKCLU.log, SAPAPPL0.log

DOKCLU.log

version R7.20/V1.4 [UNICODE]
Compiled Aug 15 2011 20:32:12
/usr/sap/DWM/SYS/exe/run/R3load -i DOKCLU.cmd -dbcodepage 4102 -l DOKCLU.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): UTF16

....

....

.....

DbSl Trace: ORA-08103 occurred at SQL stmt (parse error offset=3080192)

myCluster (127.23.Imp): 706: error when retrieving field description for physical table DOKCLU.
myCluster (127.23.Imp): 709: return code received from nametab is 1
myCluster (127.23.Imp): 297: error when retrieving physical nametab for table DOKCLU.
(CNV) ERROR: data conversion failed.  rc = 2

SAPAPPL0.log

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file /SAPDVDDIR/SCM_Export/51041543/DATA_UNITS/EXP2/DB/SQLFiles.LST
(SQL) INFO: /SAPDVDDIR/SCM_Export/51041543/DATA_UNITS/EXP2/DB/SQLFiles.LST not found
(SQL) INFO: Searching for SQL file APPL0.SQL
(SQL) INFO: APPL0.SQL not found
(SQL) INFO: Searching for SQL file /SAPDVDDIR/SCM_Export/51041543/DATA_UNITS/EXP2/DB/ORA/APPL0.SQL
(SQL) INFO: /SAPDVDDIR/SCM_Export/51041543/DATA_UNITS/EXP2/DB/ORA/APPL0.SQL not found
(DB) ERROR: DDL statement failed
(DROP INDEX "STERM_LINK~002")
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 8103 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-08103 occurred at SQL stmt (parse error offset=2228224)

(DB) ERROR: DDL statement failed
(CREATE  INDEX "STERM_LINK~002" ON "STERM_LINK" ( "OBJECT_TYP" , "COUNTRY" , "INDUSTRY" , "FIRST_REL" , "LAST_REL"  ) TABLES
PACE PSAPSR3 STORAGE (INITIAL 0000000016K NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGG
ING COMPUTE STATISTICS )
DbSlExecute: rc = 99
  (SQL error 8103)
  error message returned by DbSl:
ORA-08103: object no longer exists
(DB) INFO: disconnected from DB

SAPPOOL.log

/usr/sap/DWM/SYS/exe/run/R3load -i SAPPOOL.cmd -dbcodepage 4102 -l SAPPOOL.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): UTF16
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file /SAPDVDDIR/SCM_Export/51041543/DATA_UNITS/EXP3/DB/SQLFiles.LST
(SQL) INFO: /SAPDVDDIR/SCM_Export/51041543/DATA_UNITS/EXP3/DB/SQLFiles.LST not found
(SQL) INFO: Searching for SQL file POOL.SQL
(SQL) INFO: POOL.SQL not found
(SQL) INFO: Searching for SQL file /SAPDVDDIR/SCM_Export/51041543/DATA_UNITS/EXP3/DB/ORA/POOL.SQL
(SQL) INFO: /SAPDVDDIR/SCM_Export/51041543/DATA_UNITS/EXP3/DB/ORA/POOL.SQL not found
(DB) INFO: ATAB created #20120525180013

DbSl Trace: Error 8103 in stmt_fetch() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-08103 occurred at SQL stmt (parse error offset=14221312)

failed to read short nametab of table AT30                           (rc=1)
(CNVPOOL) conversion failed for row 0 of table  VARKEY = M-cM-^@M-0M-cM-^@M-1M-bM-^@M- M-bM-^@M- M-bM-^@M- M-bM-^@M- M-bM-^@
M- M-bM-^@M- M-bM-^@M- M-bM-^@M- M-bM-^@M- M-bM-^@M- M-bM-^@M- M-bM-^@M- M-bM-^@M- M-bM-^@M- M-bM-^@M- M-bM-^@M- M-bM-^@M-
M-bM-^@M- M-bM-^@M- M-bM-^@M- M-bM-^@M- M-bM-^@M- M-bM-^@M-
(CNV) ERROR: data conversion failed.  rc = 2
(RSCP) INFO: environment variable "I18N_POOL_WIDTH" is not set. Checks are active.
(DB) INFO: disconnected from DB

We found the following:

Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Note 658095 - R3load: Unicode conversion of cluster tables

Note 1527078 - Inst.Systems Based on NW 7.0 EHP3 on UNIX/Oracle

Note 421554 - R3load: Problems when converting cluster tables

Note 902817 - Inconsistencies in cluster tables (log vs phys field name)

None of his notes appears to be 100% related with the error but we could extract from that updating R3load to the last version could help.

So, we updated it to from R3load 720_EXT_REL patch number 98 to patch number 210.

Running again SAPinst give us the same errors.

Any experience with this error before?

Best regards,

Erick Ilarraza

[Former Member]

Hi All,

We have a similar error

While installing CRM 7.0 EHP2 we got error for loading SAPPOOL abap

package.

Loading of 'SAPPOOL' import package: ERROR

ERROR: 2012-09-06 18:36:08 com.sap.inst.migmon.LoadTask run

Loading of 'SAPPOOL' import package is interrupted with R3load error.

Process '/usr/sap/CWB/SYS/exe/run/R3load -i SAPPOOL.cmd -dbcodepage

4103 -l SAPPOOL.log -stop_on_error' exited with return code 2.

For mode details see 'SAPPOOL.log' file.

Standard error output:

sapparam: sapargv(argc, argv) has not been called!

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

SAPPOOL.LOG

/usr/sap/CWB/SYS/exe/run/R3load: START OF LOG: 20120906221958

/usr/sap/CWB/SYS/exe/run/R3load: sccsid @(#)

$Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP

/usr/sap/CWB/SYS/exe/run/R3load: version R7.20/V1.4 [UNICODE]

Compiled Aug 15 2011 20:21:34

/usr/sap/CWB/SYS/exe/run/R3load -i SAPPOOL.cmd -dbcodepage 4103 -l

SAPPOOL.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): UTF16

(DB) INFO: ATAB deleted/truncated #20120906221959

DbSl Trace: Error 8103 in stmt_fetch() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-08103 occurred at SQL stmt (parse error offset=0)

failed to read short nametab of table DDSYN

(rc=1)

(CNVPOOL) conversion failed for row 362 of table DDPAMSCTRL VARKEY =

(CNV) ERROR: data conversion failed. rc = 2

(RSCP) INFO: environment variable "I18N_POOL_WIDTH" is not set. Checks

are active.

(DB) INFO: disconnected from DB

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

/usr/sap/CWB/SYS/exe/run/R3load: END OF LOG: 20120906221959

[former_member189725]

Please make sure provide full permission to the export DVDs .

Also update the R3load and DBSL to the latest patch level.

If that does not help , please download the DVDs again.

Regards

Ratnajit

[Former Member]

Hi Erick,

ensure that installation DVDs are not mounted via NFS / SMB to the server.

Otherwise, try to download files again as Ratnajit suggested.

Regards,

Peter

[former_member189725]

Can you please restart the database and restart the import . Also give full permission to the export DVDs .

Also try downloading the export DVDs again.

Regards

Ratnajit