Virtual Appliance version 14.1
External Database: MS SQL 2014
XA transaction is enabled and Workpoint DB user has sufficient permission and roles to manipulate the DB. However, the Vapp startup does not seem to be able to create tables, populate rows and stored procedures properly. There are a few Workpoint stored procedures and rows in table WP_INI missing in Workpoint database. The cause of the problem is due to the DB collation is configured incorrectly as Latin1_General_CS_AI
Identity Governance Guide R14.1 stated:
* WPDS (Workpoint)—case-insensitive
* Data Warehouse—case-sensitive
Dropping and re-creating the Workpoint DB with Latin1_General_CI_AI fixes the issue.
Important note: Depending on business requirement about how data should be sorted and compared, the DB Collation might need to be configured differently to accommodate that.
The default collation when a standalone IG installation creates the Workpoint database automatically is: SQL_Latin1_General_CP1250_CI_AS