Solved

Execution terminated by the provider because a resource limit was reached

Posted on 2011-03-16
2
1,309 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 500 total points
ID: 35151315
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

632 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