Is database collation 'Latin1_General_CI_AS' supported with CA PAM

book

Article ID: 106118

calendar_today

Updated On:

Products

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