Unable to upload report template

[ShelbyZelonisRoberson]

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!

[RobertAnderson3]

I know Survey123 won't allow you to upload a report template to a survey that has no data in it, that was my first thought. But since it's on an existing feature layer I'm not sure. Have you submitted anything through the Survey123 form yet to see if it works? And then maybe try the template again if it does?

[abureaux]

I would refresh the page and try again. When you re-publish from Connect and overwrite the database, you get errors when trying to upload a Report Template (assuming you already had the page open with old data) since the underlying Feature Layer has changed (Usually the error is different than what is shown in that screen cap, but always a good place to start).

After page reload, try again. If the error persists, there may be something wrong with the template. We would need to look at the template though (and also the XLSX) to evaluate if anything is wrong there.

[ShelbyZelonisRoberson]

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. 

[abureaux]

Oh, the auto-generated one also fails?

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

[ShelbyZelonisRoberson]

Yep there's a bunch of data in it.