Uncategorized

GP Web Services (the dreaded “Handle is Invalid” error)

Currently, if GP Web Services loses connection to its SQL Security store (the dreaded “Handle is Invalid” error), GP Web Services continues to retry indefinitely. The Service is in a ha…

Source: GP Web Services (the dreaded “Handle is Invalid” error)

Advertisements
Standard
Dynamics GP

GP Web Services (the dreaded “Handle is Invalid” error)

Currently, if GP Web Services loses connection to its SQL Security store (the dreaded “Handle is Invalid” error), GP Web Services continues to retry indefinitely. The Service is in a halfway state, saying it is “running”, but it will not ever reconnect, nor will it shutdown normally. This error has been reported since at least GP 10. We are on GP 2013 R2. It is not fixed in GP 2016.

  • The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
  • The handle is invalid. (Exception from HRESULT: 0x80070006 (E_HANDLE))

Microsoft’s Scripted Answer

Many past reports of this issue are closed by Microsoft because it “Must be” the user’s network dropping the connection. However, at least in our environment, we have definitively proved that this is not the case, and I suspect the same in many other past reports as well. There are some indications that it may be related to the count of messages in the Dynamics..WSExceptionLog. Brief references from Microsoft, but no details, to a known “1024” bug. SELECT Count(*) FROM Dynamics..WSExceptionLog

“…If my cell phone drops connection in a tunnel, I don’t have to reboot my phone on the other end. Not even a Windows phone.”

Reconnect automatically or allow it to close gracefully

The best solution is to reconnect. An alternate would be to have it gracefully close after losing connection. It’s the halfway state that really messes things up. Right now the Service still shows “running” even after the “handle” errors start. A standard Net Stop will not work, and Taskkill is needed to stop it.

  • C:\Windows\system32>C:\Windows\system32>Net Stop DynGPWebService
  •  The service could not be controlled in its present state.

If the “Microsoft Dynamics GP Service Host” service died gracefully, the Windows “Recovery” feature could take care of the restart.

***

Please Vote!

https://connect.microsoft.com/dynamicssuggestions/feedbackdetail/view/2771628/gp-web-services-must-reconnect-automatically-on-loss-of-connection-to-sql-backend

David Morinello – Senior Dynamics GP Systems Architect
Ascend Learning
Leawood, Kansas 66211

 

 

Standard