Composite Instances Are Failing - Log Shows TableSpace Exception "ORA-01653: unable to extend table"
(Doc ID 2261106.1)
Last updated on NOVEMBER 15, 2023
Applies to:
SOA Suite Cloud Service - Version N/A and laterInformation in this document applies to any platform.
Symptoms
Composite instances are stuck in SOA CS Environment and logs shows the below exceptions.
ERROR
-----------------------
java.sql.SQLException: ORA-01653: unable to extend table <TableName>.WORK_ITEM by 128 in tablespace <TableName>
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |