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:
"[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 =, !=, <, <= , >, >= or when the subquery is used as an expression.]"
With Users version not reconciling, how do I go about solving this problem?
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