Issue
The historical reads will fail from time to time due to process data failure
Environment
Report Server 1.6.0 and below
Cause
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.
Resolution
With the change of ValueAfter and ValueBefore to nVarChar datatype, the issue gets solved.
These changes are included in Web reports 1.6.1.