RDF Triple Store-ORA-55320: Model Error Occurred, after Upgrade to Oracle 12c
(Doc ID 1997133.1)
Last updated on APRIL 08, 2022
Applies to:
Oracle Spatial and Graph - Version 12.1.0.1 and laterInformation in this document applies to any platform.
Symptoms
After upgrade from 11.2.0.3 to 12c, following exception occurs whenever we use the replace option in SPARQL motion script while loading data in RDF Triple store.
Using the append option was working fine, however using replace threw exception.
The new Oracle 12c instance has these additional fields, which were not present in Oracle 11.2 and thus are causing compatibility issues .
Caused by: java.sql.SQLException: ORA-55320: model Error occurred while dropping model:ORA-00904: "MODEL_TYPE": invalid identifier
format_error_backtrace is:
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 12101
drop attempt failed:
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 12207
ORA-06512: at "MDSYS.SDO_RDF", line 1937
ORA-06512: at line 1
desc mdsys.rdf_model$
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER VARCHAR2(128)
MODEL_ID NUMBER
MODEL_NAME VARCHAR2(25)
TABLE_NAME VARCHAR2(128)
COLUMN_NAME VARCHAR2(30)
MODEL_TABLESPACE_NAME VARCHAR2(30)
desc mdsys.rdf_model_internal$;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER_ID NUMBER
MODEL_ID NOT NULL NUMBER
MODEL_NAME VARCHAR2(25)
TABLE_ID NUMBER
COLUMN_NAME VARCHAR2(30)
MODEL_TABLESPACE_NAME VARCHAR2(30)
FLAGS NUMBER
Note: DB vault is not enabled on the Database.
Changes
Upgrade from 11.2.0.3 to 12.1.0.2
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |