web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Navision client users ...
Microsoft Dynamics NAV (Archived)

Navision client users getting this error

(0) ShareShare
ReportReport
Posted on by Community Member

Hi

Our navision clients uses keeping getting this error like 5 times a day.

" A transport-level error has occurred when sending the request to the server. (provider: Session Provider, error: 19 - Physical connection is not usable"

 

The server is a vm and there is not hardware or connectivity to the server like folders.

Please help.

Thank you.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Have you checked Event Viewer?

    Is there any setup (SQL, NAV), which might be killing the Ideal session after particular timing?

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    It sounds like an SQL problem and might be because of SQL server has run into exception. In some cases it might be because there is some abnormal data in some record in a table. First, you need to understand with what tables users are trying to operate when they get this error, and then troubleshoot the records for weird data in the fields.

  • Community Member Profile Picture
    Community Member on at

    This happen after we have installed jet report. Our system integrator however say they only change sql authentication to window authentication only.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    This could not be due to Jet Reporting.

    This could be due to network protocol (or may be drop) or some background process enabled which is killing NAV Ideal sessions (from NAV or SQL).

    Is there any change in Network Settings or Anti-Virus or Firewall related setups?

    Do you see any message in Event Viewer?

  • Community Member Profile Picture
    Community Member on at

    This is from the event viewer.

    I do not think i from the anti virus or fireall as i is working.

    It seem like running in dministrator, I do noencounter this issue, an it be related to sql permission?

    ====

    Server instance: DynamicsNAV71

    Tenant ID: default

    Session type: RoleTailoredClient

    Session ID: 32

    Fatal Sql error. The connection can no longer be used

    ===

    Server instance: DynamicsNAV71

    Tenant ID: default

    Session type: RoleTailoredClient

    Session ID: 32

    User: ERNI-ASIA\khoo

    Type: System.Data.SqlClient.SqlException

    ClientConnectionId: 148a3124-e44e-4111-9b5a-8c007ecd488f

    Class: 20

    LineNumber: 0

    Number: -1

    Server: EASGSQL01\ERNI_SG_SQL

    State: 0

    Source: .Net SqlClient Data Provider

    ErrorCode: -2146232060

    Message: A transport-level error has occurred when sending the request to the server. (provider: Session Provider, error: 19 - Physical connection is not usable)

    StackTrace:

        at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc, Boolean sync, TaskCompletionSource`1 completion, Int32 startRpc, Int32 startParam)

        at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)

        at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

        at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

        at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

        at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

        at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteFunction[T](Func`1 function, NavSqlCommand command)

    HResult: -2146232060

    ===

    ===

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    Have you run through this troubleshooting guide?

    msdn.microsoft.com/.../jj551773(v=nav.90).aspx

    This also might be related to permissions. Check this good post:

    saurav-nav.blogspot.ru/.../error-after-restore-sql-backup-of-nav.html

    Also, there might be still issues with the data (e.g., duplicate unique keys in the records).

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Thanks Alexander.

    This solution solve the issues. The error message causes confusion as it easily blames on network, tables but it is actually a configuration issue.

  • Community Member Profile Picture
    Community Member on at

    I thought this error is not related to your Microsoft Dynamics NAV but the infra you deployed.

    please check it with your network Admin

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Ashutosh

    Thanks for your reply.

    The error has nothing to do with network or processor or ram. The configuration under sql security, uer mappings solve the issue. that is to say, give the service that run the sql at least read,write admin. For example, if you run sql service under network services, give network services the rights on reader, write and admin as show by Alexander (accepted answer) ., After that restart both sql and navision services.  

    The  error has nothing to do with network issues, nothing at all. It i the most misleading error.

  • Community Member Profile Picture
    Community Member on at

    My "service user" is dbo.. and I get those transport-level errors.
    So it's not (only) a user permission problem.
    KR

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans