WHODrug Dictionary Load Fails with the Error "Failed to create Dictionary User. Verify the user doesn't exists"
(Doc ID 2902492.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Safety - Version 8.2.3 and laterInformation in this document applies to any platform.
Symptoms
Getting the below error when loading WHO Drug Dictionary B3 format:
WHODD version : SEP2022 B3 format.
ARGUS Version: ARGUS 8.2.3
Error on Pop-up Dialog:
Unhandled exception has occurred in a component in your application.
If you click Continue. the application will ignore this error and attempt to continue.
If you click Continue. the application will ignore this error and attempt to continue.
Error in Status Field of Dictionary Loader screen:
Ready ...10/06/2022 21:11:30: Begin Dictionary Loading
10/06/2022 21:11:30: Dictionary loading for: DBName: ARS1P010, DBUserName: AS_DBA_USER, DictionaryType: WHODRUG, Dictionary Format : B3, IsMedDRAJ: false, IsOverwrite: False, CurrentVersion: 2022-SEP, OverwriteVersion: , DictionaryUserName: WHO_B3_2022_SEP_USER, DictionaryTableSpace: USERS, DictionaryIndex: USERS, UserDefaultTablespace: USERS, UserTempTablespace: TEMP, DictionaryPath: E:\Dictionaries\whodrug_global_b3_sep_1_2022
10/06/2022 21:11:30: Retriving Dictionary Version Information From VersionFile.
10/06/2022 21:11:30: Dictionary Version From VersionFile: WHODRUG GLOBAL B3 September 1, 2022
10/06/2022 21:11:30: Extracting Dictionary CTL Files.
10/06/2022 21:11:30: Creating New Dictionary User.
10/06/2022 21:11:30: Contact your system administrator
10/06/2022 21:11:30: Exception occurred while loading dictionary - Rollback has been initiated.
Failed to create Dictionary User. Verify the user doesn't exists.
10/06/2022 21:11:30: Dictionary loading for: DBName: ARS1P010, DBUserName: AS_DBA_USER, DictionaryType: WHODRUG, Dictionary Format : B3, IsMedDRAJ: false, IsOverwrite: False, CurrentVersion: 2022-SEP, OverwriteVersion: , DictionaryUserName: WHO_B3_2022_SEP_USER, DictionaryTableSpace: USERS, DictionaryIndex: USERS, UserDefaultTablespace: USERS, UserTempTablespace: TEMP, DictionaryPath: E:\Dictionaries\whodrug_global_b3_sep_1_2022
10/06/2022 21:11:30: Retriving Dictionary Version Information From VersionFile.
10/06/2022 21:11:30: Dictionary Version From VersionFile: WHODRUG GLOBAL B3 September 1, 2022
10/06/2022 21:11:30: Extracting Dictionary CTL Files.
10/06/2022 21:11:30: Creating New Dictionary User.
10/06/2022 21:11:30: Contact your system administrator
10/06/2022 21:11:30: Exception occurred while loading dictionary - Rollback has been initiated.
Failed to create Dictionary User. Verify the user doesn't exists.
Changes
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 |
Changes |
Cause |
Solution |