NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Stu on March 31, 2014, 08:28:42 PM

Title: SQL Record Retrieval Error, SMuX Provider: Physical connection is not usable
Post by: Stu on March 31, 2014, 08:28:42 PM
Hey Folks,

Just wondering if anyone has seen anything like this! (the picture shows)

Basically I've been running my couple of nettalk webservers as exes in the day to try and track down a couple of errors that seem to occur under heavy usage.

So yesterday I get a phonecall, "the system is broken! nothing saves!" .. Flick over to the RDC and see this (attached).

--

Record Retrieval Error

Error: (SMuX Provider: Physical connection is not usable.
Unable to open a logical session (08S02)) attempting to access a record from
the dbo.<filename> file. Returning to previous window.

--

Then there's also a sql connection message window.

Have googled a bit, but having trouble understanding just what happened.

Just wondering if anyone has come across this in their travels?

[attachment deleted by admin]
Title: Re: SQL Record Retrieval Error, SMuX Provider: Physical connection is not usable
Post by: osquiabro on April 01, 2014, 02:21:37 AM
is a virtual server VM??
Title: Re: SQL Record Retrieval Error, SMuX Provider: Physical connection is not usable
Post by: Bruce on April 01, 2014, 03:03:56 AM
check out the SQL threads in the Share Knowledge forum for tips on MARS, busy Handling and so on.
Title: Re: SQL Record Retrieval Error, SMuX Provider: Physical connection is not usable
Post by: Stu on April 01, 2014, 01:18:18 PM
Bruce! You're supposed to be away. Go home!

Ahem.

Thanks, yeah. Have gone over the MARS stuff a few times, and that seems to be working fine. This was such a wierd one-off thing (never seen it before), for a file that is used so regularly (like thousands of times a day) that it made me wonder if it wasn't something bigger than just the file.

Anyway. Will investigate some more.