Unable to upload report template

Question

Hello,

I built a survey in Connect 3.19 and published it to an existing feature service that lives in my SQL Server EGDB and is published (by a user with edit privileges to the database) to my Portal.

I am trying to upload a report template for the survey and keep getting an error. I get the error whether I use Esri's default template or one that I have modified. I'm uploading it with an admin account which I also created the survey with.

The error is "Error: An error occurred when querying data from the feature layer. 400: Unable to complete operation. Query with count request failed." Screenshot attached.

Ideas?? Thanks!

ReportError.png

KarlTian1_1-1734081637539.png

ShelbyZelonisRoberson · Answer

Updating this --

I ended up completely rebuilding and republishing the feature service to a new survey and the report template worked.

HOWEVER, I just had to make a few changes to the survey/feature service (add a couple fields to the main table and two related tables), and now I'm getting the query error again when I upload a report template.

@JamesTedrick or Survey123 team -- any idea how to fix this without rebuilding the entire survey again? This is about to be a major production survey for 2000 users and I can't keep having to rebuild it and change the link every time I need to add a field.

abureaux · Answer

Oh, the auto-generated one also fails?

Please try uploading a blank word document. Does that also fail?

ShelbyZelonisRoberson · Answer

This has been happening over the past week so it's been refreshed a lot. Originally I thought maybe something was wrong with the template, so I uploaded the Esri-generated template sample. That one fails too, so I think there is something outside of the template that is failing.