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.

CMN_DATE_TIME_DIFF_FCT Errors

book

Article ID: 208580

calendar_today

Updated On:

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.

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.

 

  

Environment

Release : 15.9.1, 15.9.2, 15.9.3, 16.0.0, 16.0.1 

Component : CA PPM PROJECT MANAGEMENT

Resolution

Resolved in 16.0.2