Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Getting "OLE DB provider "STREAM" for linked server "(null)" returned message "Query timeout expired"." Expand / Collapse
Author
Message
Posted Friday, April 16, 2010 2:26 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, March 20, 2014 9:08 AM
Points: 64, Visits: 188
Hi,

We have two servers, backend and frontend. Frontend server has all the data and transformation logics in SSIS (METaL system) and we are executing it from backend server. We have set up linked server across SQL Servers and set Query time property to 0. When we execute this application it works fine for small set of data and completes in 4-5 minutes but starts failing if we run it for huge data set which takes somewhere around 11-12 minutes.

OLE DB provider "STREAM" for linked server "(null)" returned message "Query timeout expired".
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.


Please help us, it’s becoming a bit critical for us. Thanks in advance.


With Thanks and Regards
Arshad Ali
Microsoft India

My Blog - http://arshadali.blogspot.com/
Post #905199
Posted Wednesday, May 12, 2010 9:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 06, 2013 2:43 PM
Points: 2, Visits: 118
Did you get an answer to your problem? We got the same error last night using a linked server. We are looking at increasing the remote_query_timeout setting in SP_configure.
Post #920593
Posted Wednesday, May 12, 2010 11:49 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, March 20, 2014 9:08 AM
Points: 64, Visits: 188
Yes we resolved it by changing the default value.

Right click on Server in Object Explorer of SSMS, then click on Properties, go to Connection page and change the Remote-Query timeout setting to something more as per your need from 600. You can also specify 0 if you want "no timeout" setting.


With Thanks and Regards
Arshad Ali
Microsoft India

My Blog - http://arshadali.blogspot.com/
Post #920746
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse