search cancel

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


Article ID: 103051


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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?


This happens on MS SQL databases


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.