RDF Triple Store-ORA-55320: Model Error Occurred, after Upgrade to Oracle 12c (Doc ID 1997133.1)

Last updated on APRIL 29, 2015

Applies to:

Oracle Spatial and Graph - Version 12.1.0.1 and later
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms