The record is not open
eYe
Member Posts: 169
I am sitting with a Windows Server 2008 R2, SQL Server 2008 R2 and installed NAV2009 SP1 Web Services.
Have a different server with Windows Server 2008 and SQL Server 2008.
Same configuration for WS on both servers, it runs on the same service accounts (domain accounts). Both SQL instances also use the same service accounts.
Using a copy of the same db on the 2 servers.
Opening the url: http://servername:port/DynamicsNAV/WS/Services I can see the exposed Web Services.
Opening the url: http://servername:port/DynamicsNAV/WS/companyname/Codeunit/servicename I can see the functions that the Web Service exposes.
The following successfully returns the list of companies:
Upon calling WorldTest (a simple function that returns "Hello World!"), I get the error: "The record is not open"
However on the second server all works fine. I have seen that UAC might cause this issue and turned it off, but no success.
Kind Regards
Have a different server with Windows Server 2008 and SQL Server 2008.
Same configuration for WS on both servers, it runs on the same service accounts (domain accounts). Both SQL instances also use the same service accounts.
Using a copy of the same db on the 2 servers.
Opening the url: http://servername:port/DynamicsNAV/WS/Services I can see the exposed Web Services.
Opening the url: http://servername:port/DynamicsNAV/WS/companyname/Codeunit/servicename I can see the functions that the Web Service exposes.
The following successfully returns the list of companies:
MyRef.Url = "http://servername:port/DynamicsNAV/WS/SystemService"
MyRef.UseDefaultCredentials = True
companylist = MyRef.Companies()
Upon calling WorldTest (a simple function that returns "Hello World!"), I get the error: "The record is not open"
Dim WService As New WSRef.WorldService
Try
WService.UseDefaultCredentials = True
MsgBox(WService.WorldTest())
Catch ex As Exception
MsgBox(ex.Message)
End Try
However on the second server all works fine. I have seen that UAC might cause this issue and turned it off, but no success.
Kind Regards
Kind Regards,
Ewald Venter
Ewald Venter
0
Answers
-
Found the issue. It was related to code using record references. ](*,)
So a more apt question is, how to debug WS?Kind Regards,
Ewald Venter0 -
You can debug WS in same way as RTC. Just look for "Debugging RTC".0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
