Webservices 2009, SQL Connection fail after SoapException

24. Oktober 2011 16:05

Hello

we have a BIG Problem!


The Setup

Three Tiers on three Machines. That means, that SQL Server is on different Machine than Service Tier.
Delegation is Set up und running. That's allright.

A .NET Mobile Client that consumes the service.


The Error

Say, you have a Codeunit with a Function that you publish as Webservice (registerInvoice) ok?

Somewhere in the navision code you have an ERROR("The Code yx is missing"). ok?
In this case a SoapException in the mobile client is thrown.
Good, until now we had no problem with connecting to service and sql server and do some other
consumation of nav services..

As soon as there is a soap exception (as a result of the errormessage in the nav code), the connection to sql server is not working anymore!!
EVEN IF YOU RESTART THE CLIENT.
The only thing that brings the client to connect again to sql server. is to run the url ex.(http://lpa-srv-mit-01.primevision.net:7 ... 20(Schweiz)%20AG/Codeunit/MobileDatenerfassung)of the webservice
in the browser. After that it works again?!!?


PLEASE help!

Re: Webservices 2009, SQL Connection fail after SoapExceptio

25. Oktober 2011 09:25

Hello,

do you use a try catch statement in your .Net code?


Best regards
Aydin