https://community.esri.com/t5/arcgis-pro-questions/error-reconciling/m-p/1388137#M79468 <P>We have a script that reconcile and post all versions of our layer daily at 5 pm. Recently, I have been seeing Users having this error message:</P><P>"[2/27/2024 5:01:57 PM] Warning: Error reconciling version "GR\VJHAUTER".vjhauter.[Underlying DBMS error [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &lt;, &lt;= , &gt;, &gt;= or when the subquery is used as an expression.]"</P><P>With Users version not reconciling, how do I go about solving this problem?</P> Wed, 28 Feb 2024 16:51:03 GMT Abi 2024-02-28T16:51:03Z https://community.esri.com/t5/arcgis-pro-questions/error-reconciling/m-p/1388137#M79468 <P>We have a script that reconcile and post all versions of our layer daily at 5 pm. Recently, I have been seeing Users having this error message:</P><P>"[2/27/2024 5:01:57 PM] Warning: Error reconciling version "GR\VJHAUTER".vjhauter.[Underlying DBMS error [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &lt;, &lt;= , &gt;, &gt;= or when the subquery is used as an expression.]"</P><P>With Users version not reconciling, how do I go about solving this problem?</P> Wed, 28 Feb 2024 16:51:03 GMT https://community.esri.com/t5/arcgis-pro-questions/error-reconciling/m-p/1388137#M79468 Abi 2024-02-28T16:51:03Z https://community.esri.com/t5/arcgis-pro-questions/error-reconciling/m-p/1388272#M79484 <P>Are they not reconciling due to conflicts against Default? If so, you have to either resolve in favour of version or Default and then continue on</P> Wed, 28 Feb 2024 20:24:23 GMT https://community.esri.com/t5/arcgis-pro-questions/error-reconciling/m-p/1388272#M79484 AnthonyRyanEQL 2024-02-28T20:24:23Z