Tuesday, November 17, 2009

Trying to Schedule Query gives message "An error has occurred" and kicks the user back to an Error page.

image

I have noticed the following issue on PeopleTools 8.48.16.

  1. Go to Reporting Tools -> Query -> Schedule Query -> Add a new Value –> TEST
  2. Enter the query name : ERROR_QUERY and tab out of the field.
  3. This displays the run time prompt page. Enter the value and hit OK or CANCEL
  4. Page shows flashing Processing image and displays the page "An error has occurred" eventually. Appserver log shows that a core file is generated.

 

FIX

To fix the issue, open the query in Query Manager from PIA. Change the query properties –> Description and resave the query. This fixes the issue.