Getting "OLE DB provider "STREAM" for linked server "(null)" returned message "Query timeout expired"."

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Getting "OLE DB provider "STREAM" for linked...

Getting "OLE DB provider "STREAM" for linked server "(null)" returned message "Query timeout expired"."

Rate Topic

Display Mode

Topic Options

Author

Message

Arshad Ali-556241

Posted Friday, April 16, 2010 2:26 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:41 AM
Points: 64, Visits: 179

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

Mike in Minn

Posted Wednesday, May 12, 2010 9:17 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 19, 2012 7:46 AM
Points: 2, Visits: 115

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

Arshad Ali-556241

Posted Wednesday, May 12, 2010 11:49 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:41 AM
Points: 64, Visits: 179

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 »

Permissions