Idea Attribute Cost Estimate Incorrect Representation In SQL Server Database

Products

• Clarity PPM On Premise

Issue/Introduction

The value for the Idea attribute 'Cost Estimate' is incorrectly represented at the database level.
The value is not be stored correctly at the database level.

STEPS TO REPRODUCE:

1. Review the Idea attribute 'Cost Estimate'
id= est_cost

2. Go to an idea instance and populate the field.

3. Review the field with the following query:

Test with Clarity account settings > Language=English

Expected: The value should be represented at the database level correctly in order to display
correctly in the UI.

Actual:
The UI reflects what is incorrectly stored at the database level.

If language= English, then the value is rounded up.
Example: When entering 1234.50,  the value displayed is 1235

If language=Brazilian Portuguese, then the 
whole value and the fractional parts are concatenated.
Example: When entering 1234.50, the value is stored as 123450

Environment

Clarity 16.2.2

Cause

DE165899 

Resolution

Resolved in 16.3.2.

Workaround: Have the DBA perform the following:

1. Run statement: ALTER TABLE exampledb.niku.INV_IDEAS ALTER COLUMN EST_COST numeric(18,2) NULL;
2. Save it.