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

Document ID : KB000103051
Last Modified Date : 22/06/2018
Show Technical Document Details
Question:
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
Answer:
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.