https://community.esri.com/t5/data-management-questions/feature-service-deadlock/m-p/1505195#M45279 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/374856">@ahmedbadr2</a>&nbsp;- read the database connection best practices from my community.esri.com blog, there I explain the database deadlock scenarios and how to reduce the changes for deadlocks to occur.</P><UL><LI><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId--1336696408" target="_blank" rel="nofollow noopener noreferrer">Database Connections Best Practices</A></LI></UL> Sun, 14 Jul 2024 18:02:09 GMT MarceloMarques 2024-07-14T18:02:09Z https://community.esri.com/t5/data-management-questions/feature-service-deadlock/m-p/1505178#M45277 <P>Hello everyone. Hope you are all well,</P><P>Need help and support in for following errors after using web editing via <STRONG>GIS</STRONG> feature service:</P><UL><LI><STRONG>DBMS deadlock victim Microsoft ODBC driver 18 for SQL Server</STRONG></LI><LI><STRONG>The version has been redefined to reference a new database state</STRONG></LI></UL><P>keep getting these errors continuously and randomly.</P><P>Our environment is using ArcGIS enterprise 11 and enterprise geodatabase on MS SQL DBMS we have multiple traditional versioned feature classes published as feature service to be used and edited by our editors approximately <STRONG>150</STRONG> users.</P><P>Any thoughts and best practices will be appreciated</P> Sun, 14 Jul 2024 11:52:00 GMT https://community.esri.com/t5/data-management-questions/feature-service-deadlock/m-p/1505178#M45277 ahmedbadr2 2024-07-14T11:52:00Z https://community.esri.com/t5/data-management-questions/feature-service-deadlock/m-p/1505180#M45278 <P>No one respond to your question, I said 'Alsalam Alaikom'&nbsp;<span class="lia-unicode-emoji" title=":face_with_tears_of_joy:">😂</span></P> Sun, 14 Jul 2024 12:36:10 GMT https://community.esri.com/t5/data-management-questions/feature-service-deadlock/m-p/1505180#M45278 SaeedDaraghmeh 2024-07-14T12:36:10Z https://community.esri.com/t5/data-management-questions/feature-service-deadlock/m-p/1505195#M45279 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/374856">@ahmedbadr2</a>&nbsp;- read the database connection best practices from my community.esri.com blog, there I explain the database deadlock scenarios and how to reduce the changes for deadlocks to occur.</P><UL><LI><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId--1336696408" target="_blank" rel="nofollow noopener noreferrer">Database Connections Best Practices</A></LI></UL> Sun, 14 Jul 2024 18:02:09 GMT https://community.esri.com/t5/data-management-questions/feature-service-deadlock/m-p/1505195#M45279 MarceloMarques 2024-07-14T18:02:09Z