Report Giving TCP_Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Report Giving TCP_Error

Author

Topic

muzaffar_ali99
Starting Member

33 Posts

Posted - 2012-01-21 : 00:07:05

When i generate simple reports mean that take less time to generate they are generated fine, but when i generate the longer reports it throws me attached error, in SSRS 2005 it was not giving that error, we converted rports from SSRS 2005 to 2008 and to new amazon server, i have searched and set lot of options but did not seem to work.

Any help is appreciated.

Thanks
Muzaffar Ali

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-01-21 : 07:12:16

quote:
...it throws me attached error,

If you have attached a screen shot, I can't see it (and I am not behind any firewall at the moment). Can you include the text of the exact error message you are seeing?

muzaffar_ali99
Starting Member

33 Posts

Posted - 2012-01-23 : 00:09:57

Problem Report: There was a communication problem

Message ID: TCP_Error

Problem Description: The system was unable to communicate with server.

Possible Problem cause: The server may be down

The server may too busy

Problem Solution: try connecting server later

SOrry image was not showing now i have written the error message

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-01-23 : 08:03:24

Because simpler reports are running properly and reports that require more processing time are failing, I am suspecting that it may be timeout issue on connection and/or command.

First, if at all possible, run the queries that drive the reports from an SSMS query window to see if they are running correctly and how much time those queries take.

Second, (and I am stepping outside my comfort zone because of my less than stellar familiarity with SSRS, so take this for what it is worth), SSRS has various timeout settings which you can read about here http://msdn.microsoft.com/en-us/library/ms157273.aspx A link on that page also describes how to modify those. BUT if you choose to do that, be very careful, test it on a development server etc.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources