Versions Compared

Version Old Version 1 New Version Current
Changes made by

Mark Anderson

Allen Hardy

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

ArangoDB Upgrade

The following outlines the steps to upgrade from your current ArangoDB version to another and then to upgrade CAD Publisher itself. to a newer version.

We would always strongly recommend backing up your VM/Server prior to following these steps. These steps should take approximately 20-50 minutes to complete.

...

.


Please note these screenshots are for illustration purposes only.

1.Check ArangoDB version installed by opening Command Prompt

On your Windows server that contains ArangoDB, in a command prompt, type

arangosh

Enter the root password .

...

and then check the version (highlighted in yellow below)

...

Or from the browser GUI, the login page identifies this.

...

2. Or from the browser GUI, the login page identifies this.log into ArangoDB and check the version bottom left of the user interface.

image-20240305-102127.pngImage Added

2. Shut down the Centro Web App in the IIS

...

This is to prevent any addtional changes to the database by shutting down Centro. First start wth the web app.

  1. Notify your user base on downtime.

  2. Make sure there are no files being processed in the Centro Pipeline Manager.

  3. Bring up IIS Manager on your web server.

  4. Click Stop on the right side.

...

3. Stop the Pipeline Host service

Stop and disable the Pipeline Host service to prevent it from restarting on its own.

  1. Bring up Services.

  2. Double click on Centro | Pipeline Host.

  3. Click Stop.

  4. Set the Startup type to Disabled.

  5. Click OK.

...

4. Stop the Pipeline Manager service

Stop and disable the Centro Pipeline Manager service to prevent it from restarting on its own.

  1. Again bring up Services.

  2. Double click on Centro | Pipeline Manager.

  3. Click Stop.

  4. Set the Startup type to Disabled.

  5. Click OK.

5. Back up the database

  1. Open a command prompt.

  2. Navigate to an approprate folder that holds Arangodump.exe (i.e C:\Program Files\ArangoDB3e 3.x.x/usr/bin). If there are more versions under “C:\Program Files\”, it will be the latest version, this can be double checked by logging into your ArangoDB Website)

  3. On the command line, use the arangodump command.
    Usage:
    arangodump --server.database [database name] --output.directory “[dir name]”

    Notes:
    * The default Centro database name is ActifyDB.
    * The directory the files are exported to does not have to exist beforehand.
    * A valid ArangoDB root password is needed for this step.

    Add --overwrite true if you rerun the command and want to overwrite the existing files.

...

At the time of this writing there are 75 collections dumped.

...

6. Store a copy

In case of a catastrophic failure, save a copy of the back up folder/files on a separate system or drive.

Make sure the separate system is secure and conforms to your organizations security protocols.

7. Stop arangodb3

Stop the ArangoDB service.

  1. Again bring up Services.

  2. Double click on ArangoDB.

  3. Click Stop.

  4. Click OK.

...

8. Save backup of the Arangod.conf file

  1. Go to the c:\Progam Files\ArangoDB 3.8.x\etc folder.

  2. Find and save Save the arangod.conf file to another directory/hard drive that can be used as a backup in case the original is lost or corrupted.

9.

...

A Method A (ArangDB Upgrade)

This is the recommended approach. Install the consecutive versions of ArangoDB until you are on the latest Actify Supported version for your version of CAD Publisher (ArangoDB Compatibility Chart).

If your version of CAD Publisher supports up to ArangoDB 3.8 11.x you can follow use the example given below:

...

Example:

  • Upgrading from ArangoDB 3.6.8 to ArangoDB 3.7.18

  • Then

    Upgrading

    upgrading from ArangoDB 3.7.18 to ArangoDB 3.8.9

  • Then upgrading from ArangoDB 3.8.9 to ArangoDB 3.9.9

  • Then upgrading from ArangoDB 3.9.9 to ArangoDB 3.10.13

  • And finally, upgrade from ArangoDB 3.10.13 to ArangoDB 3.11.9

  • Upgrading from

    Note - Upgrading that skips major versions, such as 3.6.x to 3.

    8 directly

    10.x is not officially supported. The officially supported upgrade path

    in this case is 3.6 to 3.7, and then 3.7 to 3.8.

...

  • is the example given above.

  • Note - Once you have finished upgrading to the latest ArangoDB, ensure you can log into the ArangoDB System as well as the ActifyDB using credentials before proceeding with the deploy script to update the ActifyDB.

In the above example, you would need the following:

  • ArangoDB3-3.7.18_win64.exe

  • ArangoDB3-3.8.9_win64.exe

  • ArangoDB3-3.9.9_win64.exe

  • ArangoDB3-3.10.13_win64.exe

  • ArangoDB3-3.11.9_win64.exe

We would strongly recommend reaching out to the SpinFire Technical Support Team for the appropriate versions to use for this method by reaching out to them at centrosupport@actify spinfiresupport@techsofted.com or https://support.actifyspinfire.techsoft3d.com.

  • Once

...

9.b Method B (ArangDB Upgrade)

  • the ArangoDB version is updated, do the following steps to update the ActifyDB:

    • Unzip the Centro.zip

    • Open the unzipped folder and Extract the the C7-deploy-8.x.0woxxxx.xxxx.zip file. Which will show you the content shown below:

      (Note - This image is for illustrative purposes only)

      image-20240626-105847.pngImage Added

    • In the Power Shell (Or Command Prompt while running it as Admin), navigate to the deploy folder you have just unzipped.

      image-20240626-105926.pngImage Added

    • Run the Setup.bat file via PowerShell or CMD as Admin (NOTE - Do not double click or try to right click and run as admin, this will not work, it must be executed within Command prompt or Powershell.

    • Follow the instructions below:

      Opens image in full screenOpen

      Image Added

    • Press Enter for “What Database Name should be used? (Do not change it)

    • Press Enter for “What username should be used for the generated database user account?” (Do not change it)

    • Type n for “If the generated user already exists, would you like to generate a new password?” and press Enter.

    • You will not see any error messages, meaning the ActifyDB upgrade has been successfull.

9.B Method B (ArangDB Upgrade)

This is the original method that was used to upgrade your ArangoDB to the latest version. It is not officially recommended to use this approach anymore, the officially supported approach recommended by ArangoDB is to install consecutive versions of ArangoDB as per 9.A instructions.

First, Uninstall Arangodb

  1. Open Programs and Features.

  2. Select ArangoDB3e 3.x.x in the list.

  3. Click Uninstall/Change.

...

4. Follow the uninstall wizard.

5. When asked do not delete ArangoDB user elements. Leave it unticked.

...

10. Install Arangodb Community

...

Edition

  1. Download ArangoDB Community version 3.9x.x for Windows from ArangoDB. Get the .exe installation for easy installation.
    (https://www.arangodb.com/download/ . (Actify can provide you the download links)

  2. Double-click on the ArangoDB installation and follow the wizard instructions.

...

  1. (Note - Do not change the ticked/unticked boxes shown below, leave as default)

    Image Added

...

3. Once complete, stop the ArangoDB service in Services if it has started.

...

  1. If you utilize an encrypted link (SSL) between the database and Centro make those adjustments.

  2. Restart the ArangoDB service in Services,

11. Restore the database

On Windows, the database should still be intact. However, if you find that the database and the data is not there then restore the database through the following steps.

...

Code Block
arangorestore --server.database ActifyDB --input-directory “dump”

12. Start the Centro Web App

  1. Bring up IIS Manager on your web server.

  2. Click Start on the right side.

13. Start the Pipeline Host service

To start up the Pipeline Host service.

  1. Bring up Services.

  2. Double click on Centro | Pipeline Host.

  3. Set the Startup type to Automatic.

  4. Click Apply.

  5. Click Start.

  6. Click OK.

14. Start the Pipeline Manager service

To start up the Pipeline Manager service.

  1. Bring up Services.

  2. Double click on Centro | Pipeline Manager.

  3. Set the Startup type to Automatic.

  4. Click Apply.

  5. Click Start.

  6. Click OK.

15. Test for completion

Verify your update and data restore worked by conducting the following simple tests.

  • Verify the database is a Community version and is 3.9.x.
    To do this login to the web GUI.

...

  • If you are NOT updating your CAD Publisher software. Proceed back to Step 3 and 4 to change the startup types for those services back to “Automatic” for the Pipeline Host and Pipeline Manager, as shown below.

...

  • Login to the CAD Publisher .
    website to ensure it still loads with no errors. Logging into CAD Publisher validates the database is still accessible after the upgrades.

  • Read from database.
    Navgate to a Catalog part in CAD Publisher.

  • Write to the database.
    Conduct a pipeline file conversion . A success here indicates CAD Publisher can write to the database and pipelines are functioning.

  • Check security and accessiblity.
    If there are additional securty or penetraton checks on the ArangoDB web GUI or other “entry points” based on your organization’s security policy do so.

  • ArangoDB upgrade procedure has now been completed!

16. Next, Upgrading the CAD Publisher Software