Unable to Load MedDRA via Argus Console Due to ORA-06508
(Doc ID 2982174.1)
Last updated on NOVEMBER 08, 2023
Applies to:
Oracle Life Sciences Argus Safety - Version 8.2.3.1 to 8.4.1 [Release 8.2 to 8.4]Oracle Life Sciences Argus Safety Cloud Service - Version 8.2.3.1 to 8.4.1 [Release 8.2 to 8.4]
Information in this document applies to any platform.
Symptoms
Error encountered when attempting to [Load] a MedDRA dictionary using Self-Servicing Dictionary Loader (Argus Console > Tools > Dictionary Management > Dictionary Loader)
10/17/2023 12:24:46: DBName: <DBNAME>, DictionaryType: MEDDRA, Dictionary Format: NONE, IsWhoChinese: False , IsMedDRAJ: False , IsOverwrite: False, Version: 26.1, DictionaryUserName: Argus_MEDDRA_26_1, DictionaryTableSpace: USERS, DictionaryIndex: USERS, UserDefaultTablespace: USERS, UserTempTablespace: TEMP
10/17/2023 12:24:46: Processing dictionary files has started.
10/17/2023 12:24:46: Downloading dictionary zip file from Database.
10/17/2023 12:24:46: Extracting dictionary zip file to local drive.
10/17/2023 12:27:46: Validating dictionary zip file.
10/17/2023 12:27:47: Validating dictionary zip file completed and all files are valid.
10/17/2023 12:27:47: Downloading dictionary meta data file from Database.
10/17/2023 12:27:47: Processing dictionary data has been started.
10/17/2023 12:27:48: Configuring dictionary meta data.
10/17/2023 12:27:48: Creating dictionary user in Database.
10/17/2023 12:27:48: Error in creating dictionary user in Database: System.Exception: Contact your system administrator ---> Oracle.DataAccess.Client.OracleException: ORA-04063: package body "ARGUS_DBA.PKG_DICT_MNGMT_METADATA_CONF" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ARGUS_DBA.PKG_DICT_MNGMT_METADATA_CONF"
ORA-06512: at line 1
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.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader()
at Oracle.DataAccess.Client.OracleCommand.ExecuteScalar()
at Relsys.Persistence.DataAccess.Oracle.Db.DoExecuteScalar(IDbCommand command)
at Relsys.Persistence.DataAccess.Oracle.Db.ExecuteScalar(DbCommand command)
at Relsys.Persistence.DataAccess.DataAccess.ExecuteScalar(DbCommand dbCommand)
--- End of inner exception stack trace ---
at Relsys.Persistence.DataAccess.DataAccess.ExecuteScalar(DbCommand dbCommand)
at Relsys.Argus.Service.Implementations.DictionaryLoader.ArgusDB.CreateDictionaryUser(String sUserName, String sPassword, String sDefaultTablespace, String sTempTablespace)
at Relsys.Argus.Service.Implementations.DictionaryLoader.AccessMetadataConfig.CreateUser()
10/17/2023 12:27:48: Error in processing dictionary data: System.Exception: Contact your system administrator ---> Oracle.DataAccess.Client.OracleException: ORA-04063: package body "ARGUS_DBA.PKG_DICT_MNGMT_METADATA_CONF" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ARGUS_DBA.PKG_DICT_MNGMT_METADATA_CONF"
ORA-06512: at line 1
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.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader()
at Oracle.DataAccess.Client.OracleCommand.ExecuteScalar()
at Relsys.Persistence.DataAccess.Oracle.Db.DoExecuteScalar(IDbCommand command)
at Relsys.Persistence.DataAccess.Oracle.Db.ExecuteScalar(DbCommand command)
at Relsys.Persistence.DataAccess.DataAccess.ExecuteScalar(DbCommand dbCommand)
--- End of inner exception stack trace ---
at Relsys.Persistence.DataAccess.DataAccess.ExecuteScalar(DbCommand dbCommand)
at Relsys.Argus.Service.Implementations.DictionaryLoader.ArgusDB.CreateDictionaryUser(String sUserName, String sPassword, String sDefaultTablespace, String sTempTablespace)
at Relsys.Argus.Service.Implementations.DictionaryLoader.AccessMetadataConfig.CreateUser()
at Relsys.Argus.Service.Implementations.DictionaryLoader.DictionaryDataProcess.ConfigureDictionaryMetadata()
at Relsys.Argus.Service.Implementations.DictionaryLoader.DictionaryDataProcess.ProcessDictionaryData()
10/17/2023 12:27:48: Exception occurred while loading dictionary - Rollback has been initiated.
10/17/2023 12:24:46: Processing dictionary files has started.
10/17/2023 12:24:46: Downloading dictionary zip file from Database.
10/17/2023 12:24:46: Extracting dictionary zip file to local drive.
10/17/2023 12:27:46: Validating dictionary zip file.
10/17/2023 12:27:47: Validating dictionary zip file completed and all files are valid.
10/17/2023 12:27:47: Downloading dictionary meta data file from Database.
10/17/2023 12:27:47: Processing dictionary data has been started.
10/17/2023 12:27:48: Configuring dictionary meta data.
10/17/2023 12:27:48: Creating dictionary user in Database.
10/17/2023 12:27:48: Error in creating dictionary user in Database: System.Exception: Contact your system administrator ---> Oracle.DataAccess.Client.OracleException: ORA-04063: package body "ARGUS_DBA.PKG_DICT_MNGMT_METADATA_CONF" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ARGUS_DBA.PKG_DICT_MNGMT_METADATA_CONF"
ORA-06512: at line 1
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.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader()
at Oracle.DataAccess.Client.OracleCommand.ExecuteScalar()
at Relsys.Persistence.DataAccess.Oracle.Db.DoExecuteScalar(IDbCommand command)
at Relsys.Persistence.DataAccess.Oracle.Db.ExecuteScalar(DbCommand command)
at Relsys.Persistence.DataAccess.DataAccess.ExecuteScalar(DbCommand dbCommand)
--- End of inner exception stack trace ---
at Relsys.Persistence.DataAccess.DataAccess.ExecuteScalar(DbCommand dbCommand)
at Relsys.Argus.Service.Implementations.DictionaryLoader.ArgusDB.CreateDictionaryUser(String sUserName, String sPassword, String sDefaultTablespace, String sTempTablespace)
at Relsys.Argus.Service.Implementations.DictionaryLoader.AccessMetadataConfig.CreateUser()
10/17/2023 12:27:48: Error in processing dictionary data: System.Exception: Contact your system administrator ---> Oracle.DataAccess.Client.OracleException: ORA-04063: package body "ARGUS_DBA.PKG_DICT_MNGMT_METADATA_CONF" has errors
ORA-06508: PL/SQL: could not find program unit being called: "ARGUS_DBA.PKG_DICT_MNGMT_METADATA_CONF"
ORA-06512: at line 1
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.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.DataAccess.Client.OracleCommand.ExecuteReader()
at Oracle.DataAccess.Client.OracleCommand.ExecuteScalar()
at Relsys.Persistence.DataAccess.Oracle.Db.DoExecuteScalar(IDbCommand command)
at Relsys.Persistence.DataAccess.Oracle.Db.ExecuteScalar(DbCommand command)
at Relsys.Persistence.DataAccess.DataAccess.ExecuteScalar(DbCommand dbCommand)
--- End of inner exception stack trace ---
at Relsys.Persistence.DataAccess.DataAccess.ExecuteScalar(DbCommand dbCommand)
at Relsys.Argus.Service.Implementations.DictionaryLoader.ArgusDB.CreateDictionaryUser(String sUserName, String sPassword, String sDefaultTablespace, String sTempTablespace)
at Relsys.Argus.Service.Implementations.DictionaryLoader.AccessMetadataConfig.CreateUser()
at Relsys.Argus.Service.Implementations.DictionaryLoader.DictionaryDataProcess.ConfigureDictionaryMetadata()
at Relsys.Argus.Service.Implementations.DictionaryLoader.DictionaryDataProcess.ProcessDictionaryData()
10/17/2023 12:27:48: Exception occurred while loading dictionary - Rollback has been initiated.
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 |