Power Monitoring Expert - Why does management console display "Object reference not set to an instance of an object" when configuring a device?

Issue
When configuring some devices in management console imported by JDX, error message "Object reference not set to an instance of an object" is displayed.

Product
JDX
Power Monitoring Expert 7.2.2
Power Monitoring Expert 8.2
Power Monitoring Expert 9.0


Environment
Management Console

Cause
Often, when devices are imported into PME using JDX, The device is added to the database [ION_Network].[dbo].[Device] as a SEPAM device.

Resolution
*Warning: Take backups of any databases prior to modifying them. Ensure the backups are in a location that will not be overwritten.*
*Warning: This article contains information about modifying the databases. Improper changes to the databases can result in the software being inoperable.*

1- In order to confirm that the node is added to the Device table as SEPAM run the following query;

USE ION_Network
Select * from Device
where EntityClassID = 24 and Address is not NULL

If the above query returns results with EntityclassID = 24, it confirms that the devices that cannot be configured in Management Console have been added as a SEPAM device as opposed to a Serial device.

2- In order to fix, execute the query bellow to correct the EntityClassID

USE ION_Network
Update Device
SET EntityClassID = 1
where EntityClassID = 24 and Address is not NULL

3- Re-run the query in step 1 to ensure that the EntityClassID is as expected.

Released for: Schneider Electric Canada