ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Project Properties giving Error 500 - Internal Server Error

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.

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?

Cause

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

Environment

Release : 15.6

Component : CA PPM PROJECT MANAGEMENT

Resolution

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;

https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/15-6/installing-and-upgrading/install-clarity-ppm.html#concept.dita_c5fddf2f732699e579d4affe4d72b1178454ee97_ConfigureaPPMDatabasewithOracle