1 Reply Latest reply on Feb 23, 2017 4:28 PM by Sdas-Oracle

    Unable to import geonames dataset into oracle rdf database

    3401502

      I downloaded geonames rdf file ( 161 Million triples) and converted it into nt format.

      Uploaded the nt file data to temp table through sql loader.  At this point when I import the data from temp data to rdf model

      i am getting below error. No duplicates in temp table.

       

      Command : EXECUTE SEM_APIS.BULK_LOAD_FROM_STAGING_TABLE('geonames2', 'rdf_obj', 'geonames_stage_table');

       

      Error :

      Error report:

      ORA-13199: During MBV: [22-FEB-17 10.09.49.798622000 AM -05:00]

      ORA-00001: unique constraint (MDSYS.RDF_VAL_NAMETYLITLNG_IDX) violated [

      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 3672

      ] 
      ORA-06512: at "MDSYS.MD", line 1723 
      ORA-06512: at "MDSYS.MDERR", line 17 
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 3760 
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 7395 
      ORA-06512: at "MDSYS.SDO_RDF", line 1014 
      ORA-06512: at "MDSYS.RDF_APIS", line 926 
      ORA-06512: at line 1 
      13199. 00000 -  "%s" 
      *Cause:    This is an internal error. 
      *Action:   Contact Oracle Support Services.