Share via

Error resource limit was reached

  • Article
  • 05/17/2013

Question

Friday, May 17, 2013 6:17 AM

Hi All,

My sql job fails today and it throws an error at step 28 the error was 

Message
Executed as user: NT AUTHORITY\SYSTEM. The OLE DB provider "SQLNCLI" for linked server "hrpldb" reported an error. Execution terminated by the provider because a resource limit was reached. [SQLSTATE 42000] (Error 7399)  Cannot fetch the rowset from OLE DB provider "SQLNCLI" for linked server "hrpldb". . [SQLSTATE 42000] (Error 7421)  OLE DB provider "SQLNCLI" for linked server "hrpldb" returned message "Query timeout expired". [SQLSTATE 01000] (Error 7412).  The step failed.

why this happened and to resolve this what are the steps need to be follow?

Need help

Regards,

Mahesh

All replies (2)

Friday, May 17, 2013 6:40 AM ✅Answered | 1 vote

I did not face this problem. But now found a url, it may solve your problem.

http://support.microsoft.com/kb/314530

Srinivasan

Friday, May 17, 2013 8:14 AM

By the default timeout for linked-server queries is 10 minutes, which quite some long time.

There are basically two possible reasons: blocking on the remote server, or the query running on the remote server simply took that long time to execute.

Without any knowledge of what the job does etc, it is impossible to give more detailed suggestions.

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se