An error message "CostPlanDetail persistence failed" occurs when a cost plan is created using the 'New From Resource' button
Steps to Reproduce:
- Set default currency for instance to USD and billing currency to a different currency
- Go the 'Financial Plan' tab
- Create a Cost Plan "From a Resource Plan"
Expected Result: Cost Plan created
Actual Result: Error reported: "CostPlanDetail persistence failed"
When a SQL Trace is run, it will show that the total_billing_cost column is being set to a non-numeric value in FIN_COST_PLAN_DETAILS.
update FIN_COST_PLAN_DETAILS set billing_cost = ?, total_billing_cost= ?, last_updated_date = ?, last_updated_by = ? where id = ? NDE:CONN@4ba04ba0: prepareStatement(string) NDE:PSTM@78657865: setBinaryStream(): 1, java.io.ByteArrayInputStream@15d015d0 NDE:PSTM@78657865: setObject(): 2, NaN NDE:PSTM@78657865: setObject(): 3, 2010-07-28 16:09:27.462 NDE:PSTM@78657865: setInt(): 4, 5030402 NDE:PSTM@78657865: setLong(): 5, 5427599 NDE:PSTM@78657865: execute() NDE:PSTM@78657865: FAIL: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01722: invalid number
When this condition occurs, this usually is attributed to time segments that have an allocation % set to infinity (ascii code 236). To find this:
- Go To Project -> Team Staff List View
- Click the Properties icon to the left of the resource
- Check if the infinity symbol appears in any of the fields
The above needs to be repeated for each resource or role.
The infinity value is caused by allocation ending on a non-working date from the clarity calendar.
For more information on other symptoms of the infinity value in an allocation segment, refer to the following articles:
TEC530210: Clarity: Infinity data value on Allocation Segments - java internal processing exception : NumberFormatException.
TEC530418: Clarity: Booking Status Portlet Error when attempting to Export to Excel.
Resolved in Clarity 12.0.2.
Keywords: CLARITYKB, CLRT-27754, clarity12resolved, clarity1202resolved.