Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
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