sap errors and solutions

Just another SAP blog

ORA-43851: LOB feature unsupported below compatible 11.0.0

Error: ORA-43851: LOB feature unsupported below compatible 11.0.0

I got this error when Importing Oracle export in target system using SWPM.

 

Error Log file:

K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG:

K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/721_STACK/src/R3ld/R3load/R3ldmain.c#1 $ SAP
K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.6 [UNICODE]
Compiled May 31 2016 04:02:04
patchinfo (patches.h): (0.627) DB6: Not all rows loaded after load resetdictionaryonly (note 2303353)
process id 4008
K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe -ctf I L:\Export\ABAP\DATA\SAPNTAB.STR C:\Program Files\sapinst_instdir\BS2005\ERP60SR3\LM\COPY\ORA\SYSTEM\CENTRAL\AS\DDLORA.TPL SAPNTAB.TSK ORA -l SAPNTAB.log

(PRC) INFO: working directory “C:\Program Files\sapinst_instdir\BS2005\ERP60SR3\LM\COPY\ORA\SYSTEM\CENTRAL\AS”

K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: job completed
K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG:

K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG:

K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/721_STACK/src/R3ld/R3load/R3ldmain.c#1 $ SAP
K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.6 [UNICODE]
Compiled May 31 2016 04:02:04
patchinfo (patches.h): (0.627) DB6: Not all rows loaded after load resetdictionaryonly (note 2303353)
process id 3984
K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -stop_on_error

(PRC) INFO: working directory “C:\Program Files\sapinst_instdir\BS2005\ERP60SR3\LM\COPY\ORA\SYSTEM\CENTRAL\AS”
(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16
(GSI) INFO: dbname   = “QAS20161110121149                                                                                                               ”
(GSI) INFO: vname    = “ORACLE                          ”
(GSI) INFO: hostname = “VMSSQNA                                                         ”
(GSI) INFO: sysname  = “Windows NT”
(GSI) INFO: nodename = “VMSSQNA”
(GSI) INFO: release  = “6.2”
(GSI) INFO: version  = “9200 ”
(GSI) INFO: machine  = “2x AMD64 Level 6 (Mod 58 Step 0)”
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file L:\Export\ABAP\DB/SQLFiles.LST
(SQL) INFO: L:\Export\ABAP\DB/SQLFiles.LST not found
(SQL) INFO: Searching for SQL file SDIC.SQL
(SQL) INFO: SDIC.SQL not found
(SQL) INFO: Searching for SQL file L:\Export\ABAP\DB/ORA/SDIC.SQL
(SQL) INFO: L:\Export\ABAP\DB/ORA/SDIC.SQL not found
(DB) INFO: SVERS created #

(IMP) INFO: import of SVERS completed (1 rows)

(DB) INFO: SVERS~0 created

DbSl Trace: Error 43851 in exec_immediate() from oci_execute_stmt(), orpc=0

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

(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 0000000016K 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
(DB) INFO: disconnected from DB

K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)
K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG:

K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG:

K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/721_STACK/src/R3ld/R3load/R3ldmain.c#1 $ SAP
K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.20/V1.6 [UNICODE]
Compiled May 31 2016 04:02:04
patchinfo (patches.h): (0.627) DB6: Not all rows loaded after load resetdictionaryonly (note 2303353)
process id 4512
K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPNTAB.cmd -dbcodepage 4103 -l SAPNTAB.log -stop_on_error

(PRC) INFO: working directory “C:\Program Files\sapinst_instdir\BS2005\ERP60SR3\LM\COPY\ORA\SYSTEM\CENTRAL\AS”
(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16
(GSI) INFO: dbname   = “QAS20161110121149                                                                                                               ”
(GSI) INFO: vname    = “ORACLE                          ”
(GSI) INFO: hostname = “VMSSQNA                                                         ”
(GSI) INFO: sysname  = “Windows NT”
(GSI) INFO: nodename = “VMSSQNA”
(GSI) INFO: release  = “6.2”
(GSI) INFO: version  = “9200 ”
(GSI) INFO: machine  = “2x AMD64 Level 6 (Mod 58 Step 0)”
(SQL) INFO: Searching for SQL file SQLFiles.LST
(SQL) INFO: SQLFiles.LST not found
(SQL) INFO: Searching for SQL file L:\Export\ABAP\DB/SQLFiles.LST
(SQL) INFO: L:\Export\ABAP\DB/SQLFiles.LST not found
(SQL) INFO: Searching for SQL file SDIC.SQL
(SQL) INFO: SDIC.SQL not found
(SQL) INFO: Searching for SQL file L:\Export\ABAP\DB/ORA/SDIC.SQL
(SQL) INFO: L:\Export\ABAP\DB/ORA/SDIC.SQL not found
(DB) ERROR: DDL statement failed
(DROP TABLE “DDNTF”)
DbSlExecute: rc = 103
(SQL error 942)
error message returned by DbSl:
ORA-00942: table or view does not exist
(IMP) INFO: a failed DROP attempt is not necessarily a problem
DbSl Trace: Error 43851 in exec_immediate() from oci_execute_stmt(), orpc=0

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

(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 0000000016K 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
(DB) INFO: disconnected from DB

K:\usr\sap\QAS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

 

Solution:

  • Edit initSID.ora file
  • change parameter compatible=10.2.0 to 11.2.0
  • shutdown oracle using shutdown immediate command.
  • backup initSID.ora and SPfile
  • execute command “create spfile from pfile”
  • startup database
  • Retry the Import.

 

Updated: November 10, 2016 — 9:33 pm

Leave a Reply

Your email address will not be published. Required fields are marked *

sap errors and solutions © 2016 Frontier Theme
Copy Protected by Chetan's WP-Copyprotect.