Report Server Agent historical reads fail intermittently

Issue

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

Product Line

SmartStruxure Solution

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.