Error: Unable to save edits. Underlying DBMS error
After performing editing operations on an ArcSDE feature class that was previously registered as versioned, the following error message is displayed:
"Unable to save edits. Underlying DBMS error[Microsoft OLE DB Provider for SQL Server:
Procedure 'SDE_state_def_delete' expects parameter '@checkChildren', which was not supplied.]"
When connecting to an ArcSDE geodatabase that has been upgraded to the general update patch 2, the following applications need to have the matching client .DLLs in their bin folder of the install directory. Otherwise, there are a series of error messages that appear when the client and server softwares are not at the same patch level.
· ArcIMS 9.1
· ArcInfo Workstation 9.1
· ArcView GIS 3.3 with DBA 2.1g
Solution or Workaround
Ensure that the proper .DLLs are installed on the client applications connecting to ArcSDE after the general update patch 2 has been applied.
See the procedure on the ArcSDE 9.1 general update patch installation page, linked in the Related Information section below.