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.
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.
게시 대상: 슈나이더 일렉트릭 Korea
