Hi there
Last year I created a report template which I uploaded to https://survey123.arcgis.com/surveys and everything was working perfectly. I could share the reports to others. Thereafter, I recall also creating a hosted layer view of the feature service in AGOL. Dont think I made any other changes.
Unfortunately this year I am unable to generate any reports. I get the error message "Error occurred when querying data from the feature layer. Cannot perform query. Invalid query parameters." after clicking on the "generate" report button, or viewing the sample report.
At first I thought this may be related to any permissions being changed on the layer in AGOL, but I don't think so.
I even tried downloading a sample report from Survey123 (under Mange Templates) for my dataset but that also does not work.
Any suggestions as to where my problem may lie?
Solved! Go to Solution.
Hi Mervyn,
Thank you for the information.
According to your description, I can confirm this is the bug I mentioned in 3.8 release. We already planned a hotfix to address this in a few days, will let you know once it's released. In the meantime, you can use the workaround (manually sort any field in the table first) to generate a report as needed, the result will be the same after the hotfix.
For the Overview page, since the underlying feature service does not have an edit date field from editor tracking, what you see is a by-design behavior for now because that we cannot extract related info if there is no creator, creation date, edit date fields. If you have any use case or question (for example, regardless of editor tracking fields, you do have equivalent fields by your own design), please don't hesitate to let us know.
Thanks,
Zhifang
Hi Mervyn Lotter ,
Would you mind sharing
We have identified a bug after the recent 3.8 release on 1/22, which will raise the exactly same error message as you mentioned. Below are the conditions to reproduce the bug:
Can you please check if this is what you encountered? Note: if you can work around this error by just manually sort any field in the feature table (no matter ASC or DESC) before previewing or generating the report, then you should hit this bug.
Thanks,
Zhifang
Hi Zhifang
Thank you for your email. The good news is that sorting the records does allow me to create my reports.
Interestingly, when i now look at the Overview tab in www.survey123.arcgis.com, then under Surveys Submitted, it now says "This feature is not available. The creator field cannot be found in the feature service."
Hi Mervyn,
Thank you for the information.
According to your description, I can confirm this is the bug I mentioned in 3.8 release. We already planned a hotfix to address this in a few days, will let you know once it's released. In the meantime, you can use the workaround (manually sort any field in the table first) to generate a report as needed, the result will be the same after the hotfix.
For the Overview page, since the underlying feature service does not have an edit date field from editor tracking, what you see is a by-design behavior for now because that we cannot extract related info if there is no creator, creation date, edit date fields. If you have any use case or question (for example, regardless of editor tracking fields, you do have equivalent fields by your own design), please don't hesitate to let us know.
Thanks,
Zhifang
Hi Mervyn,
We fix to this issue is now available on the Survey123 website, you should be able to generate the report without doing any additional steps.
Thanks,
Zhifang
Hi Zhifang
Works like a charm once again. Thanks so much!
Cheers
Mervyn
I'm also having this issue. When trying to upload a Report template, I get the error: "Error: An error occurred when querying data from the feature layer. An error occurred when querying data from the feature layer. 400: Cannot perform query. Invalid query parameters."
Tracing the network call, the call is failing on this parameter: "queryParameters":{"orderByFields":"||EditDate_2 DESC, OBJECTID ASC","objectIds":"43"} I am wondering if possibly the "||" in the query parameters is causing the error? The report template that I'm trying to upload is very basic with no complicated syntax, for testing purposes:
From the advice in this thread, I manually sorted a column in the survey table before uploading the report template, but I am still getting the same error. The survey was published with version 3.10. Any advice is greatly appreciated! Thanks.
Hello,
I had the same error,
check that you do not have any field with dash -
i create a survey using connect and use dash and publish
then i change the dash (-) for underscore (_) and republish
but in hosted feature the field was there, so I delete the fields that had dash (-) and then it worked.
hope this help.
DLL