Knowledge Base
Showing results for 
Search instead for 
Did you mean: 

Report Server Agent historical reads fail intermittently


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


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. 

Tags (3)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎2018-09-06 09:09 AM
Updated by: