TIBCO Spotfire Server: "Could not create constraint or index." when creating Spotfire database.

The following error may be seen during a spotfire server installation, when creating a new spotfire database on SQL Server via the create_databases.(sh|bat)script.

Changed database context to 'master'.

Changed database context to 'spotfire_server'.

Msg 1911, Level 16, State 1, Server MYSQLSERVER\SPOTFIRE_DATABASE, Line 4

Column name 'activity_id' does not exist in the target table or view.

Msg 1750, Level 16, State 1, Server MYSQLSERVER\SPOTFIRE_DATABASE, Line 4

Could not create constraint or index. See previous errors

The reason for this error could be that the SQL server is using a case-sensitive collation by default. Check your SQL server for more information.



If this is the case a different collation needs to be used. Locate the following lines in the create_server_db.sql script.

Uncomment (remove leading dashses) the line that defines the collation in the create database statement, and comment out the line that uses create database without specifying collation. A different collation can be used, but it must be case-insensitive.

Save these changes and rerun the create_databases.(bat|sh) script. The script should now run without error.