Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Execution terminated by the provider because a resource limit was reached

Posted on 2011-03-16
2
Medium Priority
?
1,330 Views
Last Modified: 2012-05-11
hi experts, ia heve this error:
Executed as user: PDCVIDA\SQLServerAccount. OLE DB provider 'SQLOLEDB' reported an error. Execution terminated by the provider because a resource limit was reached. [SQLSTATE 42000] (Error 7399)   [SQLSTATE 01000] (Error 7312)  OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned 0x80040e31:  Execution terminated by the provider because a resource limit was reached.]. [SQLSTATE 01000] (Error 7300).  The step failed.

Date        14/03/2011 10:34:58 a.m.
Log         Job History (Proceso XXXX)
Step ID           2
Server            PVIDA18\SQL2000
Job Name          Proceso de Solicitudes Pendientes y CoberturasPendientes
Step Name         CoberturasPendientes
Duration          00:10:02
Sql Severity            16
Sql Message ID          7300
Operator Emailed        
Operator Net sent      
Operator Paged          
Retries Attempted       0
pfvERROR.jpg
0
Comment
Question by:enrique_aeo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35151285
What this failing job step is resposible of?
0
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 2000 total points
ID: 35151315
0

Featured Post

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question