Clarity: Timesheet Browsing Error 500


Article ID: 49496


Updated On:


CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS Clarity PPM On Premise



When we attempt to access Timesheets, we see an error message in the application.

Error 500 System Error. Contact System Administrator

The application log file shows the following error message. What is causing the error?

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


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

Check and 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, update the setting to the proper format, restart services and access the Timesheets.

For more details on the correct configuration settings, reference Clarity Installation Documentation for the appropriate version. This documentation can be found in the Clarity Bookshelf.

Keywords: CLARITYKB, how-to, configuration.


Release: ESPCLA99000-12.1-Clarity-Extended Support Plus