on 08-06-2016 5:11 PM
Hello experts,
I have trouble by installing an ECC 6.00 EHP 8 om Max DB.
These are the Errors I receive very installrun I try. They are just the same every attempt.
I try to use the "R3load -merge_bck" -> prompt an "parameter" is missing; but whitch?
the "R3load -merge_only SAPSSEXC.TSK works, but doesn´ t help.
-> So may I ask for help?
These are the errors from import monitor (the details of the logs are below):
1)
ERROR: 2016-08-06 14:56:13 com.sap.inst.migmon.LoadTask run
Loading of 'SAPSSEXC' import package is interrupted with R3load error.
Process '/usr/sap/R3A/SYS/exe/uc/linuxx86_64/R3load -i SAPSSEXC.cmd -dbcodepage 4103 -l SAPSSEXC.log -nolog -c 50000 -force_repeat -para_cnt 96 -decluster' exited with return code 139.
For mode details see 'SAPSSEXC.log' file.
2)
ERROR: 2016-08-06 14:53:54 com.sap.inst.migmon.LoadTask run
Loading of 'DOKCLU' import package is interrupted with R3load error.
Process '/usr/sap/R3A/SYS/exe/uc/linuxx86_64/R3load -i DOKCLU.cmd -dbcodepage 4103 -l DOKCLU.log -nolog -c 50000 -force_repeat -para_cnt 96 -decluster' exited with return code 139.
For mode details see 'DOKCLU.log' file.
3)
Loading of 'SAPCLUST' import package is interrupted with R3load error.
Process '/usr/sap/R3A/SYS/exe/uc/linuxx86_64/R3load -i SAPCLUST.cmd -dbcodepage 4103 -l SAPCLUST.log -nolog -c 50000 -force_repeat -para_cnt 96 -decluster' exited with return code 139.
For mode details see 'SAPCLUST.log' file.
4)
Loading of 'SAPAPPL1' import package is interrupted with R3load error.
Process '/usr/sap/R3A/SYS/exe/uc/linuxx86_64/R3load -i SAPAPPL1.cmd -dbcodepage 4103 -l SAPAPPL1.log -nolog -c 50000 -force_repeat -para_cnt 96 -decluster' exited with return code 2.
For mode details see 'SAPAPPL1.log' file.
The details of the logs:
1) SAPSSEXC.log
-> no error: lines to find.
-> These are the last lines of the log:
(DB) INFO: loading data in table "DDFIELDANNO" with fastloader #20160806145542
(IMP) INFO: starting import for object "DDFIELDANNO" of type "table" #20160806145542
------------------ C-STACK ----------------------
R3load[S](LinStackBacktrace+0x8c)[0x42980d]
R3load[S](LinStack+0x35)[0x65df95]
R3load[S](CTrcStack2+0x4e)[0x4296a1]
R3load[S](SigIGenAction+0x53c)[0x4db50b]
<signal handler called> [0x7fd9736ce870]
libSDBLoader77.so(Loader_PageBuilder::buildKey(unsigned int*&, int&, int&)+0x75)[0x7fd974196135]
libSDBLoader77.so(Loader_PageBuilder::buildRecord()+0x177)[0x7fd974196697]
libSDBLoader77.so(Loader_PageBuilder::AddData(LOADER_Parameter*)+0x42a)[0x7fd974198e2a]
libSDBLoader77.so(Loader_FastloadCommand::Execute()+0x140)[0x7fd974193b60]
R3ldfldsdbsh.so[S](CSdbFastLoader::executeStmt(bool)+0x5a)[0x7fd96fa3481a]
R3ldfldsdbsh.so[S](CSdbFastLoader::executeFastLoader(DBSL_DA*)+0x8a)[0x7fd96fa37d4a]
R3ldfldsdbsh.so[S](adaExeFastload+0x19)[0x7fd96fa33a89]
R3load[S](ExeDBInsert+0x8b)[0x51673b]
R3load[S](import+0x15aa)[0x517dda]
R3load[S](main_r3ldmain+0x1239)[0x5019b9]
libc.so.6[S](__libc_start_main+0xf5)[0x7fd973338b25]
-------------------------------------------------
2) DOKCLU.log
(DB) INFO: connected to DB
(DB) INFO: The MaxDB logwriter is switched off#20160806144833
(DB) INFO: Maxdb Kernel version 7.9.08.023
SQLDBC 7.9.8.023
(DB) INFO: Loading Data with MaxDB Fastloader Api
(DB) INFO: SDBLoader 7.9.8 .
(DCL) INFO: found logical cluster description for DOKCLU in /tmp/1-OrigInstFiles/ECC618/51050708/DATA_UNITS/EXPORT_11/DATA/SAPDOKCLU.STR.logical
(IMP) INFO: starting create for object "DOKCLU" of type "table" #20160806144833
(DB) INFO: DOKCLU created#20160806144833
(DB) INFO: DOKTL created#20160806144833
(IMP) INFO: finished create for object "DOKCLU" of type "table" in 0 sec #20160806144833
(DCL) INFO: found logical cluster description for DOKCLU in /tmp/1-OrigInstFiles/ECC618/51050708/DATA_UNITS/EXPORT_11/DATA/SAPDOKCLU.STR.logical
(IMP) INFO: starting create for object "DOKCLU~0" of type "primary index" #20160806144833
(DB) INFO: DOKCLU~0 created#20160806144833
(DB) INFO: DOKTL~0 created#20160806144833
(IMP) INFO: finished create for object "DOKCLU~0" of type "primary index" in 0 sec #20160806144833
(DCL) INFO: found logical cluster description for DOKCLU in /tmp/1-OrigInstFiles/ECC618/51050708/DATA_UNITS/EXPORT_11/DATA/SAPDOKCLU.STR.logical
(DB) INFO: loading data in table "DOKCLU" with fastloader #20160806144833
(IMP) INFO: starting import for object "DOKCLU" of type "table" #20160806144833
adaExeFastload (executeFastLoader): -25011:Error executing internal SQL statement 'send packet': 'SQL error -8000 = ä•“å™’å‰…ä‰„æ´ çµâ´æ•¢çˆ ç¥æ…´ç‘²æ‘¥'.
(IMP) ERROR: ExeFastload: rc = 2
(DB) INFO: Savepoint on database executed#20160806145354
------------------ C-STACK ----------------------
-> 'SQL error -8000 = ... the funny characters are in the log - line also.
3) SAPCLUST
(IMP) INFO: starting import for object "SFHOA" of type "table" #20160806144838
adaEndFastload (endFastLoader): -25011:Error executing internal SQL statement 'send packet': 'SQL error -8000 = ä•“å™’å‰…ä‰„æ´ çµâ´æ•¢çˆ ç¥æ…´ç‘²æ‘¥'.
(IMP) ERROR: EndFastload: rc = 2
-> 'SQL error -8000 = ... the funny characters are in the log - line also.
4) SAPAPPL1
(IMP) INFO: starting create for object "DEMO_GTT" of type "global temporary table" #20160806145511
DbSl Trace: execute(), rc=1, rcSQL=-5004
DbSl Trace: EXECUTE on connection 0, rc=-5004
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(CREATE TABLE "$TMP_DEMO_GTT" ( "$ada_session_id" CHAR (6) BYTE not null default TRANSACTION,"ID" VARCHAR2(1) UNICODE DEFAULT ' ' NOT NULL , "COL" NUMBER(10) DEFAULT 0 NOT NULL ) NO FIXED LENGTH COLUMN )
DbSlExecute: rc = 99
(SQL error -5004)
error message returned by DbSl:
POS(81) Missing constant
(IMP) INFO: starting create for object "DEMO_GTT~0" of type "primary index" #20160806145511
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(ALTER TABLE "$TMP_DEMO_GTT" ADD PRIMARY KEY ( "$ada_session_id","ID" ) )
DbSlExecute: rc = 103
(SQL error -942)
error message returned by DbSl:
POS(14) Unknown table name:$TMP_DEMO_GTT
(IMP) INFO: starting create for object "DEMO_SFLIGHT_AGG" of type "global temporary table" #20160806145511
DbSl Trace: execute(), rc=1, rcSQL=-5004
DbSl Trace: EXECUTE on connection 0, rc=-5004
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(CREATE TABLE "$TMP_DEMO_SFLIGHT_AGG" ( "$ada_session_id" CHAR (6) BYTE not null default TRANSACTION,"MANDT" VARCHAR2(3) UNICODE DEFAULT '000' NOT NULL , "CARRID" VARCHAR2(3) UNICODE DEFAULT ' ' NOT NULL , "CONNID" VARCHAR2(4) UNICODE DEFAULT '0000' NOT NULL , "FLDATE" VARCHAR2(8) UNICODE DEFAULT '00000000' NOT NULL , "SEATSOCC" NUMBER(10) DEFAULT 0 NOT NULL ) NO FIXED LENGTH COLUMN )
DbSlExecute: rc = 99
(SQL error -5004)
error message returned by DbSl:
POS(89) Missing constant
(IMP) INFO: starting create for object "DEMO_SFLIGHT_AGG~0" of type "primary index" #20160806145511
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(ALTER TABLE "$TMP_DEMO_SFLIGHT_AGG" ADD PRIMARY KEY ( "$ada_session_id","MANDT", "CARRID", "CONNID", "FLDATE" ) )
DbSlExecute: rc = 103
(SQL error -942)
error message returned by DbSl:
POS(14) Unknown table name:$TMP_DEMO_SFLIGHT_AGG
(IMP) INFO: starting create for object "DF50L" of type "table" #20160806145511
(IMP) INFO: finished create for object "SATC_CI_EX_CHLOG~O" of type "index" in 0 sec #20160806150341
(IMP) INFO: starting create for object "SATC_CI_GTT_CNTC" of type "global temporary table" #20160806150341
DbSl Trace: execute(), rc=1, rcSQL=-5004
DbSl Trace: EXECUTE on connection 0, rc=-5004
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(CREATE TABLE "$TMP_SATC_CI_GTT_CNTC" ( "$ada_session_id" CHAR (6) BYTE not null default TRANSACTION,"PGMID" VARCHAR2(4) UNICODE DEFAULT ' ' NOT NULL , "OBJ_TYPE" VARCHAR2(4) UNICODE DEFAULT ' ' NOT NULL , "OBJ_NAME" VARCHAR2(40) UNICODE DEFAULT ' ' NOT NULL , "SYSTEM_GROUP" VARCHAR2(10) UNICODE DEFAULT ' ' NOT NULL ) NO FIXED LENGTH COLUMN )
DbSlExecute: rc = 99
(SQL error -5004)
error message returned by DbSl:
POS(89) Missing constant
(IMP) INFO: starting create for object "SATC_CI_GTT_CNTC~0" of type "primary index" #20160806150341
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(ALTER TABLE "$TMP_SATC_CI_GTT_CNTC" ADD PRIMARY KEY ( "$ada_session_id","PGMID", "OBJ_TYPE", "OBJ_NAME", "SYSTEM_GROUP" ) )
DbSlExecute: rc = 103
(SQL error -942)
error message returned by DbSl:
POS(14) Unknown table name:$TMP_SATC_CI_GTT_CNTC
(IMP) INFO: starting create for object "SATC_CI_GTT_OBJ" of type "global temporary table" #20160806150341
DbSl Trace: execute(), rc=1, rcSQL=-5004
DbSl Trace: EXECUTE on connection 0, rc=-5004
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(CREATE TABLE "$TMP_SATC_CI_GTT_OBJ" ( "$ada_session_id" CHAR (6) BYTE not null default TRANSACTION,"PGMID" VARCHAR2(4) UNICODE DEFAULT ' ' NOT NULL , "OBJ_TYPE" VARCHAR2(4) UNICODE DEFAULT ' ' NOT NULL , "OBJ_NAME" VARCHAR2(40) UNICODE DEFAULT ' ' NOT NULL , "SYSTEM_GROUP" VARCHAR2(10) UNICODE DEFAULT ' ' NOT NULL ) NO FIXED LENGTH COLUMN )
DbSlExecute: rc = 99
(SQL error -5004)
error message returned by DbSl:
POS(88) Missing constant
(IMP) INFO: starting create for object "SATC_CI_GTT_OBJ~0" of type "primary index" #20160806150341
ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed
(ALTER TABLE "$TMP_SATC_CI_GTT_OBJ" ADD PRIMARY KEY ( "$ada_session_id","PGMID", "OBJ_TYPE", "OBJ_NAME", "SYSTEM_GROUP" ) )
DbSlExecute: rc = 103
(SQL error -942)
error message returned by DbSl:
POS(14) Unknown table name:$TMP_SATC_CI_GTT_OBJ
Update:
After changing the MaxDB Version to 7.9. SP 6 Build 35 the Installation run without Errors.
Well I have to admit that my evaluation of teh cause of the error was not correct.
The solution is: please use the mentioned MaxDB Version Build 35.
Best regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I can confirm that information.
With patching the database (MaxDB) to the highest available patch level (7.9.08.40) when the error occured we could finish the installation (with some other more or less anoying errors). We also patched R3load which seems to be helpfull with one of the other problems we had after we pacthed the database.
Kind Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.