topic Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit in Data Management Questions

SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

RandyKreuziger — Tue, 04 May 2010 16:35:38 GMT

We have just set up 2 new SQL Server servers and both are experiencing the same problem. On each server the ArcSDE instances fail to start after a reboot. If I login I can start them manually with no problems. The SDE services are dependent on the SQL (named instance) and try to start immediately after the SQL Server Agent which has the same dependency. But SDE is trying to restart before all the databases have started. Only Master and Model have started with SDE tries to start.

It looks like I found a workaround for now by setting the SDE instances to a startup type of "Automatic (Delayed Start)." Has anyone else come across this problem?

sde_esri_sde_GeoScrtach.log:
-------------------------------------------------------
ArcSDE 9.3.1 for SQL Server Build 2785 Mon Dec 21 12:03:03 2009
-------------------------------------------------------
IDBInitialize::Initialize Failed
init_DB DB_instance_open_as_dba: -93
DBMS error code: 18456
Microsoft SQL Server Native Client 10.0: Login failed for user 'sde'.

Event Viewer Application Log:
Login failed for user 'sde'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]

ArcSDE 9.3.1 (SP1)
SQL 2008 64-bit (SP1)
Windows Server 2008 R2

Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

DaveWatson — Mon, 19 Jul 2010 17:24:52 GMT

I switched the Startup Type in the services to Automatic (Delayed Start) it resolved the problem for us.

Thanks,

Dave

Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

RandyKreuziger — Mon, 19 Jul 2010 17:31:22 GMT

Dave,
Thank you. I'm glad to see that option in Windows. ESRI was not able to determine why a hand full of sites are having this problem. It may be on the SQL side or Windows server.

Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

HectorSanchez — Wed, 01 Sep 2010 19:54:43 GMT

When you start you 'comand prompt', run it as an Administrator (righ click the 'comand prompt' icon). Try again starting the service with 'sdemon -o start -i port'.

Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

RandyKreuziger — Wed, 01 Sep 2010 23:16:02 GMT

Thanks, but it does start. It just won't start until SQL Server is fully up. The SDE services are dependent on SQL Server service but SQL seems to be declaring itself up before all the databases have come online. So when SDE tries to start it can't get everything it needs from SQL Server.

Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

RandyKreuziger — Mon, 24 Jan 2011 16:35:13 GMT

ESRI tried to reproduce our issue by reproducing our environment but couldn't. They asked us to send a VM of our system but we had problems exporting the VM. To their credit ESRI spent at least a few staff weeks trying to help us. So we are still doing the "Automatic (Delayed Start)" workaround. The tech did say that we weren't the only ones reporting the problem but that they still couldn't reproduce it.

Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

ReginaDaas — Mon, 24 Jan 2011 16:55:52 GMT

Did anyone experience this issue on a physical server vs a virtual server? We are are a virtural server SQL 2008 R2 Win2008 R2 and SDE v10 (no service packs or hotfixes) and we have this issue. I changed the service to automatic with delay and it's resolved........for now. But could this issue emerge again and our db grows and load increases?????
Thank You for the post

Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

RandyKreuziger — Mon, 24 Jan 2011 17:06:35 GMT

Ours in a physical server. What ESRI wanted us to do is do a P2V or physical to virtual so we could send them the P2V and they could restore it on their side. I hope that clears things up.

Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

GerryBelanger — Thu, 07 Apr 2011 18:27:21 GMT

We experience this both in VM and Physical servers with the following configurations.

Server 2008, SQL 2008 R2 with ArcSDE 10
Server 2008 R2, SQL 2008 R2 with ArcSDE 10

Server 2008, SQL 2008 R2 with ArcSDE 10 SP1
Server 2008 R2, SQL 2008 R2 with ArcSDE 10 SP1

Anyone else find a solution other than automatic (delay)?

Thanks.

Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

AdrianaRangel_Sotter — Wed, 27 Apr 2011 13:33:08 GMT

We experience this problem in VM servers with the following configurations.

Windows Server 2003, SQL 2008 R2 with ArcSDE 10 SP1

Anyone else find a solution other than automatic (delay), this option isn't available in Windows 2003?

Thanks.

Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

TimWood — Thu, 19 May 2011 08:39:03 GMT

We are also having this problem with 64-bit ArcSDE 9.3.1 SP2 on 64-bit SQL Server 2008 R2 and 64-bit Windows Server 2008 R2. I will set the ArcSDE Services to "delayed start" but it would be nice to find out what the cause of this problem is.
<p>
Our ArcSDE server is running single database model geodatabases (i.e. no sde database) which were setup on 64-bit Windows Server 2003 with 64-bit SQL Server 2005 and 64-bit ArcSDE 9.3. However, we also set up a new geodatabase on 9.3.1 and that also suffers the same problem.

Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

DimitarKolev — Thu, 02 Jun 2011 12:49:58 GMT

We are having the same issue on Win Server 2003 Standard SP2 (32 bit), SQL 2008 Enterprise (Version 10.0.4000.0)
The SDE services won't start after restarting the server.
I suspect the SDE services also stop when not used for prolonged time (over the weekend for example), but I am not 100% sure on that.

My question is, Is it possible to automate the checking and starting of failed SDE services?

Example:
Create a Python Script (or batch file) which will run let's say every 5 minutes and
- check if the SDE dependant services (SQL Server) are running and start them if they are stopped.
- check if the SDE services are started and start them if they are not.

Please provide sample or guidance how to implement such automation, if possible.

Thanks

Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

VinceAngelo — Thu, 02 Jun 2011 12:58:21 GMT

The ArcSDE application server does not stop when unused. I've found that it can be sluggish
to respond initially when unused for months, but that's more a factor of the database itself
having been swapped out.

- V

Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

TraceyLeet — Mon, 27 Jun 2011 10:51:26 GMT

Our SDE server is running Windows 2003 (32 bit, as well as SQL Server 2005) and 'Automatic delayed start' is not an option for us on our services. ESRI suggested created a batch file to restart your service(s) and then created a scheduled task on your SDE server that runs this batch file 'at system startup'. By the time this schedule task runs at startup your database will already be up and running. Seems to solve the issue for us.

Re: SDE Instances won't start after server reboot. SDE 9.3.1 - SLQ 2008 64-bit

Anonymous User — Mon, 16 Nov 2020 20:06:28 GMT

On page 67 of the ArcGIS 9 Managing ArcSDE: Application Servers book, it says, "If the system administrator account is not being used to start the service, make sure the user is a member of the administrator power group."

The way I fixed this problem on our legacy server was to have the service run as the Administrator on the local box, rather than the Local Service Account option. When I did that, I got a dialog message that Administrator was then being granted login privileges. Despite that, when I restarted the server, ArcSDE ran automatically like I had hoped. I believe that the reason that people are able to start the service when they're logged in is because they're logging in with an account with administrative privileges before starting the service

Now, our service has a few nuances. For instance, arcsde isn't really the name of our service--we customized it. And, we don't use a database called sde, we renamed it something else, and then set the SDE_ADMIN_DATABASE configuration parameter to that name. But we modified etc\services like we were supposed to, and services.sde, and added %SDEHOME% to %PATH%, yet none of those things made ArcSDE start automatically, successfully, after server reboot.