SYSPERFDATAIMPORTTHREADCOUNT and SYSPERFDATAIMPORTHANDLECOUNT Historian System Tags Missing

SUMMARY

The following OCMC Logger info messages may be encountered on a new Historian Server:

SYSPERFDATAIMPORTTHREADCOUNT
Tag not found
SYSPERFDATAIMPORTHANDLECOUNT

This tech note will provide steps to troubleshoot and resolve the issue.

APPLIES TO

• AVEVA Historian Server

PROCEDURE

In the Historian 2023 R2 versions, upon installation the Historian system tags SYSPERFDATAIMPORTTHREADCOUNT and SYSPERFDATAIMPORTHANDLECOUNT may be missing. To re-insert these tags, shutdown the Historian Server then execute the following SQL query against the Runtime Database:

Shutdown the Historian Server

1. Navigate to the OCMC -> Historian -> Historian Groups -> <Historian Name> -> Management Configuration > Status (right click) -> All Tasks -> Shutdown (and disable) Historian

Adding the System tags via SQL Server Query

2. Execute the following query against the Runtime database in SQL Server Management Studio:

DECLARE @Unit_Units INT;
SELECT @Unit_Units = EUKey FROM dbo._EngineeringUnit WHERE Unit = N'units';
EXEC dbo.aaAnalogTagInsert
@TagName = N'SysPerfDataImportThreadCount',
@TopicKey = 1,
@IOServerKey = 1,
@Description = N'Thread count for Historian Classic Manual Storage',
@AcquisitionType = 3,
@StorageType = 1,
@StorageRate = 5000,
@TimeDeadband = 0,
@ItemName = N'SysPerfDataImportThreadCount',
@EUKey = @Unit_Units,
@MinEU = 0,
@MaxEU = 128,
@MinRaw = 0,
@MaxRaw = 128,
@Scaling = 0,
@RawType = 3,
@IntegerSize = 16,
@SignedInteger = 0;
EXEC dbo.aaAnalogTagInsert
@TagName = N'SysPerfDataImportHandleCount',
@TopicKey = 1,
@IOServerKey = 1,
@Description = N'Handle count for Historian Classic Manual Storage',
@AcquisitionType = 3,
@StorageType = 1,
@StorageRate = 5000,
@TimeDeadband = 0,
@ItemName = N'SysPerfDataImportHandleCount',
@EUKey = @Unit_Units,
@MinEU = 0,
@MaxEU = 20000,
@MinRaw = 0,
@MaxRaw = 20000,
@Scaling = 0,
@RawType = 3,
@IntegerSize = 32,
@SignedInteger = 0;

Restart the Historian Server

3. Navigate to the OCMC -> Historian -> Historian Groups -> <Historian Name> -> Management Configuration > Status (right click) -> All Tasks -> Enable (allow to run) Historian