Hello,
I am trying to generate a monthly report using a Word template. The report was successfully generated last month (April 28) using the same template. Today, however, it is failing to generate and producing the following error message:
An error occurred when assembling data. Error message: An error occurred when querying data from the feature layer. 500: The connection attempt failed. The expression leads to this error: ${Code_Enforcement | where:"issue_label='Grass/weeds' AND resolution_status_latest='Resolved'" | stats:"count,objectid"}.
The parts highlighted in RED keeps changing to one of the other expressions in the template. i.e. it is different every time. I have confirmed that the word template does not have any syntax error. I have run another report template on the same dataset without any problem
Any suggestions regarding the source of this problem would be very helpful.
Thanks!
