We are struggling with a problem where the IIS application pool crashes while being accessed by Web Services provided by Microsoft Dynamics GP. This occurs while attempting to access the customer database but it does not occur if the sample database is used. Apparently a relatively new interface the v9.0 Dynamics GP Web Service is causing even Dynamics GP support professionals to be mystified. Does anybody out there know what might cause this and how to solve the problem. We have seen information on the net that the problem has never been solved. We have completely recreated the issue on a totally different machine. The database is based on the version of SQL Server prior to 2005.
Event Type: Error Event Source: EMRWebServicesGateway Event Category: None Event ID: 0 Date: 6/26/2007 Time: 11:53:55 PM User: N/A Computer: ECAHQDOM1 Description: The description for Event ID ( 0 ) in Source ( EMRWebServicesGateway ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Unsuccessful sending test GL Transaction. System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags) at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) --- End of inner exception stack trace --- at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) at System.Net.PooledStream.Read(Byte[] buffer, Int32 offset, Int32 size) at System.Net.Connection.SyncRead(HttpWebRequest request, Boolean userRetrievedStream, Boolean probeRead) --- End of inner exception stack trace --- at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request) at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at DynamicsGP.CreateGLTransaction(GLTransaction glTransaction, Context Context, Policy policy) at EMRGatewayService.CreateGLTransactionTest(Int32 nCompanyID, String strBatchID, Int32 nJournalID, String strCreditAccount, String strDebitAccount).
One Change the App pool to .net v 1.4xxx. You can do this by going into IIS admin console on the website on the gateway for GP in IIS. Right click on it, and go to properties, and then ASP.net tab, and then select the ASP 1.1.4332 ( I recently installed CRM 3.0, and it would not work with CRM 3 with ASP.net 2, which is why im suggesting this.)
Thanks all. It turns out that the multi-currency setting was not set to anything. That being said we have determined that the Dynamics GP error reporting is not advising of errors like this. It appears that the GP Web Services are in the early versions where some of the robustness is yet to be reached through field validation.
