Skip to main content
InSource Solutions

TN Hist237 Historian 11.X will not read older history blocks

insource logo large.jpg

 

Description

Historian 11.X will not read older history blocks after being migrated to a new system.

 

  • Author: Mike Viteri
  • Published: 11/12/2015
  • Applies to: Historian 11.X

 

 

Details

 

After moving older History Blocks into a new Historian 11.X installation. The older History Blocks cannot be accessed for the data. This is because previous versions used the Classic Storage Subsystem. The Storage Subsystem changed in Historian 11.X

 

Resolution

Edit section

 

Open your  Microsoft SQL Server Management Studio. Type in the following command in the against the runtime database and execute the query. You should have affected rows.

 

Update tag set AIHistory = 1 Where AIHistory = 0 and Tagname not like 'sys%'

 

 

 

 

AIHistory.JPG

 

Edit section

Now you will be able to query your older History Blocks for data.