Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OracleDatabaseException during completeBulk

2954860May 31 2018 — edited Jun 4 2018

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)

Comments

2954860

Also, completeBulk has run successfully for the same model with several other, smaller datasets.

Sdas-Oracle

A SQL insert/append command seems to have failed. Please check if there is enough space on the tablespaces.

Also, feel free to contact me directly at souripriya dot das at oracle dot com.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 2 2018
Added on May 31 2018
2 comments
4,461 views