Pasting special character to Financial Plan TSV Corrupts the Plan

Products

• Clarity PPM SaaS

Issue/Introduction

STEPS TO REPRODUCE: 
1. Login to Clarity.
2. Navigate to New UX.
3. Open a Project.
4. Navigate to Financials Module.
5. Select Benefit Plans.
6. Create a new Benefit Plan Test1 with ID test1.
7. Click on the newly created Benefit Plan.
8. Add Benefit Plan Detail row. Select a Benefit Class, Benefit Subclass and Description.
9. Open Excel and type Text, 2000, 20000 values in three columns. Copy the 3 values.
10. On the benefit plan detail row select 3 periods and paste the data using Ctrl + V. 

Expected Results :- Application Shouldn't accept Text values.
Actual Results :- Application stores the provided text (or) special characters to the database.

Environment

Release : 15.8.1,15.9

Component : CA PPM SAAS APPLICATION

Cause

This is Caused by Defect DE58695

Resolution

This issue is fixed in Clarity 15.9.1.

There may be instances will the plan is still corrput.

The app-ca logs will show the error.

However, check the bg-ca logs for the time slicing job.

Additional Information

Log files show the following error:

java.lang.NumberFormatException: Character � is neither a decimal digit number, decimal point, nor "e" notation exponential mark.
 at java.base/java.math.BigDecimal.<init>(BigDecimal.java:518)
 at java.base/java.math.BigDecimal.<init>(BigDecimal.java:401)
 at java.base/java.math.BigDecimal.<init>(BigDecimal.java:834)
 at com.niku.odf.object.Utils.toObject(Utils.java:365)
 at com.niku.odf.object.ObjectInstanceImpl.transform(ObjectInstanceImpl.java:1082)
 at com.niku.odf.object.ObjectInstanceImpl.create(ObjectInstanceImpl.java:859)
 at com.niku.odf.object.ObjectInstanceImpl.create(ObjectInstanceImpl.java:837)
 at com.niku.odf.object.ODFAbstractObjectImpl.readInstance(ODFAbstractObjectImpl.java:2848)

 

bg-ca logs will show Error with the Time Slicing job where some of the segments show NaN

example:

total_units_actual=7.0, odf_nk_units_variance=com.niku.xmlserver.blob.FiscalCurve{ 2021-10-05T00:00:00-2021-10-06T00:00:[email protected](-1.0) 2021-10-12T00:00:00-2021-10-13T00:00:[email protected](-1.0) 2021-10-18T00:00:00-2021-10-19T00:00:[email protected](-1.0) 2021-10-22T00:00:00-2021-10-23T00:00:[email protected](-1.0) 2021-11-01T00:00:00-2021-11-02T00:00:[email protected](NaN) 2021-11-02T00:00:00-2021-11-03T00:00:[email protected](NaN) 2021-11-03T00:00:00-2021-11-09T00:00:[email protected](NaN)