Issue
When the PQDIF Exporter is launched from Management Console an 'unhandled exception' error dialog pops up.
Product Line
PME 7.2.x
PME 8.x
Environment
Management Console
PQDIF Exporter
Cause
This can occur in a Power Monitoring Expert system that has been upgraded to version 7.2.2 or 8.x from an earlier version.
Resolution
*Warning: Take backups of any files prior to modifying them. Ensure the backups are in a location that will not be overwritten (i.e. the Desktop).
In order to correct this problem, it is necessary to make edits to 'PQDIFExporterConfig.xml' and 'PQDIFExporterConfig.xsd' located in the \config\exporters\PQDIF\config directory. The required changes are indicated below in bold.
PQDIFExporterConfig.xml
<DatabaseConnection
SQLServer=""
DataDB=""
NetworkDB=""
SystemLogDB=""
User=""
Password=""
Timeout="60"
CommandTimeout="180"
UseWindowsAuthentication="false"
/>
<!-- DatabaseConnection
- SQLServer - the SQL Server instance hosting the ION databases
- DataDB - The database containing the data samples to export
- Network DB - The database containing information about the ION network
- SystemLogDB - The database containing the log of ION system messages
- User - SQL Server user ID to sign on with
- Password - password for the above user ID
- Timeout - the limit in seconds before a timeout will occur when connecting to the database ( must be > 0 )
- CommandTimeout - the limit in seconds before a timeout will occur when performing a query on the database ( must be >0 )
- UseWindowsAuthentication - boolean, if it's true the connection ignores username and passowrd, using 'Integrated Security=SSPI' -->
PQDIFExporterConfig.xsd
<xs:element name="DatabaseConnection">
<xs:complexType>
<xs:attribute name="SQLServer" form="unqualified" type="xs:string" />
<xs:attribute name="DataDB" form="unqualified" type="xs:string" />
<xs:attribute name="NetworkDB" form="unqualified" type="xs:string" />
<xs:attribute name="SystemLogDB" form="unqualified" type="xs:string" />
<xs:attribute name="User" form="unqualified" type="xs:string" />
<xs:attribute name="Password" form="unqualified" type="xs:string" />
<xs:attribute name="Timeout" form="unqualified" type="xs:positiveInteger" />
<xs:attribute name="CommandTimeout" form="unqualified" type="xs:positiveInteger" />
<xs:attribute name="UseWindowsAuthentication" form="unqualified" type="xs:boolean" />
</xs:complexType>
</xs:element>
When the PQDIF Exporter is launched from Management Console an 'unhandled exception' error dialog pops up.
Product Line
PME 7.2.x
PME 8.x
Environment
Management Console
PQDIF Exporter
Cause
This can occur in a Power Monitoring Expert system that has been upgraded to version 7.2.2 or 8.x from an earlier version.
Resolution
*Warning: Take backups of any files prior to modifying them. Ensure the backups are in a location that will not be overwritten (i.e. the Desktop).
In order to correct this problem, it is necessary to make edits to 'PQDIFExporterConfig.xml' and 'PQDIFExporterConfig.xsd' located in the \config\exporters\PQDIF\config directory. The required changes are indicated below in bold.
PQDIFExporterConfig.xml
<DatabaseConnection
SQLServer=""
DataDB=""
NetworkDB=""
SystemLogDB=""
User=""
Password=""
Timeout="60"
CommandTimeout="180"
UseWindowsAuthentication="false"
/>
<!-- DatabaseConnection
- SQLServer - the SQL Server instance hosting the ION databases
- DataDB - The database containing the data samples to export
- Network DB - The database containing information about the ION network
- SystemLogDB - The database containing the log of ION system messages
- User - SQL Server user ID to sign on with
- Password - password for the above user ID
- Timeout - the limit in seconds before a timeout will occur when connecting to the database ( must be > 0 )
- CommandTimeout - the limit in seconds before a timeout will occur when performing a query on the database ( must be >0 )
- UseWindowsAuthentication - boolean, if it's true the connection ignores username and passowrd, using 'Integrated Security=SSPI' -->
PQDIFExporterConfig.xsd
<xs:element name="DatabaseConnection">
<xs:complexType>
<xs:attribute name="SQLServer" form="unqualified" type="xs:string" />
<xs:attribute name="DataDB" form="unqualified" type="xs:string" />
<xs:attribute name="NetworkDB" form="unqualified" type="xs:string" />
<xs:attribute name="SystemLogDB" form="unqualified" type="xs:string" />
<xs:attribute name="User" form="unqualified" type="xs:string" />
<xs:attribute name="Password" form="unqualified" type="xs:string" />
<xs:attribute name="Timeout" form="unqualified" type="xs:positiveInteger" />
<xs:attribute name="CommandTimeout" form="unqualified" type="xs:positiveInteger" />
<xs:attribute name="UseWindowsAuthentication" form="unqualified" type="xs:boolean" />
</xs:complexType>
</xs:element>