question

HamedVaziri-4770 avatar image
0 Votes"
HamedVaziri-4770 asked SQLZealots commented

Sql Server Error : A transport-level error has occurred when receiving results from the server ...

Hi
In my sql server 2014 ssms i've run a simple query like this :
select * from Diet_PatientDetails

but i'm facing this error, during running my query :
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

All other tables works correctly, but when i select from this table, i'm facing the given error!
Where is my problem & how to solve it?
Thanks in advance

sql-server-generalsql-server-transact-sql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Is Diet_PatientDetails a table or synonym that refers different server object ?
Or whats the object type of Diet_PatientDetails?

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @HamedVaziri-4770,

In addition, please check if there is any corruption in the database. You can use DBCC CHECKDB to check.
If there are any error is reported by DBCC CHECKDB, it is recommended to restore the database from the last known good backup. If this happens to be no good backup, then you have to use the repair option with DBCC CHECKDB after the database placed in emergency mode.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered HamedVaziri-4770 commented

The first thing I would do is to look in the SQL Server errorlog to see if there are any messages which seem to correlate with this error. Actually, I think that before we venture into other speculations, we should see the errorlog.

· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks ErlandSommarskog
I've check out event-viewer and see this error on sql server :

A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated.

0 Votes 0 ·

So, are you using READ UNCOMMITTED, a.k.a NOLOCK?

I assume that the table has a LOB column of some sort?

0 Votes 0 ·

I don't know!
this database is for our customer & we are working to convert it's data into new database!
Would u plz help me how to work-around this problem?
Thanks in advance

0 Votes 0 ·
Show more comments

Hi again
Any help?

0 Votes 0 ·

Did you reproduce the problem after restarting SSMS and using some modified queries, such as ‘SELECT TOP(10) *…’ or ‘SELECT column…’ instead of ‘SELECT *’?


0 Votes 0 ·