R3load error while exporting SAP MaxDB Database

[former_member207587]

Hi,

I am facing the following issue:

I tried to export a database (Unicode Migration). 111 processes of the export finished successfully, 3 finished with erros. It is the same error for 3 different tables:

ERROR: 2016-06-08 12:30:10 com.sap.inst.migmon.LoadTask run
Unloading of 'SAPNTAB' export package is interrupted with R3load error.
Process '/usr/sap/XXX/DVEBMGS23/exe/R3load -e SAPNTAB.cmd -datacodepage 4103 -l SAPNTAB.log -stop_on_error' exited with return code 2.
For mode details see 'SAPNTAB.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
sh: mc: line 1: syntax error: unexpected end of file
sh: error importing function definition for `BASH_FUNC_mc'
sh: mc: line 1: syntax error: unexpected end of file
sh: error importing function definition for `BASH_FUNC_mc'

I get this for SAPNTAB, SAPCLUST and SAPSDIC.

I've searched the SCN and several Notes, but nothing could help me.

[former_member201800 · Accepted solution]

Hi,

Please check the solution in below thread:

https://scn.sap.com/thread/1568523

Thanks,

Shyam

[former_member207587 · Accepted solution]

Thanks for the link. The reset of SPUMG helped me out. After it everything worked fine for me.

Now I'm facing an error at the import-task. Could you please help?

ERROR: 2016-06-15 07:37:37 com.sap.inst.migmon.LoadTask run
Loading of 'SAPAPPL0_9' import package is interrupted with R3load error.
Process '/usr/sap/EE8/SYS/exe/uc/linuxx86_64/R3load -i SAPAPPL0_9.cmd -dbcodepage 4103 -l SAPAPPL0_9
.log -nolog -c 50000 -force_repeat -para_cnt 24' exited with return code 2.
For mode details see 'SAPAPPL0_9.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
sh: mc: line 1: syntax error: unexpected end of file
sh: error importing function definition for `BASH_FUNC_mc'
sh: mc: line 1: syntax error: unexpected end of file
sh: error importing function definition for `BASH_FUNC_mc'

The SAPAPP0_9.log shows me following:

adaExeFastload (executeFastLoader): -25304:Attempt to insert single record after key sequence error
failed with error -10210 = 'Invalid command state (No prepared SQL command)'
-25303 = Key sequence error
last inserted key: '..(.A.n.d.r .. .E.b.e.r.t.)' (binary: '0100280041006E00640072201A002000450062006
5007200740029')
new key:           '..(.A.n.d.r... .B...h.m.e.r.)' (binary: '0100280041006E0064007200E40020004200F60
068006D006500720029').
(IMP) ERROR: ExeFastload: rc = 2

and some:

(DB) ERROR: DDL statement failed
 (DROP INDEX "/BIC/SESADDRLI0~00" ON "/BIC/SESADDRLI0")
 DbSlExecute: rc = 103
  (SQL error -4011)
  error message returned by DbSl:
POS(13) Unknown index name:/BIC/SESADDRLI0~00
(IMP) INFO: a failed DROP attempt is not necessarily a problem

With the last hint it seems ok.

[former_member207587]

/usr/sap/EE8/DVEBMGS23/exe/R3load: START OF LOG: 20160609124220

/usr/sap/EE8/DVEBMGS23/exe/R3load: sccsid @(#) $Id: //bas/722_REL/src/R3ld/R3load/R3ld
main.c#5 $ SAP
/usr/sap/EE8/DVEBMGS23/exe/R3load: version R7.20/V1.6
Compiled Mar  7 2016 14:04:35
/usr/sap/EE8/DVEBMGS23/exe/R3load -ctf E /patches/EE8_export/EE8/export/ABAP/DATA/SAPN
TAB.STR /patches/EE8_export/EE8/export/ABAP/DB/DDLADA.TPL SAPNTAB.TSK ADA -l SAPNTAB.l
og

(PRC) INFO: working directory "/patches/EE8_export/EE8/Log/export"

/usr/sap/EE8/DVEBMGS23/exe/R3load: job completed
/usr/sap/EE8/DVEBMGS23/exe/R3load: END OF LOG: 20160609124220

/usr/sap/EE8/DVEBMGS23/exe/R3load: START OF LOG: 20160609124220

/usr/sap/EE8/DVEBMGS23/exe/R3load: sccsid @(#) $Id: //bas/722_REL/src/R3ld/R3load/R3ld
main.c#5 $ SAP
/usr/sap/EE8/DVEBMGS23/exe/R3load: version R7.20/V1.6
Compiled Mar  7 2016 14:04:35
/usr/sap/EE8/DVEBMGS23/exe/R3load -e SAPNTAB.cmd -datacodepage 4103 -l SAPNTAB.log -st
op_on_error

(PRC) INFO: working directory "/patches/EE8_export/EE8/Log/export"
(DB) INFO: connected to DB
(DB) INFO: Maxdb Kernel version 7.9.08.011
                         SQLDBC 7.9.8.026
(EXP) INFO: check NameTab widths: Ok.
(DB) INFO: Export without hintfile
(RSCP) INFO: UMGCOMCHAR read check, OK.
(RSCP) INFO: environment variable "I18N_POOL_WIDTH" is not set. Checks are active.
(RSCP) INFO: I18N_NAMETAB_TIMESTAMPS not in env: checks are ON (Note 738858)
(RSCP) WARN: UMGCONTAINER has 2 more problems.
(RSCP) INFO: UMGSETTINGS nametab creation: ok.
(RSCP) INFO: Global fallback code page = 1160
(RSCP) INFO: Common character set is  not  7-bit-ASCII
(RSCP) INFO: Collision resolution method is 'fine'
(RSCP) INFO: R3trans code pages = Normal
(RSCP) INFO: EXPORT TO ... code pages = Normal
(RSCP) INFO: Check for invalid language keys: activated
(RSCP) INFO: I18N_NAMETAB_NORM_ALLOW = 999999999
(RSCP) INFO: I18N_NAMETAB_NORM_LOG   = 1000000002
(RSCP) INFO: I18N_NAMETAB_ALT_ALLOW  = 10000
(RSCP) INFO: I18N_NAMETAB_ALT_LOG    = 10003
(RSCP) INFO: I18N_NAMETAB_OLD_ALLOW  = 0
(RSCP) INFO: I18N_NAMETAB_OLD_LOG    = 500
(RSCP) INFO: init SUMG interface (3#$Revision: #1 $); package name: "SAPNTAB".
(RSCP) INFO: "SAPNTAB001.xml" created.
(GSI) INFO: dbname   = "EE8
                                                                  "
(GSI) INFO: vname    = "ADABAS D                        "
(GSI) INFO: hostname = "lisapqe1r
  "
(GSI) INFO: sysname  = "Linux"
(GSI) INFO: nodename = "lisapqe1r"
(GSI) INFO: release  = "2.6.32.59-0.7-default"
(GSI) INFO: version  = "#1 SMP 2012-07-13 15:50:56 +0200"
(GSI) INFO: machine  = "x86_64"
(GSI) INFO: instno   = "0020138272"
(RSCP) ERROR: 'SVERS' in UMGCCTL: Guess has illegal value.
(RSCP) INFO: SVERS: Missing in UMGSTAT,
(RSCP) INFO: SVERS: and there are no vocabulary entries.
(RSCP) INFO: 5 lines written to SAPNTAB001.xml
(EXP) TABLE: "SVERS" #20160609124221

(RSCP) ERROR: 'DDNTF' in UMGCCTL: Guess has illegal value.
(RSCP) INFO: DDNTF: Missing in UMGSTAT,
ERROR in nametab conversion
conversion of nametab table 'DDNTF                         ': rscpMCStartTab: rc = 128
(CNV) ERROR: data conversion failed.  rc = 2
(DB) INFO: disconnected from DB

/usr/sap/EE8/DVEBMGS23/exe/R3load: job finished with 1 error(s)
/usr/sap/EE8/DVEBMGS23/exe/R3load: END OF LOG: 20160609124221

[MaLoo]

It looks a bit like Error during Unicode Conversion at DDNTF table | SCN

Did all SPUMG activities end correctly before the export?

[MaLoo]

I seriously doubt it if this is MaxDB related. Anyway, did you use the latest R3load versions to export? And indeed like James Zhang says, post the related logfiles?

[former_member207587]

Yes. I am using the 722_EXT Kernel for a 7.31 Business Warehouse.

[JamesZ]

As mentioned in the error, can you share log SAPNTAB.log?