Project Properties giving Error 500 and ORA-01858: a non-numeric character was found where a numeric was expected
search cancel

Project Properties giving Error 500 and ORA-01858: a non-numeric character was found where a numeric was expected

book

Article ID: 212655

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

When attempting to update project finish date on any project we are getting error 500.

We could not save projects finish date with any dates greater then year 2031, so 2031 is saving, but 2032 is throwing an error.

ERROR Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.

The issue with all users.

Error in logs:

ERROR 2021-04-01 18:20:04,824 [http-nio-8080-exec-19] niku.xql2 (clarity:admin:48489074__63EDD066-FB03-4A04-9CA6-BB9F8EA57063:projmgr.projectProperties) Internal Processing exception
java.lang.Exception: Invalid expression qobj: com.niku.union.persistence.PersistenceException: 
SQL error code: 1858
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01858: a non-numeric character was found where a numeric was expected
ORA-06512: at "NIKU.CMN_DATE_TIME_DIFF_FCT", line 16

Cause

NLS Format not correctly set in Oracle

Resolution

Check with the DBA to make sure they set the NLS Date Format correctly:

alter system set nls_date_format = 'YYYY-MM-DD HH24:MI:SS' scope=spfile;

For more information check:  Clarity PPM - Check and set NLS_DATE_FORMAT