Spotfire: Manually updating the Action Log Database to v14 when separated from main Spotfire database

Description:

In some Spotfire installations, the Action Log database may be located on a different server or use a different database management system than the main Spotfire database. In these cases, the Action Log database schema may not automatically update during a Spotfire version upgrade.

The following message might be observed:

If you want to use the upgraded (action log) views and an upgraded information model, new views must be created and an updated information model must be imported.

Solution:

1. Backup the existing Action Log database as a precautionary measure.
2. Download the Spotfire server installation package for the new version (e.g., SPOT_sfire_server_14.0.6_win.zip).
3. Extract the package and navigate to the scripts directory for the Action Log (e.g., ..\14.0.6\SPOT_sfire_server_14.0.6_win\scripts\mssql_install\actionlog).
4. Choose either of the following methods to update the database:
   a. Run the create_actionlog_db.bat file, but comment out or remove the section that creates the database user.
   b. Execute the create_actionlog_db.sql script SQL statements directly. Comment out or remove the line that creates the database, but leave the rest of the script intact.
5. After running the script, verify that the Action Log database schema has been updated to match the new Spotfire version.

Instructions are documented in the Spotfire Installation and Administration Guide, at the below link. However, it may not be obvious that the scenario described here in this article is a time to use it. Online documentation: https://docs.tibco.com/pub/spotfire_server/latest/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/updating_the_microsoft_sql_server_database.html