Webservices 2009, SQL Connection fail afterSoapException

primeap
Member Posts: 37
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!
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!
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions