Error running bootstrap command or creating profiles with SQL Server databases
If you are using Microsoft SQL Server databases, and you create the BPMDB or PDWDB databases with a case-sensitive collation attribute, then when you use the bootstrapProcessServerData command to load the databases with configuration data, you will get an error. If you are using PMT or manageProfiles create the profile, the profile will be created with partial success, and the profile log file will indicate failure running bootstrapProcessServer.ant.
When you create SQL Server databases
for Process Server (BPMDB) and Performance Data Warehouse (PDWDB),
they must not be case-sensitive. The COLLATE attribute
value must indicate case-insensitivity by using CI rather
than CS:
osql -b -S hostname -U db_user_account -P db_user_password
-Q "CREATE DATABASE database_name COLLATE SQL_Latin1_General_CP1_CI_AS"
If
you get log errors and partial profile creation success, or failure
when using bootstrapProcessServerData, check the
creation commands for your databases. If they have COLLATE attribute
values such as SQL_Latin1_General_CP1_CS_AS, change
the CS (indicates case-sensitive) to CI (not
case-sensitive), as in SQL_Latin1_General_CP1_CI_AS.