CONCEPT: Manually Updating the RockSolid Software

The RockSolid software can be updated in one of two ways.  For a full software general release an application installer will be available.  Running the application installer will take you through the update process and will automatically update relevant components.  A partial or hot-fix release may on the other hand require a manual update.  This article describes the manual update process.

To update your RockSolid software manually a .ZIP file containing the components to be updated will be provided by RockSolid SQL.  The contents of this .ZIP file will indicate the components that require updating, namely the file many contain:

  • /RockSolidDBUpdate.sql - A SQL Server script file to be executed against the RockSolid repository instance.  This updates the RockSolid DataImport, RockSolid, RockSolidPerformance and RockSolidHistory databases.
  • /RockSolidAgent - Executable files to update the RockSolidAgent service
  • /RockSolidAnalysisAgent - Executable files to update the RockSolidAnalysisAgent service
  • /RockSolidServerAgent - Executable files to update the RockSolidServerAgent service
  • /RockSolidNotificationAgent - Executable files to update the RockSolidNotificationAgent service
  • /RockSolidWeb - Files to update the RockSolid web application files
  • /RockSolidWebService - Files to update the RockSolid web service files
  • /RockSolidReports - Files to update the RockSolidReports reporting services deployment

NOTE: Not all releases will contain all files.

Environment Preparation

Before you get started you need to ensure you have a good understanding of the architecture of your RockSolid deployment.  The RockSolid software enjoys a scale-out deployment model where many servers may be running multiple copies of the components listed above.  Please ensure you keep good documentation as to the deployment architecture to aid when deploying updates.

Starting the Update Process

Before you start the deployment process please ensure you stop the following services on all hosts:

  • RockSolidAgent (typically multiple on multuple hosts, often on different networks)
  • RockSolidAnalysisAgent (typically one + dr)
  • RockSolidServerAgent (typically multiple on multiple hosts + dr)
  • RockSolidNotificationAgent (typically one + dr)

RockSolidDBUpdate.sql

To run the RockSolid database update, connect to the central RockSolid repository server using SQL Server Management Studio,  Ensure you have good backups of the following databases:

  • DataImport
  • RockSolid
  • RockSolidPerformance
  • RockSolidHistory

Once you are sure you have good backups you can start the update process.  To do this open the RockSolidDBUpdate.sql file with a connection to the central repository and execute the script.  On occasion warnings and/or errors may be displayed.  Typically these are safe to ignore as the script is designed to recover from such issues, however please save any output and discuss with your RockSolid support consultant if you are unsure.

If you are prompted to remove carriage returns or unicode characters when opening the script, click NO to not allow SSMS to do this.

NOTE: The script may take a long time to run 30+ minutes is not uncommon.

RockSolidAgent

To update the RockSolidAgent please copy the files from the RockSolidAgent directory to the RockSolidAgent service application path.  Usually this is located in c:\Program Files\RockSolid SQL\RockSolidAgent or c:\Program Files (x86)\RockSolid SQL\RockSolidAgent however if you are not sure you can check via the service properties:

Before updating the files you may wish to take a backup of existing files.  When updating the files you will be asked to confirm overwriting of the existing files.  Click Yes to confirm and overwrite existing files.

RockSolidAnalysisAgent

To update the RockSolidAnalysisAgent please copy the files from the RockSolidAnalysisAgent directory to the RockSolidAnalysisAgent service application path.  Usually this is located in c:\Program Files\RockSolid SQL\RockSolidAnalysisAgent or c:\Program Files (x86)\RockSolid SQL\RockSolidAnalysisAgent however if you are not sure you can check via the service properties as per above (for the RockSolidAnalysisAgent serivce).

Again you may wish to take a backup of existing files and once ready overwrite the existing files with the new files.

Ending the Update Process

Now you have completed the deployment process please ensure you start the following services on all hosts:

  • RockSolidAgent (typically multiple on multuple hosts, often on different networks)
  • RockSolidAnalysisAgent (typically one + dr)
  • RockSolidServerAgent (typically multiple on multiple hosts + dr)
  • RockSolidNotificationAgent (typically one + dr)

 

Checking Success

If you now go into the RockSolid application and click the "RockSolid Status" link in the page footer, then click the components tab you should see the updated version numbers listed:

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.