ORA-06550 Error : ESM Service Unable To Generate The ACK files
(Doc ID 2784976.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Interchange Cloud Service - Version 8.2 to 8.2 [Release 8.1]Oracle Life Sciences Argus Interchange - Version 8.2.1 to 8.2.1 [Release 8.2]
Microsoft Windows x64 (64-bit)
Symptoms
ESM Service was unable to generate all the ACK files. Following error was logged in ESM ACK transmission logs for all the files -
System error has occurred in ESMProc.Generate_ACK Fn while executing ESM_PKG_NONDLP.GENERATE_ACKNOWLEDGMENT stored procedure, error number = 5 error desc. = Contact your system administrator error source = Relsys.Persistence.DataAccess
Additionally, following error was logged for ESMProc process -
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to
'GENERATE_ACKNOWLEDGMENT'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Stack Trace
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx*
pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable, OracleLogicalTransaction m_OracleLogicalTransaction)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck, OracleLogicalTransaction m_OracleLogicalTransaction)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command)
at Relsys.Persistence.DataAccess.DataAccess.ExecuteNonQuery(DbCommand dbCommand)
PLS-00306: wrong number or types of arguments in call to
'GENERATE_ACKNOWLEDGMENT'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Stack Trace
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx*
pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable, OracleLogicalTransaction m_OracleLogicalTransaction)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck, OracleLogicalTransaction m_OracleLogicalTransaction)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command)
at Relsys.Persistence.DataAccess.DataAccess.ExecuteNonQuery(DbCommand dbCommand)
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 |