2 Replies Latest reply on Jun 4, 2018 1:47 PM by Sdas-Oracle

    OracleDatabaseException during completeBulk

    2954860

      After running OracleBulkUpdateHandler.prepareBulk successfully on a ~2 GB RDF dataset, I get an OracleDatabaseException during completeBulk. Any idea why this would happen?

       

      The completeBulk flags I'm using are "PARSE PARALLEL=4 PARALLEL_CREATE_INDEX MBV_METHOD=SHADOW DEL_BATCH_DUPS=USE_INSERT MBT_JOIN_HINT=USE_HASH MBV_JOIN_HINT=USE_HASH".

       

      Here is the full stacktrace:

       

      ! oracle.jdbc.OracleDatabaseException: ORA-13199: During FRBD: [31-MAY-18 02.56.46.789133000 PM -04:00]

      ! ORA-12801: error signaled in parallel query server P003 [

      ! ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 7678

      !

      ! ]

      ! ORA-06512: at "MDSYS.MD", line 1723

      ! ORA-06512: at "MDSYS.MDERR", line 17

      ! ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 8013

      ! ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 10390

      ! ORA-06512: at "MDSYS.SDO_RDF", line 1220

      ! ORA-06512: at "MDSYS.RDF_APIS", line 949

      ! ORA-06512: at line 1

      !

      ! at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)

      ! ... 23 common frames omitted

      ! Causing: java.sql.SQLException: ORA-13199: During FRBD: [31-MAY-18 02.56.46.789133000 PM -04:00]

      ! ORA-12801: error signaled in parallel query server P003 [

      ! ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 7678

      !

      ! ]

      ! ORA-06512: at "MDSYS.MD", line 1723

      ! ORA-06512: at "MDSYS.MDERR", line 17

      ! ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 8013

      ! ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 10390

      ! ORA-06512: at "MDSYS.SDO_RDF", line 1220

      ! ORA-06512: at "MDSYS.RDF_APIS", line 949

      ! ORA-06512: at line 1

      !

      ! at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)

      ! at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)

      ! at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)

      ! at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)

      ! at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)

      ! at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)

      ! at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223)

      ! at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:56)

      ! at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:907)

      ! at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)

      ! at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)

      ! at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1300)

      ! at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887)

      ! at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4230)

      ! at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079)

      ! at oracle.spatial.rdf.client.jena.Oracle.executeCall(Oracle.java:922)

      ! at oracle.spatial.rdf.client.jena.OracleBulkUpdateHandler.completeBulk(OracleBulkUpdateHandler.java:1639)

      ! at oracle.spatial.rdf.client.jena.OracleBulkUpdateHandler.completeBulk(OracleBulkUpdateHandler.java:1573)

      ! at com.oracle.ci.el.database.services.BulkLoadTask.call(BulkLoadTask.java:110)

      ! at com.oracle.ci.el.database.services.BulkLoadTask.call(BulkLoadTask.java:23)

      ! at java.util.concurrent.FutureTask.run(FutureTask.java:266)

      ! at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

      ! at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

      ! at java.lang.Thread.run(Thread.java:745)