ERES Evidence Store: Cannot Query Custom Event: Internal Server Error (Doc ID 2043603.1)

Last updated on AUGUST 12, 2015

Applies to:

Oracle E-Records - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On Application Release 12.0.6, under ERES Administrator - Evidence Store page:

ACTUAL BEHAVIOR
-----------------------
Query by Event name and date takes 7+ minutes and generates internal server error.

-- What is working --
* Can query the same event by E-record id or signer name without issue. This only happens querying by date.
* The same SQL query for events by date runs in 2 seconds directly via SQL.

ERROR
-----------------------
Internal Server Error

STEPS
-----------------------
1. Navigate to ERES Administrator > Evidence Store page
2. Query for event XBOL E-VERIFICATION EVENT, From/To: 27-Aug-2013 / 29-Aug-2013
3. The page gives an internal server error after 7 minutes.



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