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

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