Technical FAQs

Ask a Question

How to configure Repgen custom reports to work with a new server name?

Issue
If a report is created on one server and then taken to a new server with a different name, the report will not work. When the report is run the following error is observed:
*ERROR* Error -2147467259 [[DBNETLIB]]ConnectionOpen (SQL Server does not exist or access denied.) has occurred in Microsoft OLE DB Provider for SQL Server

Product Line
PME7.2 PME8.0

Environment
Custom Reports

Cause
When a report is made with Repgen, report configuration parameters are created which store the server connection information in the report. 

Resolution
Do the following to resolve this issue:
1) On the Power Monitoring Expert primary server go to the report folder ...\Power Monitoring Expert\config\reports
2) Open the report that won't run in Excel.
3) If using Excel 2007 then: go to format > sheet > unhide and choose |PRIVATE|Datasheets
OR If using Excel 2013 then: right click on the sheets near the bottom > click Unhide > choose |PRIVATE|Datasheets

4) Change column Y from OldServerName\ION to NewServerName\ION
5) Go to format > sheet > hide and then save the excel sheet.
6) Verify reports are now working.
Was this helpful?
What can we do to improve the information ?