Error Msg 166100 And ORA-00904 When Attempting To Perform A Data Extract
(Doc ID 351349.1)
Last updated on DECEMBER 04, 2019
Applies to:
Oracle Clinical - Version 4.5.1 and laterInformation in this document applies to any platform.
***Checked for relevance on 07-May-2010***
Symptoms
Oracle Clinical 4.5 in production, users are encountering errors when attempting to perform a data extract
They have created a user defined procedure, and called it with an Extract Macro.
When try to view data from Clinical, the following errors occur:
They have deleted extract macros and created again but getting same error
ERROR
166100: Query is malformed or invalid study access account selected.
Click on OK
166100: Query is malformed or invalid study access account selected.
Click on OK
Attempt to create view GENERIC_DATA returned error:
ORA-00904: “NULLC33”: invalid identifier
ORA-00904: “NULLC33”: invalid identifier
Steps to reproduce:
- Definition
- Data Extract View Builder
- View Definitions
- F8 to Select View
- View Data button
- Errors messages occur
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 |
References |