Add PM8000 Driver to ION Enterprise 6.0.1 or SPM 7.0.1

Issue
The user cannot find the PM8000 series in the device type drop-down field when adding a new device in the Management Console

Product
PM8000 series
ION Enterprise
StruxureWare Power Monitoring (SPM) 6.0 SP1 and SPM7.0.1.

Cause
A device driver is needed to correctly add the PM8000 to the system. This PM8000 series driver is compatible with ION Enterprise 6.0 SP1 and SPM7.0.1.

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.*

Download the PM8000 series driver from the attachments.

Note:
The second line of the query may indicate a failure; however, the query will still add the device driver .

It may be required to modify the PM8000.sql file to match the categories of DeviceType (first block of code) if the query continues to fail. Ensure the columns are listed and a value for each are specified in the 'SELECT' row, even if the value is set to null. Execute the query.
IF NOT EXISTS (SELECT ID FROM DeviceType WHERE Type ='8000')
INSERT INTO DeviceType (Type, DisplayName, TreeFile, MapFile, EthernetSupport, SecurityModules, UsesFlashFile, IONBufferSize_bytes, TranslatorID, UnsolicitedTickPeriod_ms)
SELECT '8000', 'PM8000', null, null, 2, 16, 1, 4096, [ID], 0 FROM Translator WHERE Name = 'ION';

When successful, the device type should be available in the drop-down list in the Management Console.

NOTE: PM8000 is a native driver forPME up to version 2023.

Released for:Schneider Electric Egypt and North East Africa