"External Component has thrown an exception" and "sharing lock count exceeded..." after a Modelbuilder Update in ArcGIS

Applies To 
Product(s): WaterGEMS, SewerGEMS, HAMMER
Version(s): V8i, CONNECT Edition
Environment:  ArcMap, ArcGIS
Area:  Output and Reporting
Original Author: Mark Pachlhofer, Bentley Technical Support Group

 

Problem

When using the ArcMap integrated platform, the following error appears (for example when trying to save edits):

"Unable to save edits. File sharing lock count exceeded. Increase MaxLocksPerFile registry entry."

Background

The Microsoft Access Jet engine that ESRI uses to update geodatabases has a threshold number of records that it is set to calculate which causes this issue to occur. This issue can occur especially with larger models. The number of "locks" can accumulate (within the given session) and cause the default maximum locks to be exceeded.

Steps to Resolve

Note: you must have administrative permissions to write to the Windows Registry in order to perform this fix. Please contact your site administrator for help if needed.

1. Navigate to the Program Files\ArcGIS\Desktop10.0\Utilities directory.

2. Double-click AdvancedArcMapSettings.exe. (right click and choose "run as administrator" if needed/if possible)

     The Advanced ArcMap Settings dialog box appears.

3. Click the Editor tab.

4. Type a new value in the JET engine max # of records to calculate text box.

     It's suggested that the number be approximately 100000 (100 thousand).

5. Click Apply.

6. Click the X in the upper right-hand corner to close the dialog box.

This information can be found in the ArcGIS Resource Center help documentation at:

http://help.arcgis.com/en/mapping_charting/10.0/install_guides/prod_mapping/index.html#//00z200000012000000.htm

Recommended
Related