Resource allocation segments do not save as expected. The value multiplies by 10 when saving it

book

Article ID: 103051

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction



After adding a resource in the team, the resource gets a default allocation of a 1000% 
If you are entering a 50% allocation segment, after saving the value changes to 500% 
This is only reproducible on specific environments. What could be the cause?

Environment

This happens on MS SQL databases

Resolution

Run the following command at the database

SELECT serverproperty('collation') as collation 

This will show the server collation.
If you have it different from SQL_Latin1_General_CP1_CI_AS, you will have to change the server as we do not support mixed collations.