topic Trigger on A table causes reconcile to fail in Data Management Questions https://community.esri.com/t5/data-management-questions/trigger-on-a-table-causes-reconcile-to-fail/m-p/405413#M23271 <HTML><HEAD></HEAD><BODY><SPAN>Have a trigger on an A table that updates a MODDATE attribute field with sysdate - it updates fine in the A table but when I do a reconcile I get error:</SPAN><BR /><BR /><SPAN>The version could not be reconciled.</SPAN><BR /><SPAN>Underlying DBMS error[ORA-04091:table HOUSTON.A189 is mutating, trigger/function may not see it</SPAN><BR /><SPAN>ORA-06512: at HOUSTON.CONTR_TRG, line 9</SPAN><BR /><SPAN>ORA04088:error during execution of trigger "HOUSTON.CONTR_TRG][HOUSTON.CONTR_OVL]</SPAN></BODY></HTML> Fri, 30 Jul 2010 20:14:47 GMT AnastasiaAourik 2010-07-30T20:14:47Z Trigger on A table causes reconcile to fail https://community.esri.com/t5/data-management-questions/trigger-on-a-table-causes-reconcile-to-fail/m-p/405413#M23271 <HTML><HEAD></HEAD><BODY><SPAN>Have a trigger on an A table that updates a MODDATE attribute field with sysdate - it updates fine in the A table but when I do a reconcile I get error:</SPAN><BR /><BR /><SPAN>The version could not be reconciled.</SPAN><BR /><SPAN>Underlying DBMS error[ORA-04091:table HOUSTON.A189 is mutating, trigger/function may not see it</SPAN><BR /><SPAN>ORA-06512: at HOUSTON.CONTR_TRG, line 9</SPAN><BR /><SPAN>ORA04088:error during execution of trigger "HOUSTON.CONTR_TRG][HOUSTON.CONTR_OVL]</SPAN></BODY></HTML> Fri, 30 Jul 2010 20:14:47 GMT https://community.esri.com/t5/data-management-questions/trigger-on-a-table-causes-reconcile-to-fail/m-p/405413#M23271 AnastasiaAourik 2010-07-30T20:14:47Z Re: Trigger on A table causes reconcile to fail https://community.esri.com/t5/data-management-questions/trigger-on-a-table-causes-reconcile-to-fail/m-p/405414#M23272 <HTML><HEAD></HEAD><BODY><SPAN>You'll have to modify your trigger, its mutating. See Oracle's documentation.</SPAN><BR /><BR /><SPAN>Good luck.</SPAN></BODY></HTML> Thu, 05 Aug 2010 20:29:29 GMT https://community.esri.com/t5/data-management-questions/trigger-on-a-table-causes-reconcile-to-fail/m-p/405414#M23272 TomBrown 2010-08-05T20:29:29Z