DevTest Portal Doesn't Save Preferences

Document ID : KB000101579
Last Modified Date : 14/06/2018
Show Technical Document Details
Issue:
When using the portal, it is not possible to save configuration preferences - when next logging in the preferences are no longer set 

In the portal log, entries similar to the following can be found 

2018-05-14 06:53:57,359Z (09:53) [qtp832196726-109] ERROR com.itko.lisa.invoke.resource.PreferenceResource - Invalid column name 'user_unique_id'. 
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'user_unique_id'. 

Using an SQL client, it is noted that the column USER_UNIQUE_ID  is present in tables ACLUSERS and ACL_AUDIT_LOG.
Environment:
DevTest using SQL Server
Cause:
SQL server, by default, has case-independent name comparison - this may be overridden by using a non-default collation sequence 
Resolution:
Use collation sequence sql_latin1_general_cp1_ci_ai in order to resolve this issue