IBM BPM, V8.0.1, All platforms > Troubleshooting and support > Troubleshooting installation and configuration
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.
