ERROR

Failed to submit ArcGIS Survey123 response. Database error has occurred

Last Published: January 31, 2024

Error Message

Attempts to submit a survey response in ArcGIS Survey123 fail and return the following error message:

Error:
Failed to submit. 
[{"id":0,"addResults":[{"success":false,"globalId":null,"error" {"code":10500,"description":"Database error has occurred."},"objectId":null}]}]
Error message when submitting a survey repsonse.png

Cause

The relational data store storing the hosted feature layer is set to read-only. In most cases, the relational data store is placed in read-only automatically due to insufficient disk space, which is 1024 MB by default. The relational data store can also be set to read-only by the administrator for maintenance purposes.

Solution or Workaround

Change the relational data store mode from read-only to read-write mode.

Note:
If disk space is insufficient, add more disk space before changing the relational data store mode. Refer to ArcGIS Enterprise: Disk space requirements for more information.
  1. Open Windows Command Prompt as an administrator.
    1. Log in to the ArcGIS Data Store machine as an administrator.
    2. Click Start on the Windows taskbar or press the Windows key.
    3. Type cmd to search for Command Prompt.
    4. Right-click Command Prompt and click Run as administrator.
  2. Navigate to the ArcGIS Data Store tools directory using the following command line:
cd C:\Program Files\ArcGIS\DataStore\tools
  1. Ensure the relational data store is set to read-only.
    1. In the Command Prompt window, run the describedatastore utility.
C:\Program Files\ArcGIS\DataStore\tools>describedatastore

The image below displays the relational data store in read-only mode.

The read-only data store mode is displayed on the Command Prompt window.png
  1. Change the relational data store mode from read-only to read-write. 
    1. In the Command Prompt window, run the changedatastoremode utility. Refer to Portal for ArcGIS: changedatastoremode for more information.
C:\Program Files\ArcGIS\DataStore\tools>changedatastoremode readwrite --store relational --prompt no

The image below displays the data store mode after changing from read-only to read-write.

The Command Prompt window displaying the data store mode as read-write.png

Article ID:000031815

Software:
  • ArcGIS Data Store
  • Portal for ArcGIS
  • ArcGIS Survey123

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic