Article - CS240563
Workflow Stucks on the first task with Error java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows in FlexPLM 11
Modified: 28-Jun-2016
Applies To
- FlexPLM 11.0 F000
Description
- Workflow Stucks on the first task with Error
java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows - Stack trace in Methodserver log:
Nested exception is: A persistence error occurred.
Nested exception is: wt.workflow.WfException: A persistence error occurred.
Nested exception is: wt.pom.PersistenceException: A persistence error occurred.
wt.workflow.WfException: wt.workflow.WfException: A persistence error occurred.
Nested exception is: A persistence error occurred.
Nested exception is: wt.workflow.WfException: A persistence error occurred.
Nested exception is: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:
Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "INSERT INTO WorkItem(classnameA2A2,updateCountA2,actionPerformed,blob$context,completedBy,context,description,eventSet,classnamekeyD4,idA3D4,classnamekeyA2ownership,idA3A2ownership,classnamekeyC4,idA3C4,classnamekeyB4,priority,reassigned,required,role,classnamekeyA4,idA3A4,status,taskURLPathInfo,markForDeleteA2,variablePermissionMap,updateStampA2,createStampA2,modifyStampA2,idA2A2) VALUES ('wt.workflow.work.WorkItem',1,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)". Database system message follows:
Nested exception is: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "DBADMIN.GET_SOFTATT_COL", line 7
ORA-06512: at "DBADMIN.T_WORKITEM_END", line 16
ORA-04088: error during execution of trigger 'DBADMIN.T_WORKITEM_END'
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3897)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361)
at wt.pds.SQLDatabasePds.insertList(SQLDatabasePds.java:3206)
at wt.pds.SQLDatabasePds.insert(SQLDatabasePds.java:322)
at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:2460)
at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:596)
This is a printer-friendly version of Article 240563 and may be out of date. For the latest version click CS240563