CMN_DATE_TIME_DIFF_FCT Errors

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

There are a couple of scenarios where you may encounter ORA-01858: a non-numeric character was found where a numeric was expected
ORA-06512: at "NIKUP.CMN_DATE_TIME_DIFF_FCT", line 16

Scenario 1 can happen when trying to assign tasks:

You will see

"System error. Contact system administrator"  in the UI. 

In logs errors seen:

Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01858: a non-numeric character was found where a numeric was expected

ORA-06512: at "NIKUP.CMN_DATE_TIME_DIFF_FCT", line 16

ServiceHandler.postProcess failed.
com.niku.union.odf.exception.ODFValidationException: System error. Contact system administrator.

Second scenario is when querying the odf_project_v2 view.

This can happen in the schedule finish is any day in February 2030 or February 2031.  Oracle databases only.

Environment

Release : 15.9.1, 15.9.2, 15.9.3, 16.0.0, 16.0.1 

Component : CA PPM PROJECT MANAGEMENT

Cause

DE64445 (oracle only) 

Problem was caused by incorrect ETC values. The values were corrected, and the problem was resolved.

Change the finish date to anything other than February.

 

  

Resolution

Resolved in 16.0.2