Query Cases By Events On Dictionary Search Term Throws ORA-00600 (Doc ID 301413.1)

Last updated on JULY 05, 2010

Applies to:

Adverse Event Reporting System - Version: 4.5.1 and later   [Release: 4.5 and later ]
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms