topic Re: How do I best manage database connections and locks? in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/how-do-i-best-manage-database-connections-and/m-p/136239#M5290 <HTML><HEAD></HEAD><BODY><SPAN>I use truncate and append via Arcpy to manage updates to FC's on our Amazon </SPAN><BR /><SPAN>GeoDB. Is this an option? Locks not an issue...</SPAN><BR /><BR /><SPAN>Although I'd rather SQL Server transactional replication eventually.</SPAN></BODY></HTML> Thu, 05 Dec 2013 21:13:05 GMT AlexCrothers 2013-12-05T21:13:05Z How do I best manage database connections and locks? https://community.esri.com/t5/arcgis-enterprise-questions/how-do-i-best-manage-database-connections-and/m-p/136236#M5287 <HTML><HEAD></HEAD><BODY><SPAN>I am using the geodata.sde database to store data that gets accessed by my web services.&nbsp; I have connected to it in ArcCatalog using the default "owner" account (with a new password of course) and add/manage tables and feature classes that way.</SPAN><BR /><BR /><SPAN>I am constantly getting issues where I cannot delete a feature class or table because of an existing lock by "owner".&nbsp; The only way to resolve this is to restart the entire Amazon EC2 instance.&nbsp; Restarting the ArcGIS Server instance via. the Manager doesn't work, nor does rebooting my machine.&nbsp; There are no other possible outside connections causing this lock.</SPAN><BR /><BR /><SPAN>So I'm curious about some best practices, known issues, or various solutions to making sure this doesn't keep happening.&nbsp; Any thoughts on what I might be doing wrong or what I should investigate?</SPAN></BODY></HTML> Wed, 27 Nov 2013 19:49:52 GMT https://community.esri.com/t5/arcgis-enterprise-questions/how-do-i-best-manage-database-connections-and/m-p/136236#M5287 AndrewBlakey 2013-11-27T19:49:52Z Re: How do I best manage database connections and locks? https://community.esri.com/t5/arcgis-enterprise-questions/how-do-i-best-manage-database-connections-and/m-p/136237#M5288 <HTML><HEAD></HEAD><BODY><A href="http://support.esri.com/cn/knowledgebase/techarticles/detail/34233">Set the TCPKEEPALIVE parameter to equal TRUE</A><SPAN>, to remove Orphaned gsrvr processes running on the server. </SPAN><BR /><BR /><SPAN>Use the Geodatabase Administration dialog box, to view the locks applied to the database and disconnect user(s).</SPAN></BODY></HTML> Sat, 30 Nov 2013 13:48:57 GMT https://community.esri.com/t5/arcgis-enterprise-questions/how-do-i-best-manage-database-connections-and/m-p/136237#M5288 NidhinKarthikeyan 2013-11-30T13:48:57Z Re: How do I best manage database connections and locks? https://community.esri.com/t5/arcgis-enterprise-questions/how-do-i-best-manage-database-connections-and/m-p/136238#M5289 <HTML><HEAD></HEAD><BODY><SPAN>Andrew,</SPAN><BR /><BR /><SPAN>If the data is being used by a web service, I'm curious why you would delete the data and not the service...</SPAN><BR /><BR /><SPAN>Please elaborate on your workflow.</SPAN></BODY></HTML> Mon, 02 Dec 2013 19:44:56 GMT https://community.esri.com/t5/arcgis-enterprise-questions/how-do-i-best-manage-database-connections-and/m-p/136238#M5289 KimPeter 2013-12-02T19:44:56Z Re: How do I best manage database connections and locks? https://community.esri.com/t5/arcgis-enterprise-questions/how-do-i-best-manage-database-connections-and/m-p/136239#M5290 <HTML><HEAD></HEAD><BODY><SPAN>I use truncate and append via Arcpy to manage updates to FC's on our Amazon </SPAN><BR /><SPAN>GeoDB. Is this an option? Locks not an issue...</SPAN><BR /><BR /><SPAN>Although I'd rather SQL Server transactional replication eventually.</SPAN></BODY></HTML> Thu, 05 Dec 2013 21:13:05 GMT https://community.esri.com/t5/arcgis-enterprise-questions/how-do-i-best-manage-database-connections-and/m-p/136239#M5290 AlexCrothers 2013-12-05T21:13:05Z