Composite Instance Fails And Logs Shows TableSpace Exception"ORA-01653: unable to extend table" (Doc ID 2261106.1)

Last updated on MAY 04, 2017

Applies to:

SOA Suite Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On : NA version, Core SOA Product Issues

Composite instances are stuck in SOA CS Environment and logs shows the below exceptions.

ERROR
-----------------------
java.sql.SQLException: ORA-01653: unable to extend table SP1617_SOAINFRA.WORK_ITEM by 128 in tablespace SP1716_SOAINFRA


Error Code: 1653
Call: INSERT INTO WORK_ITEM (NODE_ID, CIKEY, SCOPE_ID, COUNT_ID, CLUSTER_NODE_ID, CLUSTER_NODE_KEY, COMMENTS, CREATION_DATE, CREATOR, CUSTOM_ID, DELAY, EXECUTION_TYPE, EXP_DATE, EXP_FLAG, EXT_INT1, EXT_STRING1, EXT_STRING2, FIRST_DELAY, IDEMPOTENT_FLAG, LABEL, MODIFIER, MODIFY_DATE, CI_PARTITION_DATE, PRIORITY, REFERENCE_ID, STATE, TRANSITION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [BpWai0, 150337, BpSeq4.4914, 1, xxxxxxx-null, 22, null, 2017-04-23 10:29:08.926, null, null, 0, 0, 2017-04-23 10:29:18.926, 0, 0, null, null, 0, 1, WaitForJobStatusChngALC, null, 2017-04-23 10:29:08.969, 2017-04-21 10:06:55.594, 3, null, 3, 0]
Query: InsertObjectQuery(150337-BpWai0-BpSeq4.4914-1)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:900)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:962)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:631)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2002)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:298)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:377)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:165)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:180)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:489)


 
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms