2 Replies Latest reply on Mar 19, 2007 4:03 AM by Mannamal-Oracle

    Problem in loading Ntriple to Oracle

    502844
      Hello,
      I am using the Java code provided by Oracle website to load Ntriple into Oracle
      Oracle's RDF storage type, SDO_RDF_TRIPLE_S in Oracle10g R2.When I am loading my n-triple file into Oracle RDF,I get the following error

      r>java TestNTriple2NDM Data/timestamp.nt TIMEST
      AMP_RDF_DATA TIMEMODEL 3
      ID: 1403 Error: java.sql.SQLException: ORA-13199: RDF:Error occurred
      ORA-06512: at "MDSYS.MD", line 1723
      ORA-06512: at "MDSYS.MDERR", line 17
      ORA-06512: at "MDSYS.SDO_RDF_TRIPLE_S", line 322

      ID: 3641 Error: java.sql.SQLException: ORA-13199: RDF:Error occurred
      ORA-06512: at "MDSYS.MD", line 1723
      ORA-06512: at "MDSYS.MDERR", line 17
      ORA-06512: at "MDSYS.SDO_RDF_TRIPLE_S", line 322


      Can some one give some clue about what could be the possible error

      Thanks



      Prateek
        • 1. Re: Problem in loading Ntriple to Oracle
          502844
          Hello,
          Actually the complete error is

          C:\prateek\semdis\sdordf_converter>java TestNTriple2NDM Data/timestamp.nt TIMEST
          AMP_RDF_DATA TIMEMODEL 3
          ID: 1403 Error: java.sql.SQLException: ORA-13199: RDF:Error occurred
          ORA-06512: at "MDSYS.MD", line 1723
          ORA-06512: at "MDSYS.MDERR", line 17
          ORA-06512: at "MDSYS.SDO_RDF_TRIPLE_S", line 322

          ID: 3641 Error: java.sql.SQLException: ORA-13199: RDF:Error occurred
          ORA-06512: at "MDSYS.MD", line 1723
          ORA-06512: at "MDSYS.MDERR", line 17
          ORA-06512: at "MDSYS.SDO_RDF_TRIPLE_S", line 322

          ID: 5835 Error: java.sql.SQLException: Unsupported feature
          Rows: 10000
          ID: 10754 Error: java.sql.SQLException: ORA-13199: RDF:Error occurred
          ORA-06512: at "MDSYS.MD", line 1723
          ORA-06512: at "MDSYS.MDERR", line 17
          ORA-06512: at "MDSYS.SDO_RDF_TRIPLE_S", line 322

          ID: 10755 Error: java.sql.SQLException: ORA-13199: RDF:Error occurred
          ORA-06512: at "MDSYS.MD", line 1723
          ORA-06512: at "MDSYS.MDERR", line 17
          ORA-06512: at "MDSYS.SDO_RDF_TRIPLE_S", line 322

          ID: 10868 Error: java.sql.SQLException: Unsupported feature
          • 2. Re: Problem in loading Ntriple to Oracle
            Mannamal-Oracle
            I presume you are using 10.2.0.1. One of the problems with 10.2.0.1 was that error messages did not have enough details. This has been fixed in later patches. Would it be possible to apply the 10.2.0.3 patch?

            ID: 1403 and ID: 3641 indicate the block of triples that could have been a problem. You could look at these triples and the triples around these to determine what the problem could be. It could be that there are some triples not in Ntriple format, or that there was a null object string or an object string with leading blanks (this is a known problem in 10.2.0.1). I would suggest first starting with a visual inspection of triples in that range.

            Melli