ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Timesheet browsing error: "Error 500 System Error..."

book

Article ID: 49496

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

When you attempt to click on Timesheets, you see an error message in the application.

Error 500 System Error. Contact System Administrator

The application log file shows the following error message. 

ERROR 2012-06-23 16:30:54,745 [http-80-3] niku.xql2 (myuser:34640783__AD78278E-B987-45E4-B722-7394B2596B9E:timeadmin.timesheetBrowser)
Exception in processing java.lang.RuntimeException: com.niku.union.persistence.PersistenceException:
SQL error code: 1861
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01861: literal does not match format string

Cause

This error message indicates an issue with interpreting dates in the query that returns the data requested.

Environment

Release: Any

Resolution

Verify that the 'init.ora' file in the Clarity database has the proper setting for NLS_DATE_FORMAT parameter.

If the setting is not correct:

  1. Update the setting to the proper format
  2. Restart services
  3. Access the Timesheets.