Power Monitoring Expert - Why can't I choose an archived database to run a report on in Reporting Configuration Manager?
Issue
The user cannot select the ION_Data archive from the Reports Configuration drop down menu.
Product Line
Power Monitoring Expert (PME)
Cause
This can happen after an archived database from a previous version of Power Monitoring Expert (PME) has been upgraded because the Value for the Schema gets incorrectly set to ION_Data. When you go to Reporting Configuration Manager to select your archived database, it will not show up in the list as a database to choose.
Resolution
Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
For PME 7.x, 8.x:
First, open SQL Server Management Studio and connect to the PME instance.
Then, expand the archived database and expand the tables folder.
Next, right click on "dbo.Registry" table and select the "edit top 200 rows" option. (as shown in screen shot below)
Next, edit a field in the Registry table in your archived database( dbo.Registry table). After upgrading your archive in PME7.2, the Value for the Schema in the Registry table will say 'ION_Data'.
User will need to edit the Value from "ION_Data" to "ION_Data_Archive" as shown below. Once that is done, your archived database will show up in Reporting Configuration Manager and you will be able to use this database in Reports.
For PME versions 9.0 & greater:
- Upgrade the archived database by navigating to Management Console > Tools > Database Manager > right-click the archived database > left-click Upgrade Database... > confirm the database and left-click OK > wait for the script to finish executing.
- Open SQL Server Management Studio and connect to the PME instance.
- Expand the archived database and expand the tables folder.
- Right-click on "dbo.Registry" table and select the "Edit Top 200 Rows" option. (as shown in screen shot below)
- Edit the Value "ION_Data" to "ION_Data_Archive" as shown below.
- After completing the above steps, navigate to Management Console > Tools > Reports Configuration > Reports and you should be able to select the archived database.