topic Re: Error generating reports after Survey123 update in ArcGIS Survey123 Questions

Error generating reports after Survey123 update

RobBlash — Thu, 28 Feb 2019 14:45:50 GMT

See attached screen shot. I have several users who cannot generate reports (different surveys, but all are set up the same). These are existing surveys with existing templates that worked before today. The RemarksText field exists in the survey within a repeat.

Could this be related to the 3.3 update?

Update: I was told by Esri support that there is nothing they can do to help me since reports are in Beta. I have many reports that were working previously but now fail after the 3.3 update. James Tedrick‌ and Philip Wilson‌ do you have any ideas on what may be causing this? The field that's failing is in a repeat.

Re: Error generating reports after Survey123 update

RobBlash — Fri, 01 Mar 2019 14:27:11 GMT

I think I found the issue. The report doesn't like the fact that "Text" is in the field name ${RemarksText}. If I publish a new survey using an existing xlsx (and changing the name of that field) the report will work.

Re: Error generating reports after Survey123 update

Anonymous User — Fri, 01 Mar 2019 15:18:41 GMT

I was having some issues with one of my reports that references a field that is not found within my repeat. I had a field that represented the overall site ID and I had the custom report referencing that field within the repeat section of the custom report. It would actually grab the value of my question outside of the repeat and use it with each repeat entry.

However, when I tested the report, I found that I had to remove the field that was not found within the repeat in order for the report template to function. Just that means a slight update within my report/survey to see it work again.

Re: Error generating reports after Survey123 update

JamesTedrick — Fri, 01 Mar 2019 18:28:40 GMT

Hi Rob,

Does your form have a repeat section, and if so does the repeat section have a field whose name contains the name of the repeat? If so, this is an issue we will be fixing soon.

Re: Error generating reports after Survey123 update

RobBlash — Fri, 01 Mar 2019 19:31:32 GMT

James,

Do you know how soon? Trying to decide if I should wait or re-publish my surveys.

The problem does occur in a repeat. There was a field label that was the same as the repeat, but changing that didn't seem to fix the issue. It seemed like the word "Text" in the field name was the problem. If I have some time over the next few days to double-check if the label was the actual cause of the issue I will report back.

Re: Error generating reports after Survey123 update

Anonymous User — Fri, 01 Mar 2019 19:42:10 GMT

The issue with my survey and custom report is that I have a "text" field from the main survey within a repeat.

Question outside of the repeat that is part of the main form

Then the field within the repeat; I had to remove this question from the repeat in order for the custom report to be uploaded. This custom report worked well prior to this release.

Out of curiosity, I started attempting to use more of the my custom reports and they are all producing errors that pertain fields that are "text" based and not part of a repeat?

Hosted Feature Service

From the custom report

The error from the run of the custom report and this is the only place it is found.

Re: Error generating reports after Survey123 update

RobBlash — Sat, 02 Mar 2019 18:47:01 GMT

I had a little time to mess around with the issue this afternoon. I reproduced this error by creating a field label that is the same value as a repeat (either repeat label or repeat name, I didn't look at which one was the cause).

James Tedrick‌ do you have a suggested fix in the meantime? I re-published the survey with an revised label, then re-generated a report template but the error still persists. I also manually changed the field alias in the feature service settings but that didn't work either.

Re: Error generating reports after Survey123 update

JamesTedrick — Sun, 03 Mar 2019 04:47:23 GMT

Hi Rob,

At this time the only workaround would be altering your survey's schema. As I mention, we will be addressing this as soon as we are able to; unfortunately, with the Developer's Summit upon us, it will be slightly delayed.

Re: Error generating reports after Survey123 update

RobBlash — Sun, 03 Mar 2019 17:32:42 GMT

Thanks James. I tried altering the schema as described in my last post but that didn't work. The only other thing I can think of is to re-publish with a new repeat but I'm not sure that's possible without overwriting the service.

Now that I'm thinking more about it, I suppose I can also add new fields, calc over the values, delete the old fields, then published a new survey on top of the existing HFS.

Any other recommendations?

Re: Error generating reports after Survey123 update

Anonymous User — Mon, 04 Mar 2019 03:15:48 GMT

Hi Rob,

At this stage, we are aiming for the fix for this issue to be available and applied to the website by the end of next week. If you can wait without needing to make changes now, that may save some time and effort.

Phil.

Re: Error generating reports after Survey123 update

RobBlash — Thu, 07 Mar 2019 19:49:59 GMT

Thanks for the into Philip. Is there any timeline on when reports will move out of Beta?

Thanks,

Rob

Re: Error generating reports after Survey123 update

Anonymous User — Thu, 07 Mar 2019 21:58:39 GMT

Hi Rob,

Currently there is no fixed date to move the Report feature out of beta and into final release, however we are actively working on it and aiming for later this year, it could be as soon as the UC release, otherwise shortly after.

Phil.

Re: Error generating reports after Survey123 update

RobBlash — Thu, 07 Mar 2019 23:00:48 GMT

Thanks for the info

Re: Error generating reports after Survey123 update

HaroldHerrera1 — Mon, 18 Mar 2019 23:07:48 GMT

HelloJames Tedrick‌ and Philip Wilson

Do you have a date line to solve this problem?

Re: Error generating reports after Survey123 update

JamesTedrick — Mon, 18 Mar 2019 23:12:22 GMT

Hi Harold,

We had a few issues identified in testing that delayed the release of the hot fix. We now expect to release it later this week, assuming no further issues arise.

Re: Error generating reports after Survey123 update

RobBlash — Wed, 20 Mar 2019 17:20:34 GMT

Hi James,

Is the fix still on track for this week? I have a few folks ready to give me the Ned Stark treatment at this point, so I'll need to go with plan b if the fix wont be in place soon.

Thanks,

Rob

Re: Error generating reports after Survey123 update

JamesTedrick — Wed, 20 Mar 2019 20:21:16 GMT

Hi Rob,

Yes, the fix is still planned for this week; ideally tomorrow. Just to verify, have you tested the report on https://survey123qa.arcgis.com ?

Re: Error generating reports after Survey123 update

HaroldHerrera1 — Wed, 20 Mar 2019 21:43:03 GMT

Yes!

Re: Error generating reports after Survey123 update

RobBlash — Wed, 20 Mar 2019 23:05:24 GMT

Thanks for the update. I haven't had the chance to test in beta, but I will try to find some time tomorrow.

Re: Error generating reports after Survey123 update

JamesTedrick — Thu, 21 Mar 2019 14:50:54 GMT

Hi Rob,

We were actually able to update the website overnight last night; you should be able to test on regular survey123.arcgis.com