English

Error: Warning 999999: Table schema changed after cursor declared

Error Message

When setting up a new Utility Network using the Naperville sample data provided by the ArcGIS Solutions team, running the Apply Asset Package geoprocessing tool in ArcGIS Pro while working with a SQL Server database returns the following error:

Error:   
Warning 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds. 
Table schema changed after cursor declared [42000:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Could not complete cursor operation because the table schema changed after the cursor was declared.]
Image of the error message when running the Asset Package tool.

Cause

This issue is specific to SQL Server databases, and occurs because of a memory pressure, forcing the Common Language Runtime (CLR) application domain to unload. This is not an issue with the Apply Asset Package tool, Utility Network for ArcGIS, or the ArcGIS Solutions packages.

Solution or Workaround

To circumvent this issue, reduce the size of the maximum server memory for the SQL instance. To do so:

  1. Launch SQL Server Management Studio.
  2. Right-click an instance and select Properties in Object Explorer.
  3. Click Memory in the left pane.
  4. Set the Maximum server memory to a value between 70% to 80% of available memory on the machine where the SQL Server is installed. Click OK.

    Image of the Memory tab in the Server Properties window of SQL Server Management Studio.
     
  5. Restart the SQL Server service.
  6. Rerun the Apply Asset Package tool.

Related Information