Skip to Content
0
Former Member
Jan 23, 2010 at 07:54 PM

Long running homogenous Export -- stuck in Export ABAP phase

366 Views

We are doing export of the Production <SID > for Quality <SID> new built system While doing this we encounter the following error. Export dump is taking long time it stuck at 147 of 148.

____________________________________________________________________________________________________

When we see the logs SAPAPPL1_56 * is generating like anything need to know is it a error or still writting something in Export file , as Logs are not generating in cd /saptemp/TEMP_1/sapinst_instdir/ERP/LM/COPY/ORA/EXP/CENTRAL/AS/EXP only ECC_Dump file is increasing

____________________________________________________________________________________________________

<hostname># ls -ltr |tail {Generating like anything}

-rw-r r 1 <sid>adm sapsys 1048576000 23 Jan 18:54 SAPAPPL1_56.067

-rw-r r 1 <sid>adm sapsys 1048576000 23 Jan 18:59 SAPAPPL1_56.068

-rw-r r 1 <sid>adm sapsys 1048576000 23 Jan 19:04 SAPAPPL1_56.069

-rw-r r 1 <sid>adm sapsys 1048576000 23 Jan 2010 SAPAPPL1_56.070

-rw-r r 1 <sid>adm sapsys 1029891072 23 Jan 2010 SAPAPPL1_56.071

____________________________________________________________________________________________________

<hostname># ps -ef |grep SID

ora<sid> 110612 1 5 12:56:23 - 12:52 oracle (LOCAL=NO)

<sid>adm 266480 1 0 11:48:37 - 0:00 ora_qmnc_<SID>

<sid>adm 319518 1 0 11:48:31 - 0:00 ora_lgwr_<SID>

<sid>adm 413876 1261632 96 12:56:22 pts/1 185:41 /usr/sap/<SID>/SYS/exe/run/R3load -e SAPAPPL1_56.cmd -datacodepage 4102 -l SAPAPPL1_56.log -stop_on_error

____________________________________________________________________________________________________

<hostname># cd /saptemp/TEMP_1/sapinst_instdir/ERP/LM/COPY/ORA/EXP/CENTRAL/AS/EXP

-rw-r r 1 <sid>adm sapsys 113 23 Jan 11:50 SAPAPPL1_56.TSK.bck

-rw-r r 1 <sid>adm sapsys 291 23 Jan 11:50 SAPAPPL1_56.cmd

-rw-r r 1 <sid>adm sapsys 0 23 Jan 13:04 SAPAPPL1_56.TSK

-rw-r r 1 <sid>adm sapsys 2396 23 Jan 13:04 SAPAPPL1_56.log

____________________________________________________________________________________________________

<hostname># cat SAPAPPL1_56.TSK

<hostname># cat SAPAPPL1_56.TSK.bck

D SOFFCONT1 E xeq

D SOFIND E xeq

D SOFM E xeq

D SOHS E xeq

D SOID E xeq

D SOIMAP E xeq

D SOMG E xeq

D SOOC E xeq

____________________________________________________________________________________________________

<hostname># cat SAPAPPL1_56.cmd

tsk: "/saptemp/TEMP_1/sapinst_instdir/ERP/LM/COPY/ORA/EXP/CENTRAL/AS/EXP/SAPAPPL1_56.TSK";

icf: "/saptemp/ECC_dump/ABAP/DATA/SAPAPPL1_56.STR";

dcf: "/saptemp/ECC_dump/ABAP/DB/DDLORA_LRG.TPL";

dat: "/saptemp/ECC_dump/ABAP/DATA/" bs=1k fs=1000M

dir: "/saptemp/ECC_dump/ABAP/DATA/SAPAPPL1_56.TOC";

____________________________________________________________________________________________________

<hostname># cat SAPAPPL1_56.log

/usr/sap/<SID>/SYS/exe/run/R3load: START OF LOG: 20100123114310

/usr/sap/<SID>/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP

/usr/sap/<SID>/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Apr 2 2009 21:45:19

/usr/sap/<SID>/SYS/exe/run/R3load -ctf E /saptemp/ECC_dump/ABAP/DATA/SAPAPPL1_56.STR /saptemp/ECC_dump/ABAP/DB/DDLORA_LRG.TPL SAPAPPL1_56.TSK ORA -l SAPAPPL1_56.log

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

/usr/sap/<SID>/SYS/exe/run/R3load: job completed

/usr/sap/<SID>/SYS/exe/run/R3load: END OF LOG: 20100123114310

/usr/sap/<SID>/SYS/exe/run/R3load: START OF LOG: 20100123114310

/usr/sap/<SID>/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP

/usr/sap/<SID>/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Apr 2 2009 21:45:19

/usr/sap/<SID>/SYS/exe/run/R3load -e SAPAPPL1_56.cmd -datacodepage 4102 -l SAPAPPL1_56.log -stop_on_error

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: db_connect rc = 256

DbSl Trace: CONNECT failed with sql error '1034'

DbSl Trace: CONNECT failed with sql error '1034'

(DB) ERROR: DbSlErrorMsg rc = 99

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

/usr/sap/<SID>/SYS/exe/run/R3load: END OF LOG: 20100123114310

/usr/sap/<SID>/SYS/exe/run/R3load: START OF LOG: 20100123125623

/usr/sap/<SID>/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP

/usr/sap/<SID>/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Apr 2 2009 21:45:19

/usr/sap/<SID>/SYS/exe/run/R3load -e SAPAPPL1_56.cmd -datacodepage 4102 -l SAPAPPL1_56.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

(DB) INFO: Export without hintfile

(GSI) INFO: dbname = "<SID>20100115050158 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "<hostname> "

(GSI) INFO: sysname = "AIX"

(GSI) INFO: nodename = "<hostname>"

(GSI) INFO: release = "3"

(GSI) INFO: version = "5"

(GSI) INFO: machine = "0001DB91D600"

____________________________________________________________________________________________________

<hostname># cd /saptemp/TEMP_1/sapinst_instdir/ERP/LM/COPY/ORA/EXP/CENTRAL/AS/EXP

<hostname># ls -ltr |tail

-rw-r r 1 <sid>adm sapsys 15 23 Jan 15:00 SAPSSEXC_9.TSK

-rw-r r 1 <sid>adm sapsys 2770 23 Jan 15:00 SAPSSEXC_9.log

-rw-r r 1 <sid>adm sapsys 571 23 Jan 15:54 SAPSSEXC_7.TSK

-rw-r r 1 <sid>adm sapsys 4051 23 Jan 15:54 SAPSSEXC_7.log

-rw-r r 1 <sid>adm sapsys 13 23 Jan 16:44 SAPAPPL1_75.TSK

-rw-r r 1 <sid>adm sapsys 2734 23 Jan 16:44 SAPAPPL1_75.log

-rw-r r 1 <sid>adm sapsys 1967 23 Jan 16:44 export_state.properties

-rw-r r 1 <sid>adm sapsys 233556 23 Jan 17:30 export_monitor.log

-rw-r----- 1 root sapinst 29912 23 Jan 17:30 export_monitor.java.log

-rw-r r 1 <sid>adm sapsys 30778 23 Jan 17:30 ExportMonitor.console.log

____________________________________________________________________________________________________

<hostname># date

Sat 23 Jan 19:32:42 2010

Regards

Punit