Cannot send form due to database error

[AngelNicoleAlvaro1]

Hi, hoping we could get some answers in Esri community. 

So here's the scenario.. We published a survey form using Connect 3.19.116 and Enterprise 11.3. 

Since the data coming from this survey form will be used by another contractor using their own software, we decided to create multiple hidden repeat tables so that not all fields will be hosted in the point itself. Those hidden repeat tables get their values from those outside the repeats that we set the esrifieldtype to null and have the necessary calculations. The appearance of the form itself depend on those outside the repeats and the data would be coming from those inside.

I've already set the field lengths to their appropriate values but we cannot submit a record because "database error has occurred.

Thank you very much.

I've also attached snippets of the form since we cannot share this publicly.

EDIT:

I tried adding the repeats below one-by-one but I noticed that I can send a record. We already have a repeat outside that we set to null but I noticed that it is still seen as a table in the layer. We also have this repeat inside the other repeat below and I'm wondering if this causes the error?

[DeonLengton]

Good day

Just a question - why didnt you rather create a View that you share with the outside contractor to limit what they can see?

[AngelNicoleAlvaro1]

Hi, DeonLengton. To answer your question, we wanted to group the fields and we will create enterprise tables for the other contractor to use. I think they cannot access the Portal directly and would be relying on the database for the records.

[DeonLengton]

Did you perhaps see if the ArcGIS Manager Error log shows more information?

[DavidSolari]

Try publishing the form without the links to your registered services so it creates a brand new hosted service. You can compare this service to your registered service to see what changes have to be made.

[AngelNicoleAlvaro1 · Accepted solution]

Hi, I already found the solution. I noticed that it was the length of several fields in a repeat that seems to be causing the problem. There was a calculation for them to show the choice list label instead of the codes so I just adjusted the field lengths.