Error Message
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).Cause
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)'".
Solution or Workaround
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
Related Information
- 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
Error Message
Attempts to create new features in a hosted feature layer in ArcGIS Pro fail, and return the following error message:
Cause
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.
Solution or Workaround
To resolve the error, change the relational data store setting from read-only to read-write mode using the following workflow.
- Open Windows Command Prompt as an administrator.
- Log in to the ArcGIS Data Store machine as an administrator.
- Right-click the Command Prompt app icon and select Run as administrator.
- Navigate to the ArcGIS Data Store tools directory using the following command line:
- Ensure the relational data store is set to read-only. In the Command Prompt window, run the describedatastore utility.
If the relational data store is in read-only mode, the prompt returns the following message:
- 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.
- 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.
Related Information
- 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