Migrating to SQLite mode (SpinFire Publish 2025.2.0+)

Starting with SpinFire Publish 2025.2.0, customers MUST now use an embedded SQLite database instead of ArangoDB, as ArangoDB is no longer supported.

This is called SQLite mode.

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

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 and migrates its content to an SQLite database.

Follow the steps below BEFORE installing the new version of SpinFire Publish 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-2025.1.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.

    Migration tool screenshot

  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.

    Command prompt screenshot

  6. Run CadPublisherArangoMigrator.exe from the command prompt.

    Running migration tool

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

    Entering ArangoDB password

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

    Migration successful

  9. (Optional) Turn off or uninstall the ArangoDB service.

  10. Run SpinFirePublish.exe and follow the installation steps.

  11. Navigate to your SpinFire Publish instance to make sure it is running correctly.

    Note

    You may need to re-set the Log On As credentials for the Centro Pipeline Service (now replacing Pipeline Host and Pipeline Manager).

New installation

For a new installation of SpinFire Publish 2025.2.0 or later, simply run SpinFirePublish.exe and follow the installation steps.

Troubleshooting

Failed to deploy database

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>. The default is C:\ProgramData\SpinFire\SpinFire Publish\.

Attempt to write a readonly database

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>. The default is C:\ProgramData\SpinFire\SpinFire Publish\.

HTTP Error 500.0 - Internal Server Error

HTTP Error 500.0

  • Ensure that the IIS application pool CentroPool is started.