Is database collation 'Latin1_General_CI_AS' supported with CA PAM

Article Id: 106118
Status: Published
Updated On: 11-07-2018 20:49
Products:
CA IT PROCESS AUTOMATION MANAGER , CA Process Automation Base
Issue/Introduction:



Our CA PAM v4.3.2 is running on MS SQL database collation "SQL_Latin1_General_CP1_CI_AS."

Is database collation "Latin1_General_CI_AS" supported?

Environment:

Release: ITPASA99000-4.3-Process Automation-Add On License for-CA Server Automation
Component:

Resolution:

No. From the documentation the database collation MUST remain as it is to be certifed: 

"SQL Server collation must be SQL_Latin1_General_CP1_CI_AS for databases that contain the CA Process Automation data stores." 

https://docops.ca.com/ca-process-automation/4-3/en/installing/prerequisites/database-prerequisites/prepare-a-microsoft-sql-server-database