Product: TIBCO Spotfire®
Administrator UI showing incorrect Node Manager Service Status
While creating a Node Manager Service(Web Player/Automation), the "Status information" under "Nodes & Services" might show the following warning.
=====
"Status notified as STARTING. Attempt to communicate with service was unsuccessful"
=====
The timestamp on this warning might be the time when the service was first created. Even if the service is stopped or restarted, it might still show the same warning with the same timestamp and might never disappear. However, the service(Web Player/Automation) runs fine.
This issue can be seen if the SQL Server is running with Case Sensitive collation. Spotfire requires atleast the Spotfire database to be setup as Case Insensitive. This can be checked by right clicking on the database and checking the "Properties". Here, under "General", there is a section called "Collation". If this is set to "SQL_Latin1_General_CP1_CS_AS", it means the database was set as case sensitive. If it is set to "SQL_Latin1_General_CP1_CI_AS", it means the database was set as case insensitive.
If the database was set as Case Sensitive, it can not be changed after the database has already been set up. Here, the only way to resolve this issue is by performing the following steps.
=====
- Take a backup of the current database
- Export the configuration
- Export the library content
- Drop this database
- Recreate a new database. Make sure to first specify case-insensitivity for the Spotfire database as per the steps below, if the SQL Server uses a case-sensitive collation by default.
- On the SQL Server computer, open the mssql_install directory, and then open the create_server_db.sql script in a text editor.
- Locate the line --create database $ (SERVERDB_NAME) collate Latin1_General_CI_AS;
- Remove the leading dashes (--).
- Replace the case-insensitive (CI) collation Latin1_General_CI_AS with the name of another CI collation. See the SQL Server documentation for information about available collations.
- Comment out the following line by inserting leading dashes (--), so that the line looks like this: --create database $(SERVERDB_NAME)
- Save the file and close the text editor.
- Once the database creation steps are complete, import the server configuration
- Recreate the bootstrap
- Import the library content
=====