Report Server Agent historical reads fail intermittently


The historical reads will fail from time to time due to process data failure

Product Line

SmartStruxure Solution


Report Server 1.6.0 and below


This is due to the ValueAfter and ValueBefore column in the tbEvents table of Reports db.

ValueAfter and ValueBefore Columns were designed as float datatype, When the Reporting Agent tries to convert the NeuronId of a LonWorks device (which is one of the data for ValueAfter and Valuebefore Columns) as a float then this issue occurs.

Due to this Reporting Agent will trigger the ES Read again.


With the change of ValueAfter and ValueBefore to nVarChar datatype, the issue gets solved.

These changes are included in Web reports 1.6.1.