My Oracle Support Banner

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.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

To view full details, 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 a vibrant support community of peers and Oracle experts.