How to solve this issue in Webservice?

Aravindh_Navision

Hi Friends,

After publishing an Page in NAV, I gave the below URL in a browser.

[url=http://]http://[/url]<Server>:7047/DynamicsNAV/WS/Nav_Company/Page/ItemTest

I am getting this error.

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
  <s:Body>
    <s:Fault>
      <faultcode xmlns:a="urn:microsoft-dynamics-schemas/error">
        a:Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideException
      </faultcode>
      <faultstring xml:lang="en-US">
        The trace flag 4616 is not set on the database server XXXXX. You must set this flag and restart the server before you can connect to the database.
      </faultstring>
      <detail>
        <string xmlns="http://schemas.microsoft.com/2003/10/Serialization/">
          The trace flag 4616 is not set on the database server XXXXX. You must set this flag and restart the server before you can connect to the database.
        </string>
      </detail>
    </s:Fault>
  </s:Body>
</s:Envelope>

Can anyone tell me how to solve this?

Thanks in advance.

postsaurav

Hi,

This is a sql server settings. Refer below article.

http://saurav-nav.blogspot.in/2011/05/trace-flag-in-sql-server-for-dynamics.html

let me know if any issues.

Aravindh_Navision

Thanks you Saurav.

What version of Microsoft SQL Server should be there? Because in my system I have Microsoft SQL Server 2008 and Microsoft SQL Server 2012. As mentioned, I have given -T4616 in the Setup Parmeters and restarted the services.

Still I am getting the same issue.... ](*,)

postsaurav

Hi,

Try Login into Navision Classic Client using the account that you are using to run web services. Let me know the findings.

Aravindh_Navision

Am using Navision Classic Client only...

postsaurav

Hi,

Did you tried login with the account with which services are running.

Suppose my services (Nav service and web service) are running with DomainName\Username.

So trying in login in with DomainName\Username.

Aravindh_Navision

Hi Saurav,

Both Nav service and web service are running with same DomainName\Username.

Still issue persists?!?!?

postsaurav

Hi Aravindh,

What i meant is Open Navision Classic or RTC Client with the DomainName\UserName used for running Services.

I think the issue is with the user and the user (used to run Services) is not a part of Navision Database OR user does not have sufficient permission.

TRY Login into Navision client with user and let me know the results.

Aravindh_Navision

Hi Saurav,

Yeah the DomainName\UserName which I am using in the services is not there in the Navision database.

Navision SQL database is in a server XXXXX. I am accessing from my local machine. I have published Page Item card. When I tried to access using the URL:

http://<Server>:7047/DynamicsNAV/WS/Nav_Company/Page/ItemTest

.. I am not getting the proper detail in the browser.

But my colleague from other system tried to access using the same URL, but he is getting the correct details.

postsaurav

Hi Aravindh,

Your colleague might be using a different service to connect to the database.

Resolution steps -

1. The User that you are using to run service should be added in Navision Database with Sufficient Rights to execute the pages that web services is using.
2. Create the user in Navision Windows Login and assign rights.
3. Synchronize the login.
3. Restart the service tier once you are done.

Now try to run the page. Hope it helps.