Failed to submit ArcGIS Survey123 response. Database error has occurred

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}]}]

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

3. 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.

4. 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.