Data Gateway Query Execution Report - huge value for DataProcessingDuration

[dbishop]

Using Enterprise Gateway  I am seeing some large numbers for DataProcessDuration. For example one value is 637,328,255,004,381 ms.  These large values appear to be random. They show up on different data sources including AD, SQL, SSAS, and SharePoint for different dates and time. The query reports as successful in each case. These very large numbers, though only a small percentage overall, skew the reports too a point where I will either have to replace the value with some average over time or delete the record all together.

Anyone else see this trend? Any thoughts of why these values are apparently incorrect yet the data suggest the refresh had no issue and reports a success?

Thanks

[v-yuta-msft]

@dbishop ,

I would suggest you create a support ticket here for further analysis.

 

Regards,

Jimmy Tao

[jol]

@dbishop,

I am having a similar issue with some values for DataProcessingDuration(ms) being very large (such as 63,735,264,648,916). Do you ever get to the bottom of this?

What version of the Gateway are you using? I'm on 3000.54.8 (August 2020). 

Thanks,

Joel

[cognovo]

Same here. Some rows have big numbers for DataProcessingDuration(ms) that seem to be incorrect. 

Example:

d0158dff-5777-4921-aa54-71b74b2f8220,2021-11-07T15:01:19.6198462Z,10635,Refresh,0,593.7439,1421.679,159479215,2021-11-07T15:02:57.5642698Z,63771894177564,Y,

d0158dff-5777-4921-aa54-71b74b2f8220,2021-11-07T15:01:19.6198462Z,10635,Refresh,0,593.7439,1421.679,159479215,2021-11-07T15:02:57.5642698Z,63771894177564,Y

Query Execution Duration about 10 seconds and DataProcessingDuration: 63771894177564 

[Sokon]

I suggest voting for this feature in order to get Microsoft's attention!