Enable archiving on SQL Server enterprise geodatabase feature class causes Invalid Cursor State error

899
1
Jump to solution
08-27-2019 01:21 PM
Col_Forbin
New Contributor III

I am attempting to enable archiving on a feature class in a SQL Server 2017 enterprise geodatabase using ArcCatalog 10.7.  I get this error when I run the Enable Archiving geoprocessing tool:

[[Microsoft] [ODBC Driver 13 for SQL Server]Invalid cursor state]

What might be causing this error?  I thought it might be a database space issue but the database is set to auto-grow and there is lots of space on the server.

0 Kudos
1 Solution

Accepted Solutions
Col_Forbin
New Contributor III

Thanks to Esri support, the cause of this was a trigger on the table in the geodatabase.  Once the trigger was disabled, the enable archiving tool ran successfully.

View solution in original post

1 Reply
Col_Forbin
New Contributor III

Thanks to Esri support, the cause of this was a trigger on the table in the geodatabase.  Once the trigger was disabled, the enable archiving tool ran successfully.