TN - 1171 Replication to AVEVA InSight fails after upgrading Historian.

Description

Replication to AVEVA InSight fails after upgrading Historian.

• Author: Ron Tanner
• Published: 06/30/2021
• Applies to: AVEVA Historian

Details

Replication to AVEVA InSight fails after upgrading Historian.

No issues adding the replication server and testing works as designed.

When you click the OK button, you receive the following error.

The problem is a result of the upgrade not updating the size of the column that stores the connection information/token.

To correct the issue use SQL Server Management Studio and execute the following T-SQL.

ALTER TABLE ReplicationServer
ALTER COLUMN ConnectionDetails nvarchar(4000)