Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
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: 
Read only

ERROR in the ABAP Import Phase - Unicode Migration

Former Member

‎2009 Aug 03 5:30 PM

0 Likes
1,279

Helllo All,

We are doing a unicode migration for Netweaver 2004s system with the following error(BI7)

DB) INFO: BALDAT created #20090803110510

(IMP) INFO: import of BALDAT completed (2307674 rows) #20090803110648

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

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "BALDAT~0" ON "BALDAT" ( "MANDANT", "RELID", "LOG_HANDLE", "BLOCK", "SRTF2" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 201326592 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )

DbSlExecute: rc = 99

(SQL error 12801)

error message returned by DbSl:

ORA-12801: error signaled in parallel query server P021

ORA-00604: error occurred at recursive SQL level 2

ORA-00018: maximum number of sessions exceeded

*Out of 51 jobs 36 are completed and the rest of the jobs fail. We have the number of parellel jobs set to 2 instead of 3

as with 3 as well we had the same problem*

I have changed the R3load.exe(UC) to the newest patch level, changed the processes and sessions parameters at oracle level as well and its of no use.

Even the retry didnt work.Increased the PSAPTEMP tablespace as well.

Helllo All,

We are doing a unicode migration for Netweaver 2004s system with the following error(BI7)

DB) INFO: BALDAT created #20090803110510

(IMP) INFO: import of BALDAT completed (2307674 rows) #20090803110648

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

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

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX "BALDAT~0" ON "BALDAT" ( "MANDANT", "RELID", "LOG_HANDLE", "BLOCK", "SRTF2" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 201326592 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL )

DbSlExecute: rc = 99

(SQL error 12801)

error message returned by DbSl:

ORA-12801: error signaled in parallel query server P021

ORA-00604: error occurred at recursive SQL level 2

ORA-00018: maximum number of sessions exceeded

*Out of 51 jobs 36 are completed and the rest of the jobs fail. We have the number of parellel jobs set to 2 instead of 3

as with 3 as well we had the same problem*

I have changed the R3load.exe(UC) to the newest patch level, changed the processes and sessions parameters at oracle level as well and its of no use.

Even the retry didnt work.Increased the PSAPTEMP tablespace as well.

Reply
7 REPLIES 7
Read only

Former Member

‎2009 Aug 03 5:31 PM

0 Likes
1,073

HERE IS THE SAPINST.LOG

INFO 2009-08-03 09:53:01.843

Creating file C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\x.

INFO 2009-08-03 09:53:01.843

Removing file C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\x.

INFO 2009-08-03 09:53:15.109

Creating file C:\Program Files\sapinst_instdir\x.

INFO 2009-08-03 09:53:15.109

Removing file C:\Program Files\sapinst_instdir\x.

INFO 2009-08-03 09:53:16.453

Copied file 'C:/Program Files/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/statistic.xml' to 'C:/Program Files/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/statistic.15.xml'.

INFO 2009-08-03 09:53:17.125

Copied file 'C:/Program Files/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/statistic.xml' to 'C:/Program Files/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/statistic.16.xml'.

WARNING 2009-08-03 09:53:19.578

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-08-03 09:53:42.453

Copied file 'C:/Program Files/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/inifile.xml' to 'C:/Program Files/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/inifile.7.xml'.

INFO 2009-08-03 09:53:42.625

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

INFO 2009-08-03 09:53:44.703

Copied file 'C:/Program Files/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/keydb.xml' to 'C:/Program Files/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/keydb.6.xml'.

INFO 2009-08-03 09:53:44.765

Copied file 'C:/Program Files/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/statistic.xml' to 'C:/Program Files/sapinst_instdir/NW04S/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/statistic.17.xml'.

INFO 2009-08-03 09:53:44.812

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-08-03 09:53:45.000

Creating file C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\import_monitor.java.log.

INFO 2009-08-03 09:53:45.015

Working directory changed to C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP.

INFO 2009-08-03 09:53:45.015

Output of C:\j2sdk1.4.2_17-x64\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-08-03 10:03:15.921

Execution of the command "C:\j2sdk1.4.2_17-x64\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_17"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_17-b06)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_17-b06, mixed mode)

Import Monitor jobs: running 1, waiting 14, completed 36, failed 0, total 51.

Import Monitor jobs: running 2, waiting 13, completed 36, failed 0, total 51.

Import Monitor jobs: running 3, waiting 12, completed 36, failed 0, total 51.

Loading of '_BIC_B0000365000' import package: ERROR

Import Monitor jobs: running 2, waiting 12, completed 36, failed 1, total 51.

Loading of 'BALDAT' import package: ERROR

Import Monitor jobs: running 1, waiting 12, completed 36, failed 2, total 51.

Import Monitor jobs: running 2, waiting 11, completed 36, failed 2, total 51.

Import Monitor jobs: running 3, waiting 10, completed 36, failed 2, total 51.

Loading of 'SAPDFACT_5' import package: ERROR

Import Monitor jobs: running 2, waiting 10, completed 36, failed 3, total 51.

Loading of '_BI0_ASD_O0100' import package: OK

Import Monitor jobs: running 1, waiting 10, completed 37, failed 3, total 51.

Import Monitor jobs: running 2, waiting 9, completed 37, failed 3, total 51.

Import Monitor jobs: running 3, waiting 8, completed 37, failed 3, total 51.

Loading of '_BIC_FZ_COPA' import package: ERROR

Import Monitor jobs: running 2, waiting 8, completed 37, failed 4, total 51.

Import Monitor jobs: running 3, waiting 7, completed 37, failed 4, total 51.

Loading of 'SAPDFACT_1' import package: ERROR

Import Monitor jobs: running 2, waiting 7, completed 37, failed 5, total 51.

Import Monitor jobs: running 3, waiting 6, completed 37, failed 5, total 51.

Loading of 'SAPDFACT_6' import package: OK

Import Monitor jobs: running 2, waiting 6, completed 38, failed 5, total 51.

Import Monitor jobs: running 3, waiting 5, completed 38, failed 5, total 51.

Loading of '_BIC_AZDSV_SCL00' import package: ERROR

Import Monitor jobs: running 2, waiting 5, completed 38, failed 6, total 51.

Loading of 'SAPDFACT_3' import package: ERROR

Import Monitor jobs: running 1, waiting 5, completed 38, failed 7, total 51.

Import Monitor jobs: running 2, waiting 4, completed 38, failed 7, total 51.

Import Monitor jobs: running 3, waiting 3, completed 38, failed 7, total 51.

Loading of '_BIC_B0000180000' import package: ERROR

Import Monitor jobs: running 2, waiting 3, completed 38, failed 8, total 51.

Import Monitor jobs: running 3, waiting 2, completed 38, failed 8, total 51.

Loading of 'SAPSLEXC' import package: ERROR

Import Monitor jobs: running 2, waiting 2, completed 38, failed 9, total 51.

Import Monitor jobs: running 3, waiting 1, completed 38, failed 9, total 51.

Loading of 'SAPDFACT_4' import package: OK

Import Monitor jobs: running 2, waiting 1, completed 39, failed 9, total 51.

Loading of 'SAP0000' import package: ERROR

Import Monitor jobs: running 1, waiting 1, completed 39, failed 10, total 51.

Loading of 'SAPDFACT_2' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 39, failed 11, total 51.

ERROR 2009-08-03 10:03:15.921

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-08-03 10:03:16.31

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.).

INFO 2009-08-03 10:16:35.26

An error occured and the user decide to stop.\n Current step "|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".

INFO 2009-08-03 10:16:44.280

Creating file C:\Program Files\sapinst_instdir\.lastInstallationLocation.

INFO 2009-08-03 10:16:44.546

Creating file C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\__instana_tmp.xml.

Read only

Former Member

‎2009 Aug 03 5:32 PM

0 Likes
1,073

Here is the JAVA_IMPORT.java.log

java version "1.4.2_17"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_17-b06)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_17-b06, mixed mode)

Import Monitor jobs: running 1, waiting 14, completed 36, failed 0, total 51.

Import Monitor jobs: running 2, waiting 13, completed 36, failed 0, total 51.

Import Monitor jobs: running 3, waiting 12, completed 36, failed 0, total 51.

Loading of '_BIC_B0000365000' import package: ERROR

Import Monitor jobs: running 2, waiting 12, completed 36, failed 1, total 51.

Loading of 'BALDAT' import package: ERROR

Import Monitor jobs: running 1, waiting 12, completed 36, failed 2, total 51.

Import Monitor jobs: running 2, waiting 11, completed 36, failed 2, total 51.

Import Monitor jobs: running 3, waiting 10, completed 36, failed 2, total 51.

Loading of 'SAPDFACT_5' import package: ERROR

Import Monitor jobs: running 2, waiting 10, completed 36, failed 3, total 51.

Loading of '_BI0_ASD_O0100' import package: OK

Import Monitor jobs: running 1, waiting 10, completed 37, failed 3, total 51.

Import Monitor jobs: running 2, waiting 9, completed 37, failed 3, total 51.

Import Monitor jobs: running 3, waiting 8, completed 37, failed 3, total 51.

Loading of '_BIC_FZ_COPA' import package: ERROR

Import Monitor jobs: running 2, waiting 8, completed 37, failed 4, total 51.

Import Monitor jobs: running 3, waiting 7, completed 37, failed 4, total 51.

Loading of 'SAPDFACT_1' import package: ERROR

Import Monitor jobs: running 2, waiting 7, completed 37, failed 5, total 51.

Import Monitor jobs: running 3, waiting 6, completed 37, failed 5, total 51.

Loading of 'SAPDFACT_6' import package: OK

Import Monitor jobs: running 2, waiting 6, completed 38, failed 5, total 51.

Import Monitor jobs: running 3, waiting 5, completed 38, failed 5, total 51.

Loading of '_BIC_AZDSV_SCL00' import package: ERROR

Import Monitor jobs: running 2, waiting 5, completed 38, failed 6, total 51.

Loading of 'SAPDFACT_3' import package: ERROR

Import Monitor jobs: running 1, waiting 5, completed 38, failed 7, total 51.

Import Monitor jobs: running 2, waiting 4, completed 38, failed 7, total 51.

Import Monitor jobs: running 3, waiting 3, completed 38, failed 7, total 51.

Loading of '_BIC_B0000180000' import package: ERROR

Import Monitor jobs: running 2, waiting 3, completed 38, failed 8, total 51.

Import Monitor jobs: running 3, waiting 2, completed 38, failed 8, total 51.

Loading of 'SAPSLEXC' import package: ERROR

Import Monitor jobs: running 2, waiting 2, completed 38, failed 9, total 51.

Import Monitor jobs: running 3, waiting 1, completed 38, failed 9, total 51.

Loading of 'SAPDFACT_4' import package: OK

Import Monitor jobs: running 2, waiting 1, completed 39, failed 9, total 51.

Loading of 'SAP0000' import package: ERROR

Import Monitor jobs: running 1, waiting 1, completed 39, failed 10, total 51.

Loading of 'SAPDFACT_2' import package: ERROR

Import Monitor jobs: running 0, waiting 1, completed 39, failed 11, total 51.

Read only

Former Member

‎2009 Aug 03 5:35 PM

0 Likes
1,073

ONE EXAMPLE

G:\usr\sap\BID\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090803062739

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

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

Compiled Jan 24 2008 01:41:44

G:\usr\sap\BID\SYS\exe\uc\NTAMD64\R3load.exe -ctf I Z:\export-unicode\ABAP\DATA\SAPDFACT_2.STR C:\Program Files\sapinst_instdir\NW04S\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\DDLORA.TPL SAPDFACT_2.TSK ORA -l SAPDFACT_2.log

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

G:\usr\sap\BID\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090803062739

G:\usr\sap\BID\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090803062739

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

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

Compiled Jan 24 2008 01:41:44

G:\usr\sap\BID\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT_2.cmd -dbcodepage 4103 -k 17qgdEM50Dp01eqtd1Mv0AE3 -l SAPDFACT_2.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 = "BID20090803050821 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "MADBID01 "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "MADBID01"

(GSI) INFO: release = "5.2"

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

(GSI) INFO: machine = "16x AMD64 Level 6 (Mod 26 Step 5)"

(SQL) INFO: Trying to open Z:\export-unicode\ABAP\DB/ORA/DFACT.SQL

(SQL) INFO: Z:\export-unicode\ABAP\DB/ORA/DFACT.SQL opened

(DB) INFO: /BI0/F0SD_C03 created #20090803062831

(IMP) INFO: import of /BI0/F0SD_C03 completed (3847130 rows) #20090803062911

(DB) INFO: /BI0/F0SD_C03~0 created #20090803062911

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

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

(DB) ERROR: DDL statement failed

( CREATE INDEX "/BI0/F0SD_C03~010" ON "/BI0/F0SD_C03" ("KEY_0SD_C03P") PCTFREE 10 INITRANS 002 TABLESPACE PSAPSR3 STORAGE (INITIAL 0000101304 K NEXT 0000101304 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001) PARALLEL )

DbSlExecute: rc = 99

(SQL error 12801)

error message returned by DbSl:

ORA-12801: error signaled in parallel query server P039

ORA-00018: maximum number of sessions exceeded

(DB) INFO: disconnected from DB

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

G:\usr\sap\BID\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090803062918

G:\usr\sap\BID\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20090803065143

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

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

Compiled Jan 24 2008 01:41:44

G:\usr\sap\BID\SYS\exe\uc\NTAMD64\R3load.exe -i SAPDFACT_2.cmd -dbcodepage 4103 -k 17qgdEM50Dp01eqtd1Mv0AE3 -l SAPDFACT_2.log -stop_on_error

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

DbSl Trace: CONNECT failed with sql error '12518'

DbSl Trace: ORA-1403 when accessing table SAPUSER

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

DbSl Trace: CONNECT failed with sql error '12518'

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

DbSl Trace: CONNECT failed with sql error '12518'

(DB) ERROR: db_connect rc = 256

DbSl Trace: ORA-1403 when accessing table SAPUSER

ORA-01403: no data found

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

G:\usr\sap\BID\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20090803100300

Read only

Former Member

‎2009 Aug 25 9:32 PM

0 Likes
1,073

Hi,

I am also facing the same issue.. when installation ECC 6 SR3 IDES.

Please let me know how did you resolved the issue.

Thanks,

Balaji N.

Read only

nils_buerckel
Product and Topic Expert
Product and Topic Expert
In response to Former Member

‎2009 Aug 26 10:12 AM

0 Likes
1,073

Hi,

please check whether the proposal in SAP note 1120872 (search for ORA-0018) solves your problem.

Best regards,

Nils Buerckel

SAP AG

Read only

Former Member

‎2010 Jul 20 2:24 PM

0 Likes
1,073

Hi Kiran

can you please let us know what was the solution

Regards

AJ

Read only

Former Member

‎2010 Sep 28 2:27 AM

0 Likes
1,073

If your server is Windows Server,

set environment parameter

set ORACLE_SID=<SID>

set SAPSYSTEMNAME=<SID>