Error when Reconciling

1006
1
01-22-2014 09:09 AM
CraigPatterson
New Contributor III
Periodically, when reconciling, the following error is return.

The version could not be reconciled. Underlying DBMS error [Microsoft SQL Server native Client 10.0: Subquery returned more than 1 value. This is not permitted when the subquery follows =,!=,<,<=,>,>= or when the subquery is used as an expression.] [ArcGIS.GDBO.{featureclassname}]

Once this happens, the only solution has been to delete the version and redo any edits in that version.

Has anyone encountered this problem before?

Thanks,

Craig
0 Kudos
1 Reply
WilliamCraft
MVP Regular Contributor
Which version of ArcGIS Desktop and ArcSDE are you using?  Which version of SQL Server are you using? 

Some quick online searching reveals that this error occurs when more than one record is returned from a query while only one is expected.  It is difficult to know which table is actually producing this behavior without tracing the queries at the RDBMS level or performing an SDEINTERCEPT and/or an SDETRACE depending on how you are connecting to your geodatabase. 

It sounds to me like there could be an issue with your geodatabase's state lineage.  Have you performed a compress recently?  Have you tried running an SDEGDBREPAIR -o diagnose_metadata as well as an SDEGDBREPAIR -o diagnose_tables?  Replacing the word "diagnose" with "repair" (after referencing the SDEGDBREPAIR online help) will resolve the issues presented from the diagnosis.  This is just a possibility; I can't be sure about this as the cause for the error. 

You may need to contact Esri Support for this one.
0 Kudos