ORA-55319 While Trying To Create Semantic Model With SYS User (Doc ID 1066796.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 10.2.0.4 to 11.2.0.1 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms


Trying to create a Semantic model with SYS user:

EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tblspace');
CREATE TABLE jtv_rdf_data (id NUMBER, triple SDO_RDF_TRIPLE_S);
EXECUTE SEM_APIS.CREATE_SEM_MODEL('jtv', 'jtv_rdf_data', 'triple');

*
ERROR at line 1:
ORA-13199: Error in SDO_RDF.CREATE_RDF_MODEL: SQLERRM=ORA-55319: model JTV
create attempt failed: Model error occurred: step_num=10 tab="JTV_RDF_DATA"
SQLERRM=ORA-55319: model JTV create attempt failed: Failed during RDF trigger
creation: trig_num=1 stmt=
CREATE OR REPLACE TRIGGER JTV_DML
BEFORE INSERT OR UPDATE OF TRIPLE OR DELETE
ON "SYS"."JTV_RDF_DATA"
BEGIN
IF DELETING THEN
MDSYS.RDF_APIS_INTERNAL.NOTIFY_MODEL_DML('JTV', 'DEL');
ELSIF INSERTING THEN
MDSYS.RDF_APIS_INTERNAL.NOTIFY_MODEL_DML('JTV', 'INS');
ELSIF UPDATING THEN
MDSYS dss=SELECT count("TRIPLE") FROM "JTV_RDF_DATA"
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_RDF", line 996
ORA-06512: at "MDSYS.SDO_RDF", line 1033
ORA-06512: at "MDSYS.RDF_APIS", line 982
ORA-06512: at line 1

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