Failed to connect to database general function failure ArcGIS

Adding an .xls file to ArcMap returns the following error.

Error:   
Failed to connect to database.
General function failure
Unexpected error from external database driver (1).

The error is returned due to having installed one of the following Microsoft updates:

• Windows 7:  October 10, 2017 — KB4041681 (Monthly Rollup)
• Windows 8.1: October 17, 2017—KB4041685 (Preview of Monthly Rollup)
• Windows 10: October 10, 2017 — KB4041676 (OS Build 15063.674)

Per Microsoft, "Installing this update may cause applications based on the Microsoft JET Database Engine (Microsoft Access 2007 and older or non-Microsoft applications) to fail when creating or opening Microsoft Excel .xls files. The error message is 'Unexpected error from external database driver (1). (Microsoft JET Database Engine)'".

Microsoft has provided an update to address this issue. Click the link below and install the appropriate update patch for the version and build of the operating system.

• Windows 7
• Windows 8.1
• Windows 10
   

• Windows 10: November 14, 2017 - KB4048954 (OS Build 15063.726 and 15063.728)
• Windows 7: November 14, 2017 - KB4048957 (Monthly Rollup)
• Security Update for Microsoft Windows (October 10, 2017 — KB4041681 (Monthly Rollup)
• October 10, 2017 — KB4041676 (OS Build 15063.674)

Last Published: 3/23/2018

Article ID: 000016969

Software: ArcMap 10.4.1, 10.4

Attempts to create new features in a hosted feature layer in ArcGIS Pro fail, and return the following error message:

Error:   
Failed to create new feature(s). 
General function failure [Database error has occurred.]

The relational data store in which the hosted feature layer is stored is set to read-only. In most cases, the relational data store is automatically set to read-only due to insufficient disk space.

To resolve the error, change the relational data store setting from read-only to read-write mode using the following workflow.

1. Open Windows Command Prompt as an administrator.
   1. Log in to the ArcGIS Data Store machine as an administrator.
   2. Right-click the Command Prompt app icon and select 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. In the Command Prompt window, run the describedatastore utility.

C:\Program Files\ArcGIS\DataStore\tools>describedatastore

If the relational data store is in read-only mode, the prompt returns the following message:

1. Change the relational data store setting from read-only to read-write. 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

Note:
In ArcGIS Data Store versions prior to version 10.8.1, the command line in Step 4 reads as follows:

C:\Program Files\ArcGIS\DataStore\tools>changedatastoremode readwrite 

When prompted with Do you wish to continue (Yes or No)?, type Yes, and press Enter.

1. If the relational data store is automatically set to read-only due to low disk space, re-enable automatic backups. Run the updatebackupschedule utility. Insert the values for starttime and frequency in the command line. Refer to Portal for ArcGIS: updatebackupschedule for more information.

updatebackupschedule --starttime 23:00:00 --frequency 10

• Portal for ArcGIS: ArcGIS Data Store command utility reference
• Portal for ArcGIS: Troubleshoot ArcGIS Data Store
• Portal for ArcGIS: Use ArcGIS Pro with your portal

Last Published: 2/17/2022

Article ID: 000022570

Software: ArcGIS Data Store 10.9.1, 10.9, 10.8.1, 10.8, 10.7.1, 10.7, 10.6.1, 10.6, 10.5.1, 10.5, 10.4.1, 10.4, 10.3.1, 10.3 ArcGIS Pro 2.9.1, 2.9, 2.8.5, 2.8.4, 2.8.3, 2.8.2, 2.8.1, 2.8, 2.7.5, 2.7.4, 2.7.3, 2.7.2, 2.7.1, 2.7, 2.6.8, 2.6.7, 2.6.6, 2.6.5, 2.6.4, 2.6.3, 2.6.2, 2.6.1, 2.6, 2.5.2, 2.5.1, 2.5, 2.4.3, 2.4.2, 2.4.1, 2.4, 2.3.3, 2.3.2, 2.3.1, 2.3, 2.2.4, 2.2.3, 2.2.2, 2.2.1, 2.2, 2.1.3, 2.1.2, 2.1.1, 2.1, 2.0.1, 2.0, 1.4.1, 1.4, 1.3.1, 1.3, 1.2