AnsweredAssumed Answered

Table names should follow the pattern <catalog.>schema.table

on Sep 29, 2017
Latest reply on Aug 2, 2018 by JHasthorpe-esristaff

Like • Show 1 Like1
Comment • 13

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.

Attachments

Capture1.JPG57.1 KB

1 person has this question

Outcomes

13 Replies

JHasthorpe-esristaff Oct 2, 2017 4:19 PM
Mark Correct
Correct Answer
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
Like • Show 0 Likes0
Actions
- dancorkran @ JHasthorpe-esristaff on Nov 6, 2017 7:04 AM
  Mark Correct
  Correct Answer
  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.
  Like • Show 0 Likes0
  Actions
JTedrick-esristaff Nov 6, 2017 12:36 PM
Mark Correct
Correct Answer
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?
Like • Show 0 Likes0
Actions
- bowlesgsrcx @ JTedrick-esristaff on Nov 8, 2017 8:52 AM
  Mark Correct
  Correct Answer
  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
  Like • Show 0 Likes0
  Actions
- dgoriesri-ca-esridist @ JTedrick-esristaff on Nov 8, 2017 9:02 AM
  Mark Correct
  Correct Answer
  Hi James,
  
  It was creating a hosted feature service using the ArcGIS Data Store. See my response at the bottom of this thread.
  Like • Show 0 Likes0
  Actions
dgoriesri-ca-esridist Nov 8, 2017 9:00 AM
Mark Correct
Correct Answer
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.
Like • Show 0 Likes0
Actions
- bowlesgsrcx @ dgoriesri-ca-esridist on Nov 8, 2017 11:27 AM
  Mark Correct
  Correct Answer
  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
  Like • Show 0 Likes0
  Actions
  - JTedrick-esristaff @ bowlesgsrcx on Nov 8, 2017 12:18 PM
    Mark Correct
    Correct Answer
    Hi Gary,
    
    Could you share the XLS file so that we could try to replicate?
    Like • Show 0 Likes0
    Actions
    - bowlesgsrcx @ JTedrick-esristaff on Nov 8, 2017 12:38 PM
      Mark Correct
      Correct Answer
      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
      Attachments
      fiif_barcode.JPG27.2 KB
      fiif.csv.zip461 bytes
      Freshwater_Impoundment_Inspection_Form.xlsx47.8 KB
      Like • Show 0 Likes0
      Actions
      - JTedrick-esristaff @ bowlesgsrcx on Nov 8, 2017 6:15 PM
        Mark Correct
        Correct Answer
        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?
        Like • Show 0 Likes0
        Actions
        bowlesgsrcx @ JTedrick-esristaff on Nov 9, 2017 5:04 AM
        Mark Correct
        Correct Answer
        Will do.
        Thanks,
        --gary
        Like • Show 0 Likes0
        Actions
        bowlesgsrcx @ bowlesgsrcx on Aug 2, 2018 8:22 AM
        Mark Correct
        Correct Answer
        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
        Like • Show 0 Likes0
        Actions
        JHasthorpe-esristaff @ bowlesgsrcx on Aug 2, 2018 6:22 PM
        Mark Correct
        Correct Answer
        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
        Like • Show 0 Likes0
        Actions

GeoNet

The Esri Community

Table names should follow the pattern <catalog.>schema.table

Attachments

Outcomes

Attachments

Related Content

Recommended Content