topic Table names should follow the pattern <catalog.>schema.table in ArcGIS Survey123 Questions

Table names should follow the pattern schema.table

DishaGori1 — Fri, 29 Sep 2017 21:46:29 GMT

I've published a survey using the latest Survey 123 Connect (2.4) to Portal for ArcGIS 10.4.1 . It has an image attachment option. If I include the image , it fails to submit with this error:

Code 500 Tables names should follow the patter <catalog.>schema.table

(see attached picture)

If I remove the picture attachment, the survey submits just fine. This goes to show that the survey is working fine. It just fails on picture attachment.

If I publish a simple survey with just a text field and a photo attachment field , it works. The issue is just with the survey in question.

Has anyone experienced the same error and know what the resolution is?

This works when the survey is published it to Portal for ArcGIS 10.5.1 but upgrading is not an option for now.

Re: Table names should follow the pattern schema.table

JohnathanHasthorpe — Mon, 02 Oct 2017 23:19:40 GMT

Hi Disha - can you confirm the exact version of Survey123 you are on? We have released a patch and are currently on Survey123 2.4.72, Survey123Connect 2.4.60. If you are still having issues with this version please share your survey xls with me.

Thanks

John

Re: Table names should follow the pattern schema.table

DanielCorkran — Mon, 06 Nov 2017 15:02:56 GMT

Hi Johnathan. I am also having the same problem with photo attachments. I am using Survey123Connect 2.4.60 and Survey 123 2.4.72. Could you please let me know if there is a workaround to this issue? If I cannot use Survey123 to collect photos, I will have to switch to a different platform.

Re: Table names should follow the pattern schema.table

JamesTedrick — Mon, 06 Nov 2017 20:36:08 GMT

Hi Disha,

Is this survey going to a feature layer on the Data Store or to a service on a federated server? If the latter, which DB is being used?

Re: Table names should follow the pattern schema.table

GaryBowles1 — Wed, 08 Nov 2017 16:52:14 GMT

James,

I just created a survey using 2.4.60 Connect, 2.4.72 mobile app on an iPad Mini2 and am getting the same error. Survey is published to a federated hosting server using SQLServer.

Thanks,

--gary

Re: Table names should follow the pattern schema.table

DishaGori1 — Wed, 08 Nov 2017 17:00:14 GMT

Hi Everyone,

It turned out to be an issue with the length of the field names in my case and a bug was logged for that:

BUG-000108569: Survey123 for ArcGIS documentation does not say that the maximum field length limit is 19 characters.

So make sure your field names are less than 19 characters.

Renaming the field names solved the issue for me.

Re: Table names should follow the pattern schema.table

DishaGori1 — Wed, 08 Nov 2017 17:02:07 GMT

Hi James,

It was creating a hosted feature service using the ArcGIS Data Store. See my response at the bottom of this thread.

Re: Table names should follow the pattern schema.table

GaryBowles1 — Wed, 08 Nov 2017 19:27:57 GMT

I redid my field names with none of them longer than 16 characters and am still receiving the same error.

Portal is 10.4.1

--gary

Re: Table names should follow the pattern schema.table

JamesTedrick — Wed, 08 Nov 2017 20:18:17 GMT

Hi Gary,

Could you share the XLS file so that we could try to replicate?

Re: Table names should follow the pattern schema.table

GaryBowles1 — Wed, 08 Nov 2017 20:38:02 GMT

James,

See attached. I have included the csv file used for the pulldata and a barcode.

Thanks,

--gary

Gary H. Bowles, GISP

GIS Database Administrator | Seneca Resources

Office : 412-548-2544 | Cell Phone: 412-334-5273

Re: Table names should follow the pattern schema.table

JamesTedrick — Thu, 09 Nov 2017 02:15:39 GMT

Hi Gary,

I'm not replicating with your form from a federated service on a 10.4.1 portal. Can I ask that you file a ticket with Esri Support to further debug?

Re: Table names should follow the pattern schema.table

GaryBowles1 — Thu, 09 Nov 2017 13:04:55 GMT

Will do.

Thanks,

--gary

Re: Table names should follow the pattern schema.table

GaryBowles1 — Thu, 02 Aug 2018 15:22:11 GMT

Thanks to Esri support for their help in solving an issue we were having that was related to BUG-000108569: Survey123 for ArcGIS documentation does not say that the maximum field length limit is 19 characters. In addition to the field names being less than 19 characters, the form_id must also be less than 19 characters or you will receive the following error: Table name should follow the pattern <catalog> schema.table

Thanks,

--gary

Re: Table names should follow the pattern schema.table

JohnathanHasthorpe — Fri, 03 Aug 2018 01:03:49 GMT

Hi Gary the 19 character limit for question names is documented here: Use Survey123 with ArcGIS Enterprise—Survey123 for ArcGIS | ArcGIS.

There should not be a limit on the form_id.

Thanks

John