DMW: "An Unexpected Error Occurred While Processing The Queries" with Browse Listings the DMW, then ORA-01722 in the Weblogic Diagnostic Log
(Doc ID 2472936.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Health Sciences Data Management Workbench - Version 2.4.8 and later
Information in this document applies to any platform.
DMW 2.4.8, with Listings, users get the following error message when attempting to browse data in DMW:
- This model has data
- However, users are not able to browse it in DMW
- Users can successfully browse the same model inside LSH
In the Weblogic Diagnostic Log, you see the error message on a SELECT statement:
STEPS TO REPLICATE
1. go to DMW
2. go to Listing
3. go to Study
4. go to Listings
5. select Browse
6. There is a message:
Confirmation: Do you want to access the blinded data (yes) (no)
7. Select Yes, and then the resulting Error Message is:
DMW-###: An unexpected error occurred while processing the queries. Please try again. If the error persists please contact the system administrator.
Masking criteria on a numeric column was configured with characters.
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