Changing the archive database used by the Metasys Advanced Reporting System (Windows Server platform only) - Metasys - LIT-1201645 - MS-ADSxxx-x - MS-ADXxxx-x - Server - ADS Server - ADX Server - 13.0

ADS/ADX Commissioning Guide
Product
Building Automation Systems > Databases and Data Servers > ADS Server
Building Automation Systems > Application Servers > ADX Server
Document type
Commissioning Guide
Document number
LIT-1201645
Version
13.0
Revision date
2023-10-12
Product status
Active

About this task

Note: To perform this task, you must have SQL Server CREATE PROCEDURE permission on the archive database (to create stored procedures) and UPDATE permission on the Metasys Reporting database. As a SQL Server software administrator, you should have these permissions by default. Also, you must have Administrator rights for the Windows operating system.

This procedure is required only if you meet one of the following requirements:

  • You have the Metasys Advanced Reporting System installed on your ADX and would like to change the archive database referenced by the reporting system without uninstalling and re-installing the ADX software.

  • You have an ADX Turnkey and would like to have the reporting system refer to an archive other than MyArchive1 (the default reporting system archive database on an ADX Turnkey).

You must repeat this procedure every time you import a new database.

Procedure

  1. If you would like to rename your ADX computer, do so now. For a non-Turnkey system, see Appendix: Changing the ADS or ADX name and the computer name on an ADS and unified ADX. For a Turnkey system, refer to the ADS/ADX Turnkey User's Guide (LIT-12011177).
  2. Make sure the archive database you are going to associate with the reporting system is at the same release as the reporting system SCT and ADX .
  3. Import the alternate archive into SCT.
    Refer to the Metasys® SMP Help (LIT-1201793) for details on importing archive databases into the SCT.
  4. Select Start > All Programs > Accessories > Command Prompt. When you select Command Prompt, use the right mouse key and select Run as Administrator. Click Continue or Yes if prompted by the User Access Control dialog box.
  5. Type the following at the command prompt: CD C:\\ProgramData\"Johnson Controls"\MetasysIII\SQLData\SCTArchive\ARSDBFix
  6. Press Enter.
  7. At the prompt, type the following:

    ARSDBFix.bat “database name”

    where “database name” is the name of the alternate archive. If the name contains spaces, enclose the entire name in double quotes as in Step 5. If the name has no spaces, quotes are not required.

  8. Press Enter. If errors occur during execution, they appear in the command window.
    Note: For more information on the execution, type ADRDBFix.bat /? at the prompt and press Enter.
  9. At the command prompt, type the following:

    ReloadCache.bat

  10. Press Enter. If errors occur during execution, they appear in the command window. When the prompt reappears, the procedure is complete.
  11. Type Exit.
  12. Press Enter twice.