Resource allocation segments do not save as expected. The value multiplies by 10 when saving it
Article ID: 103051
CLARITY PPM FOR ITGCLARITY PPM FEDERALClarity PPM SaaSClarity 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.