ORA-06510, ORA-06512 Errors When Copying An Enterprise to Insight from Global Home Page
(Doc ID 2954958.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Insight Cloud Service - Version 8.2.3.1 and laterInformation in this document applies to any platform.
Symptoms
When attempting to copy an enterprise to Insight from GHP, we received the below error:
[EnterpiseID: ] 08-May-2023, 11:30:49:069, [32], UserId: , Exception DetailsMessage
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APR_MART.PKG_SETUP_NEW_ENTERPRISE", line 74
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APR_MART.PKG_SETUP_NEW_ENTERPRISE", line 282
ORA-06512: at "APR_MART.PKG_SETUP_NEW_ENTERPRISE", line 282
ORA-06512: at "APR_MART.PKG_SETUP_NEW_ENTERPRISE", line 106
ORA-06512: at "APR_MART.PKG_SETUP_NEW_ENTERPRISE", line 65
ORA-06512: at "APR_MART.PKG_SETUP_NEW_ENTERPRISE", line 65
ORA-06512: at line 1
ORA-06512: at "ARGUS_APP.PKG_CONSOLE_INSIGHT_GLOBAL_ENT", line 38
ORA-06512: at line 1
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 Relsys.Persistence.DataAccess.Oracle.Db.DoExecuteNonQuery(DbCommand command)
at Relsys.Persistence.DataAccess.Oracle.Db.ExecuteNonQuery(DbCommand command)
at Relsys.Persistence.DataAccess.DataAccess.ExecuteNonQuery(DbCommand dbCommand)
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APR_MART.PKG_SETUP_NEW_ENTERPRISE", line 74
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APR_MART.PKG_SETUP_NEW_ENTERPRISE", line 282
ORA-06512: at "APR_MART.PKG_SETUP_NEW_ENTERPRISE", line 282
ORA-06512: at "APR_MART.PKG_SETUP_NEW_ENTERPRISE", line 106
ORA-06512: at "APR_MART.PKG_SETUP_NEW_ENTERPRISE", line 65
ORA-06512: at "APR_MART.PKG_SETUP_NEW_ENTERPRISE", line 65
ORA-06512: at line 1
ORA-06512: at "ARGUS_APP.PKG_CONSOLE_INSIGHT_GLOBAL_ENT", line 38
ORA-06512: at line 1
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 Relsys.Persistence.DataAccess.Oracle.Db.DoExecuteNonQuery(DbCommand command)
at Relsys.Persistence.DataAccess.Oracle.Db.ExecuteNonQuery(DbCommand command)
at Relsys.Persistence.DataAccess.DataAccess.ExecuteNonQuery(DbCommand dbCommand)
STEPS
1. Launch the Global Home Page
2. Click Global Enterprise Management
3. Select an enterprise and click 'Copy Enterprise to Insight'
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 |
References |