Error while updating Solution Manager

[Former Member]

Hello Community !

While upgrading SolMan 7.0 to 7.1 I am getting an error :

Severe error(s) occurred in phase MAIN_SHDCRE/EU_IMPORT1!

Last error code set: 2 error during parallel execution of processes, check 'EU_IMP1.ELG' for details<br/> 4 processes failed, check 'EU_IMNDB.*' for details

Log file:

D:\sum\SUM\abap\exe\R3load.EXE: START OF LOG: 20131226125210

D:\sum\SUM\abap\exe\R3load.EXE: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#19 $ SAP

D:\sum\SUM\abap\exe\R3load.EXE: version R7.20/V1.4 [UNICODE]

Compiled Sep 14 2013 00:21:21

patchinfo (patches.h): (0.441) R3load hangs if called with unknown option (note 1895764)

process id 15680

D:\sum\SUM\abap\exe\R3load.EXE -i D:\sum\SUM\abap\exchange\compack\EX000009.COD -p D:\sum\SUM\abap\log\EX000009.LOG -s D:\sum\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) ERROR: could not find regular export directory

(SQL) INFO: Searching for SQL file SDIC.SQL

(SQL) INFO: SDIC.SQL not found

(SQL) ERROR: could not find regular export directory

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 PSAPSR3  LOB ("FIELDS") store as securefile (enable storage in row cache ) STORAGE (INITIAL 149716992 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 PSAPSR3 STORAGE (INITIAL 11894784 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 PSAPSR3  LOB ("FIELDS") store as securefile (enable storage in row cache ) STORAGE (INITIAL 146046976 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 PSAPSR3 STORAGE (INITIAL 15007744 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 #20131226125210

(IMP) INFO: import of DDNTT~ completed (443458 rows) #20131226125220

(DB) INFO: DDNTT^0 created #20131226125221

(DB) INFO: DDNTT_CONV_UC~ created #20131226125221

(IMP) INFO: import of DDNTT_CONV_UC~ completed (443719 rows) #20131226125230

(DB) INFO: DDNTT_CONV_UC^0 created #20131226125232

(DB) INFO: disconnected from DB

D:\sum\SUM\abap\exe\R3load.EXE: job finished with 6 error(s)

D:\sum\SUM\abap\exe\R3load.EXE: END OF LOG: 20131226125232

[karthikeyan_natarajan4 · Accepted solution]

HI Igor,

Have you checked this thread.

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

[former_member45419]

Hi Igor,

As RB said pls check the parameter & check this threads

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

Regards

Nayeem

[former_member185239]

Hi Igor,

Checked the compatible parameter for oracle

1.logon to sqlplus

2. execute the command

sql> show parameter compatible       if it is not 11.0.0 then update the parameter

Also let us know the oracle version and use the latest r3trans , r3load

With Regards

Ashutosh Chaturvedi

[AtulKumarJain]

Hi Igor,

as shown in your log

ERROR: could not find regular export directory

could you please check and ensure about export dir .

BR

Atul

[Reagan]

ORA-43851: LOB feature unsupported below compatible 11.0.0

Check whether the compatible parameter is set to 11.2.0

Regards

RB