NAV 2013 R2

Karlo

Hi,

I have encountered an error with my NAV 2013 R3 this past days.
the error says in the event viewer.
"A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)
"
"Fatal Sql error. The connection can no longer be used"
My initial resolution on this is restarting the instance of the NAV

Hope you can help me with this error. Thanks

RemkoD

The connection between the NST and the NAV database in MSSQL is lost. This could occur if the SQL Server is not available. For example because the SQL Server is frozen because there are no more worker-threads available or because a VM snapshot is taken. Or simply a network failure. In my experience the NST doesn't recover very well from a broken SQL connection and sometimes needs a restart to recover.

A good place to start is the Sql Logging or the Windows Event Viewer (application log) on the SQL server and NAV application server and check for suspicious errors at the time of the incident. If the issue is reoccurring the time of the incidents might give a clue.

RemkoD

The connection between the NST and the NAV database in MSSQL is lost. This could occur if the SQL Server is not available. For example because the SQL Server is frozen because there are no more worker-threads available or because a VM snapshot is taken. Or simply a network failure. In my experience the NST doesn't recover very well from a broken SQL connection and sometimes needs a restart to recover.

A good place to start is the Sql Logging or the Windows Event Viewer (application log) on the SQL server and NAV application server and check for suspicious errors at the time of the incident. If the issue is reoccurring the time of the incidents might give a clue.

Karlo

Hi RemkoD,

Thanks for the answer. NAV usually lost its connection when all of the users are accessing NAV it always happen. I just restart the instance of NAV so that the connection will resume.

I also check the event viewer to see whats the error but like what I've said in my post "Fatal Sql error. The connection can no longer be used" this is the error in the event logs. Is there any possible solution on this? Thanks.

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]