Skip to Content
0
Former Member
Jul 23, 2013 at 11:25 AM

Upgrade issue: DbSl Trace: ORA-43851 occurred at SQL stmt

246 Views

Hi All,

I am upgrading ERP system from ECC5 to ERP 6 Ehp6 on windows 2008 / Oracle 11.2.0.2 environment using SUM. I am getting the below error from file EX000009.DPR in SUM log folder at "Severe error(s) occured in phase MAIN_SHDCRE/EU_IMPORT1!" Phase. I have been through various post and note # 1871448 - Error: SAPup broke during phase EU_IMPORT1 in module MAIN_SHDCRE, but to no avail. Would like to get comment and help in resolving this issue.

Output from log file: SAPup_troubleticket.log

SAPup broke during phase EU_IMPORT1 in module MAIN_SHDCRE / Import and Modification Transfer

Error Message: 2 error during parallel execution of processes, check 'EU_IMP1.ELG' for details

4 processes failed, check 'EU_IMNDB.*' for details

Output from log file: EX000000.DPR

F:\usr\sap\EC5\SUM\abap\exe\R3load.EXE: START OF LOG: 20130723162528

F:\usr\sap\EC5\SUM\abap\exe\R3load.EXE: sccsid @(#) $Id: //bas/721_REL/src/R3ld/R3load/R3ldmain.c#5 $ SAP
F:\usr\sap\EC5\SUM\abap\exe\R3load.EXE: version R7.20/V1.6 [UNICODE]
Compiled Feb 23 2013 04:38:43
patchinfo (patches.h): (0.100) R3load/HANA: create R3load.info file (note 1821156)
process id 8388
F:\usr\sap\EC5\SUM\abap\exe\R3load.EXE -i F:\usr\sap\EC5\SUM\abap\exchange\compack\EX000009.COD -p F:\usr\sap\EC5\SUM\abap\log\EX000009.DPR -s F:\usr\sap\EC5\SUM\abap\log\EX000009.DST -dbcodepage 4103 -upg_nametab DDNTT~ DDNTF~

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file SDIC.SQL
(SQL) INFO: SDIC.SQL not found
DbSl Trace: Error 43851 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-43851 occurred at SQL stmt (parse error offset=216)

(DB) ERROR: DDL statement failed
(CREATE TABLE "DDNTF~" ( "TABNAME" VARCHAR2(90) DEFAULT ' ' NOT NULL , "BLOCKNR" NUMBER(3) DEFAULT 0 NOT NULL , "FIELDSLG" NUMBER(5,0) DEFAULT 0 NOT NULL , "FIELDS" BLOB ) TABLESPACE PSAPEC5 LOB ("FIELDS") store as securefile (enable storage in row cache ) STORAGE (INITIAL 490192896 NEXT 0000010240K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )
DbSlExecute: rc = 99
(SQL error 43851)
error message returned by DbSl:
ORA-43851: LOB feature unsupported below compatible 11.0.0
(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed
rc = 103, table "DDNTF~"
(SQL error 942)
error message returned by DbSl:
ORA-00942: table or view does not exist
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "DDNTF^0" ON "DDNTF~" ( "TABNAME", "BLOCKNR" ) TABLESPACE PSAPEC5 STORAGE (INITIAL 51380224 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )
DbSlExecute: rc = 103
(SQL error 942)
error message returned by DbSl:
ORA-00942: table or view does not exist
DbSl Trace: Error 43851 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-43851 occurred at SQL stmt (parse error offset=224)

(DB) ERROR: DDL statement failed
(CREATE TABLE "DDNTF_CONV_UC~" ( "TABNAME" VARCHAR2(90) DEFAULT ' ' NOT NULL , "BLOCKNR" NUMBER(3) DEFAULT 0 NOT NULL , "FIELDSLG" NUMBER(5,0) DEFAULT 0 NOT NULL , "FIELDS" BLOB ) TABLESPACE PSAPEC5 LOB ("FIELDS") store as securefile (enable storage in row cache ) STORAGE (INITIAL 494354432 NEXT 0000010240K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )
DbSlExecute: rc = 99
(SQL error 43851)
error message returned by DbSl:
ORA-43851: LOB feature unsupported below compatible 11.0.0
(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed
rc = 103, table "DDNTF_CONV_UC~"
(SQL error 942)
error message returned by DbSl:
ORA-00942: table or view does not exist
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "DDNTF_CONV_UC^0" ON "DDNTF_CONV_UC~" ( "TABNAME", "BLOCKNR" ) TABLESPACE PSAPEC5 STORAGE (INITIAL 51380224 NEXT 0000002560K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )
DbSlExecute: rc = 103
(SQL error 942)
error message returned by DbSl:
ORA-00942: table or view does not exist
(DB) INFO: DDNTT~ created #20130723162529

(IMP) INFO: import of DDNTT~ completed (892108 rows) #20130723162549

(DB) INFO: DDNTT^0 created #20130723162555

(DB) INFO: DDNTT_CONV_UC~ created #20130723162555

(IMP) INFO: import of DDNTT_CONV_UC~ completed (892342 rows) #20130723162622

(DB) INFO: DDNTT_CONV_UC^0 created #20130723162626

(DB) INFO: disconnected from DB