Document toolboxDocument toolbox

SQLite mode (SpinFire Publish 8.6.2+)

Owned by Dan Tomosoiu
Last updated: Thu Dec 19, 2024
3 min read

Starting with SpinFire Publish (CAD Publisher) 8.6.2, customers can now use an embedded SQLite database instead of ArangoDB.

This is called SQLite mode.

SQLite mode makes it easier to install or update SpinFire Publish as there is no need to deploy ArangoDB.

This feature is in beta. Once out of beta, SpinFire Publish will exclusively use SQLite.

Migrating an existing installation

An existing installation of SpinFire Publish (CAD Publisher) based on ArangoDB must be migrated before it can use SQLite mode. This is a one-time operation done by running a migration program called CadPublisherArangoMigrator.exe.

The program connects to ArangoDB using the same network settings as Centro Web App.

It turns off the applications, deploys the ArangoDB database, migrates its content to an SQLite database and sets a system environment variable CAD_PUBLISHER_SQLITE=true to toggle SQLite mode on.

Follow the steps below to perform the migration:

  1. Create a backup of the ArangoDB database.

  2. Download and extract the ZIP file CadPublisherArangoMigrator.zip

  3. Download C7-deploy-8.7.x.x.zip and place it next to CadPublisherArangoMigrator.exe.
    You don’t need to extract the zip file, the migration program will do it automatically.

    image-20241129-170727.png

  4. If you have installed Centro Web App in a different folder than the default C:\inetpub\wwwroot\Centro, open CadPublisherArangoMigrator.exe.config and update CentroConfigPath setting with the correct value.

  5. Open an administrator Command Prompt in the folder that contains CadPublisherArangoMigrator.exe.

    image-20241129-171006.png

  6. Run CadPublisherArangoMigrator.exe from the command prompt.

  7. Enter the password for ArangoDB root user and press Enter.

  8. Wait for the migration to complete. If successful, you will see Migration Successful!.
    If an error occurs, refer to the troubleshooting section below.

  9. (Optional) Uninstall ArangoDB.

  10. Restart the machine. This is required to make sure that the environment variable will take effect everywhere (e.g. in IIS).

  11. Upgrade Centro Web App

    1. Run the installer. When prompted for ArangoDB credentials, enter dummy values.

    2. Start CentroPool in IIS

    3. Navigate to your Centro instance to make sure it is running correctly

  12. Upgrade and start the Pipeline services

New installation

  1. Set CAD_PUBLISHER_SQLITE=true as system environment variable

  2. Install Centro Web App

    1. When prompted for ArangoDB credentials, enter dummy values.

    2. Navigate to your Centro instance to make sure it is running correctly

  3. Install the Pipeline services

Troubleshooting

Failed to deploy database

  • Check the log files for more information: CentroWebApp00.log and deploy_log_<appVersion>_<dd-MM-yyyy-HHmmss>.txt

  • Make sure that the IIS application pool (usually CentroPool) has write access to the folder that contains the database file: <ProgramDataRoot>\Centro7\. The default is C:\ProgramData\Actify\Centro7\.

Attempt to write a readonly database

  • Make sure that the IIS application pool (usually CentroPool) has write access to the folder that contains the database file: <ProgramDataRoot>\Centro7\. The default is C:\ProgramData\Actify\Centro7\.

HTTP Error 500.0 - Internal Server Error

  • Ensure that the the IIS application pool CentroPool is started.