Migration Monitor with error during Export DB - Or...

Former Member · ‎07-31-2013

Hi,

Im performing a export of oracle DB over sapinst - SAP ECC 6.0 - linux - target is set to Oracle - here are lots of same problems mentioned already however in any one is solution.

My export finished with 12 failed jobs.

Errors in Logs are :

###### export_monitor.log

TRACE: 2013-07-30 21:52:34 com.sap.inst.migmon.LoadTask processPackage

Unloading of 'SAPAPPL0' export package from database:

/sapmnt/P8J/exe_Linux/R3load -e SAPAPPL0.cmd -datacodepage 4103 -l SAPAPPL0.log -stop_on_error

ERROR: 2013-07-30 21:56:17 com.sap.inst.migmon.LoadTask run

Unloading of 'SAPAPPL0' export package is interrupted with R3load error.

Process '/sapmnt/P8J/exe_Linux/R3load -e SAPAPPL0.cmd -datacodepage 4103 -l SAPAPPL0.log -stop_on_error' exited with re

turn code 2.

For mode details see 'SAPAPPL0.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

####### SAPAPPL0.log

rscpGetUmgContainerDLine,3759, l_result = 16

received return code 16 from rscpCopyContainerInfos for transparent table CUEX.(CNV) ERROR: data conversion failed. rc = 2

(DB) INFO: disconnected from DB

/sapmnt/P8J/exe_Linux/R3load: job finished with 1 error(s)

/sapmnt/P8J/exe_Linux/R3load: END OF LOG: 20130730215617

/sapmnt/P8J/exe_Linux/R3load: START OF LOG: 20130731070700

/sapmnt/P8J/exe_Linux/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#21 $ SAP

/sapmnt/P8J/exe_Linux/R3load: version R7.00/V1.4

Compiled Dec 11 2009 22:44:31

/sapmnt/P8J/exe_Linux/R3load -e SAPAPPL0.cmd -datacodepage 4103 -l SAPAPPL0.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(EXP) WARN: check NameTab width SQL DbSlRead on DDNTT_CONV_UC failed for table T002 with rc 24.

ORA-01403: no data found

(EXP) WARN: check NameTab width SQL DbSlRead on DDNTT_CONV_UC failed for table CDPOS with rc 24.

ORA-01403: no data found

(EXP) WARN: check NameTab width SQL DbSlRead on DDNTT_CONV_UC failed for table TACOB with rc 24.

ORA-01403: no data found

(EXP) INFO: check NameTab widths: Ok.

(DB) INFO: Export without hintfile

Alternate NameTab for type "BAPIPAREX_HELP" was missing and has been simulated.

Tab field CUEX-[9] has type DDic:168 ABAP:9

(SYSLOG) INFO: k CQ9 : CUEX&DDic:168&ABAP:9&field:9& rscpgdio 41

Tab field CUKN-[7] has type DDic:168 ABAP:9

(SYSLOG) INFO: k CQ9 : CUKN&DDic:168&ABAP:9&field:7& rscpgdio 41

Tab field CURSCOD-[5] has type DDic:168 ABAP:9

(SYSLOG) INFO: k CQ9 : CURSCOD&DDic:168&ABAP:9&field:5& rscpgdio 41

Tab field EDID2-[7] has type DDic:168 ABAP:9

(SYSLOG) INFO: k CQ9 : EDID2&DDic:168&ABAP:9&field:7& rscpgdio 41

Tab field EDID4-[7] has type DDic:168 ABAP:9

(SYSLOG) INFO: k CQ9 : EDID4&DDic:168&ABAP:9&field:7& rscpgdio 41

Tab field EDIDD_OLD-[6] has type DDic:168 ABAP:9

(SYSLOG) INFO: k CQ9 : EDIDD_OLD&DDic:168&ABAP:9&field:6& rscpgdio 41

Alternate NameTab for type "T52C5" was missing and has been simulated.

Tab field TPRI_PAR-[13] has type DDic:172 ABAP:8

(SYSLOG) INFO: k CQ9 : TPRI_PAR&DDic:172&ABAP:8&field:13& rscpgdio 41

(RSCP) INFO: UMGCOMCHAR read check, skip: no data found; probably old SPUMG.

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

(RSCP) WARN: UMGCONTAINER has 7 more problems.

(RSCP) WARN: UMGSETTINGS nametab creation: status not available, no table entry.

(RSCP) INFO: Global fallback code page = 0000

(RSCP) INFO: Common character set is 7-bit-ASCII

(RSCP) INFO: Collision resolution method is unexpected !

(RSCP) INFO: R3trans code pages = AskSPUMG

(RSCP) INFO: EXPORT TO ... code pages = AskSPUMG

(RSCP) INFO: Check for invalid language keys: active, by default

(RSCP) INFO: I18N_NAMETAB_NORM_ALLOW = 0

(RSCP) INFO: I18N_NAMETAB_NORM_LOG = 0

(RSCP) INFO: I18N_NAMETAB_ALT_ALLOW = 0

(RSCP) INFO: I18N_NAMETAB_ALT_LOG = 0

(RSCP) INFO: I18N_NAMETAB_OLD_ALLOW = 0

(RSCP) INFO: I18N_NAMETAB_OLD_LOG = 0

(GSI) INFO: dbname = "P8J20100910070941 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "sl02878 "

(GSI) INFO: sysname = "Linux"

(GSI) INFO: nodename = "sl02878"

(GSI) INFO: release = "2.6.16.60-0.81.2-smp"

(GSI) INFO: version = "#1 SMP Thu Jun 30 09:20:04 UTC 2011"

(GSI) INFO: machine = "x86_64"

(GSI) INFO: instno = "INITIAL "

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

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

rscpGetUmgContainerDLine,3759, l_result = 16

received return code 16 from rscpCopyContainerInfos for transparent table CUEX.(CNV) ERROR: data conversion failed. rc = 2

(DB) INFO: disconnected from DB

/sapmnt/P8J/exe_Linux/R3load: job finished with 1 error(s)

/sapmnt/P8J/exe_Linux/R3load: END OF LOG: 20130731070701

I have tried to start the export with SAP application down and also without. The SMIGR_CREATE_DDL has been created before without file.

JamesZ · ‎04-08-2015

Hi Martin,

please upload log SAPAPPL0.log file.

"ORA-01403: no data found" should not be an error

cheers,
James

stefan_koehler · ‎07-31-2013

Hi Martin,

have you performed all the necessary pre-steps (like SPUMG, table scans, nametab creation, report SMIGR_CREATE_DDL, etc.) before running R3load? It seems like you have not.

EXP) WARN: check NameTab width SQL DbSlRead on DDNTT_CONV_UC failed for table T002 with rc 24.
ORA-01403: no data found
(EXP) WARN: check NameTab width SQL DbSlRead on DDNTT_CONV_UC failed for table CDPOS with rc 24.
ORA-01403: no data found
(EXP) WARN: check NameTab width SQL DbSlRead on DDNTT_CONV_UC failed for table TACOB with rc 24.
ORA-01403: no data found
....
(RSCP) WARN: UMGCONTAINER has 7 more problems.
(RSCP) WARN: UMGSETTINGS nametab creation: status not available, no table entry.

Regards

Stefan

former_member188883 · ‎07-31-2013

Hi Martin,

Please check whether you are providing the right codepage "-datacodepage 4103" for your target system.

Regards,

Deepak Kori

former_member206552 · ‎07-31-2013

Hi Martin,

here is a thread with some ideas you can follow

http://scn.sap.com/thread/1495334

also did you update the R3trans etc. to the latest versions ?

are you doing a unicode conversion ?

Best Regards

Marius

Migration Monitor with error during Export DB - Oracle

Accepted Solutions (0)

Answers (4)

Answers (4)

Re: SAC Custom Widget for Uploading a load file(.x...

Re: generating qrcode using image url in crystal r...

Re: SAP PI - Determine the receiver based on Sourc...

Análise Combinatória de dados de bancos diferentes

Re: generating qrcode using image url in crystal r...