Generating Reports Error in ArcGIS Enterprise

[Vaneiri_Patt]

I was able to generate reports but now I am unable to generate reports. I am getting the error below.

Any thoughts? I have been searching but no success on this. 

[Richard_Purkis]

Hi @Vaneiri_Patt 

Judging by the error the reports is failing to generate because a query is failing because of the count request. If you remove this or simplify it to make it guaranteed to succeed are reports generated successfully?

Hope this helps

[Vaneiri_Patt]

Not sure how do I do that? 

I downloaded an individual template and uploaded that and I am getting that error. I had formatted one nice template and was getting that error so tested using the same template it allows you to download and still getting that error.