2 Replies Latest reply on May 7, 2009 10:08 PM by Sdas-Oracle

    ORA-13199: During MERGE ... (MDSYS.RDF_VAL_NAMETYLITLNG_IDX) violated

    671085
      Hi all

      I get this error when executing sem_apis.bulk_load_from_staging_table :

      SQL> execute sem_apis.bulk_load_from_staging_table('rdf_model', 'itmuser', 'staging');
      BEGIN sem_apis.bulk_load_from_staging_table('rdf_model', 'itmuser', 'staging'); END;

      *
      ERROR at line 1:
      ORA-13199: During MERGE ORA-00001: unique constraint
      (MDSYS.RDF_VAL_NAMETYLITLNG_IDX) violated
      ORA-06512: at "MDSYS.MD", line 1723
      ORA-06512: at "MDSYS.MDERR", line 17
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 1188
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 1976
      ORA-06512: at "MDSYS.SDO_RDF", line 294
      ORA-06512: at "MDSYS.RDF_APIS", line 542
      ORA-06512: at line 1

      Do you have an idea where it can come from ? can it come from special/unusual/duplicated values in the staging table data ?

      Thanks
      Thomas