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.
I have cheeked the last updated by column and it is 1, I also tried to login as multiple users and issue with all users.
Does anybody know what could be the reason?
ERROR 2021-04-01 18:20:04,824 [http-nio-8080-exec-19] niku.xql2 (clarity:joe_bizadmin: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
Release : 15.6
Component : CA PPM PROJECT MANAGEMENT
DBAs changed parameter setting in Azure DB to fix the Project Finish date issue.
alter system set nls_date_format = 'YYYY-MM-DD HH24:MI:SS' scope=spfile;