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

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

Environment

Release: Any

Cause

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

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. Click on Timesheets
Powered by Wolken Software