How to solve this issue in Webservice?

Aravindh_Navision · 2014-10-16

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 · 2014-10-16

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 · 2014-10-16

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 · 2014-10-16

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 · 2014-10-16

Am using Navision Classic Client only...

postsaurav · 2014-10-16

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 · 2014-10-17

Hi Saurav,

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

Still issue persists?!?!?

postsaurav · 2014-10-17

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 · 2014-10-20

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 · 2014-10-20

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.

How to solve this issue in Webservice?

Comments

Categories