My Oracle Support Banner

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 later
Information 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)

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.