cancel
Showing results for 
Search instead for 
Did you mean: 

Long running homogenous Export -- stuck in Export ABAP phase

Former Member
0 Kudos

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-rr 1 <sid>adm sapsys 1048576000 23 Jan 18:54 SAPAPPL1_56.067

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

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

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

-rw-rr 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-rr 1 <sid>adm sapsys 113 23 Jan 11:50 SAPAPPL1_56.TSK.bck

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

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

-rw-rr 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-rr 1 <sid>adm sapsys 15 23 Jan 15:00 SAPSSEXC_9.TSK

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

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

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

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

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

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

-rw-rr 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-rr 1 <sid>adm sapsys 30778 23 Jan 17:30 ExportMonitor.console.log

____________________________________________________________________________________________________

<hostname># date

Sat 23 Jan 19:32:42 2010

Regards

Punit

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

Dear Punit,

Can you also see any TSK error in the log, which mean only a part of data was imported.

If yes then please refer to #455195 to merge the data.

Please make sure the user has enough authorization.

This seems because of some oracle connect issue.

I recommend you update your R3trans and R3load (especially R3load) to the latest patch level.

Then before try again, run following command to make a test:

R3load -testconnect

Best Regards,

Abhishek

Former Member
0 Kudos

Hi Fabrice,

Please post error logs or provide more information. You may also consider opening a new thread.

@Abhishek: The thread is more than a year old. Hopefully, the original issue has been resolved

Regards,

Varun

0 Kudos

Dear Varun,

Thanks for the information.

I hope my recommendations would benefit Fabrice.

Regards,

Abhishek

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

> DbSl Trace: CONNECT failed with sql error '1034'

>

> DbSl Trace: CONNECT failed with sql error '1034'

>

> (DB) ERROR: db_connect rc = 256

This error is in your logs. For this error, check SAP Note 491174 - Composite SAP note for ORA-01034

Thanks

Sunny

Former Member
0 Kudos

Hi Sunny,

Listener is still running.

Already gone through this note. 147 Jobs it went fine only 1 Job to finish in ABAP Export Phase.

I am not getting any error while checking the log it is not updating but while seeing the Dump location it is generating like anything.

This happens sencond time and I cancelled and rerun again . It again holt...how much time it will take to dump 800 GB of data and Comprasion rate. currently size of the dump is 150 GB.

If you required any other log ...

Regards

Punit Maini

Edited by: Punit Maini on Jan 23, 2010 9:51 PM

Former Member
0 Kudos

Hello Punit,

I'm facing the same kind of problem with the export of an unicode conversion. I posted an OSS message to SAP support, but meanwhile did you find out what went wrong and how to fix it ?

Kind regards.

Fabrice