ORA-01452 Duplicate Keys Found While Creating Entailment With OWL2RL Rulebase (Doc ID 1323189.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial - Version: 11.2.0.2.0 and later   [Release: and later ]
Information in this document applies to any platform.

Symptoms


Error ORA-1452 "cannot CREATE UNIQUE INDEX; duplicate keys found"

while creating Entailment using the OWL2RL rulebase:

EXECUTE SEM_APIS.CREATE_ENTAILMENT('ARMAONTO_RI', sem_models('ARMAONTO'),sem_rulebases('OWL2RL'),SEM_APIS.REACH_CLOSURE, null, null);

While diagnosing discovered that the component making the CREATE_ENTAILMENT fail is CLS-MAXC2

The testing command that failed:

EXECUTE SEM_APIS.CREATE_ENTAILMENT('NEWARMAONTO_RI',sem_models('ARMAONTO'),sem_rulebases('OWLPRIME','MYRB'),SEM_APIS.REACH_CLOSURE, 'AVFH,CHAIN,INTERSECT,INTERSECTSCOH,UNION,SVFH,THINGH,THINGSAM,ONEOF,HASKEY,SCM-HV,CLS-SVF2,ALLDIFF,ALLDISJP,ALLDISJC,SCM-CLS,SCM-OP,SCM-DP,CLS-MAXC2', ',REFLEX_SAM=T,LOG=5');

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