About this task
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.
- 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).
- 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 .
Import the alternate archive into SCT.
Refer to the Metasys® SMP Help (LIT-1201793) for details on importing archive databases into the SCT.
- Select Run as Administrator. Click Continue or Yes if prompted by the User Access Control dialog box. . When you select Command Prompt, use the right mouse key and select
Type the following at the command prompt:
CD C:\\ProgramData\"Johnson Controls"\MetasysIII\SQLData\SCTArchive\ARSDBFix
- Press Enter.
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.
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.
At the command prompt, type the following:
- Press Enter. If errors occur during execution, they appear in the command window. When the prompt reappears, the procedure is complete.
- Press Enter twice.