Support Article
Unable to obtain unique id: SQLException: ORA-06550
SA-39782
Summary
Error occurs when creating a work item using the Work- GenerateID activity.
Error Messages
(TD-RTL-OPS-CardDispute-Claim)Unable to obtain unique id: Error during getDataUniqueID bean call: code: SQLState: java.lang.RuntimeException: Problem during method invocation (getDataUniqueID) Message:
DatabaseException caused by prior exception: javax.ejb.EJBException: java.lang.RuntimeException: Problem during method invocation (getDataUniqueID)
DatabaseException caused by prior exception: java.lang.RuntimeException: Problem during method invocation (getDataUniqueID)
DatabaseException caused by prior exception: com.pega.pegarules.pub.database.DatabaseException: Problem encountered executing a stored procedure: code: 6550 SQLState: 65000 Message: ORA-06550: line 1, column 20:
PLS-00905: object DATA.SPPC_DATA_UNIQUEID is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
DatabaseException caused by prior exception: java.sql.SQLException: ORA-06550: line 1, column 20:
PLS-00905: object DATA.SPPC_DATA_UNIQUEID is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
| SQL Code: 6550 | SQL State: 65000
From: (your_id)
SQL: {call DATA.sppc_data_uniqueid (?,?,?,?)}
SQL Inserts: <> <> <>
Caused by SQL Problems.
Problem #1, SQLState 65000, Error code 6550: java.sql.SQLException: ORA-06550: line 1, column 20:
PLS-00905: object DATA.SPPC_DATA_UNIQUEID is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
DatabaseException caused by prior exception: java.sql.SQLException: ORA-06550: line 1, column 20:
PLS-00905: object DATA.SPPC_DATA_UNIQUEID is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
| SQL Code: 6550 | SQL State: 65000
Steps to Reproduce
Use the Work- GenerateID activity to create a work item.
Root Cause
A third-party product issue.
The DATA.SPPC_DATA_UNIQUEID Stored Procedure was invalid.
Resolution
Make the following change to the operating environment:
Use the SQL Developer to recompile the Stored Procedure.
Published October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.