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 12»»

"Query timeout expired" Expand / Collapse
Author
Message
Posted Monday, November 1, 2010 9:00 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, March 17, 2014 2:54 PM
Points: 95, Visits: 188
Hi, ALL
CAN SOME TELL ME WHATS GOING ON HERE OR ANY SUGGESTIONS

OLE DB provider "SQLNCLI" for linked server "TFSQL04" returned message "Query timeout expired".
Msg 7399, Level 16, State 1, Procedure reportTecsysReconciliation, Line 34
The OLE DB provider "SQLNCLI" for linked server "TFSQL04" reported an error. Execution terminated by the provider because a resource limit was reached.
Msg 7421, Level 16, State 2, Procedure reportTecsysReconciliation, Line 34
Cannot fetch the rowset from OLE DB provider "SQLNCLI" for linked server "TFSQL04". .

THANKS FOR LOOKING INTO IT
Post #1013879
Posted Monday, November 1, 2010 9:27 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 6:14 AM
Points: 1,200, Visits: 3,237
@ harita

When do you get this error, while running a proc?
Can you check if your sql services are running?
Or see errors in sql logs?

Regards,
Sushant
Post #1013900
Posted Monday, November 1, 2010 9:32 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, March 17, 2014 2:54 PM
Points: 95, Visits: 188
Hi,
i am getting this error when i run a stored pro
Post #1013904
Posted Monday, November 1, 2010 9:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 6:14 AM
Points: 1,200, Visits: 3,237
@ harita

You need to increase the remote query timeout option in SSMS
SSMS-->prop-->connections-->remote qery timeout--> wats the value??

Regards,
Sushant
Post #1013905
Posted Monday, November 1, 2010 9:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, March 17, 2014 2:54 PM
Points: 95, Visits: 188
i think the value is 0
Post #1013913
Posted Monday, November 1, 2010 9:50 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, March 17, 2014 2:54 PM
Points: 95, Visits: 188
i didnt understand the path
SSMS-->prop-->connections-->remote qery timeout--> wats the value??
can you be more specific
Post #1013916
Posted Monday, November 1, 2010 9:51 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 6:14 AM
Points: 1,200, Visits: 3,237
which sql server version are you running?
Post #1013919
Posted Monday, November 1, 2010 9:52 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, March 17, 2014 2:54 PM
Points: 95, Visits: 188
ya i found it teh remote query timeout is 600
Post #1013920
Posted Monday, November 1, 2010 9:54 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 6:14 AM
Points: 1,200, Visits: 3,237
change it to 0 and then again run the stored proc

Regards,
Sushant
Post #1013922
Posted Monday, November 1, 2010 10:11 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, March 17, 2014 2:54 PM
Points: 95, Visits: 188
yes i did change it to 0 , but can you explain me whats going on here, we run this report every moth and never had this problem but y now
Post #1013932
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse