Query Cases By Events On Dictionary Search Term Throws ORA-00600
(Doc ID 301413.1)
Last updated on FEBRUARY 03, 2019
Applies to:
Adverse Event Reporting System - Version: 4.5.1Information in this document applies to any platform.
***Checked for relevance on 05-JUL-2010***
Symptoms
You query a term in the Dictionary Search Term field in the Events Query Window on the Case Query screen.
The following error appears in a pop-up window:
ORA-00600: internal error code, arguments: [kkxpityp1], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SYS_SQL", line 826
ORA-06512: at "SYS.DBMS_SQL", line 39
ORA-06512: at "ENSITE.POPULATEQTEMP"
This error occurs also in the Product Query Window on the Case Query screen when querying the Product or Product Type field.
Steps:
1. Connect as SUPERUSER or another appropriate user.
2. Select Cases -> Query Cases
3. In the Query Window field select 'Events' from the drop down list.
4. Enter “DIABETES MELLITUS EXACERBATED” on Dictionary Search Term field.
5. Select Actions -> Retrieve Cases
6. Observe ORA-600 error in pop-up window.
7. Observe no data is retrieved after error acknowledgement.
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! |