Select to view content in your preferred language

Feature Service Deadlock

58
2
8 hours ago
Labels (3)
ahmedbadr2
New Contributor III

Hello everyone. Hope you are all well,

Need help and support in for following errors after using web editing via GIS feature service:

  • DBMS deadlock victim Microsoft ODBC driver 18 for SQL Server
  • The version has been redefined to reference a new database state

keep getting these errors continuously and randomly.

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 150 users.

Any thoughts and best practices will be appreciated

Tags (1)
0 Kudos
2 Replies
SaeedDaraghmeh
New Contributor

No one respond to your question, I said 'Alsalam Alaikom' 😂

0 Kudos
MarceloMarques
Esri Regular Contributor

@ahmedbadr2 - 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.

| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov
0 Kudos