The record is not open

eYeeYe Member Posts: 168
edited 2011-09-07 in NAV Three Tier
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:
    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

Answers

  • eYeeYe Member Posts: 168
    Found the issue. It was related to code using record references. ](*,)

    So a more apt question is, how to debug WS?
    Kind Regards,
    Ewald Venter
  • kinekine Member Posts: 12,562
    You can debug WS in same way as RTC. Just look for "Debugging RTC".
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.