HELP!!! Resource limit was reached

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

HELP!!! Resource limit was reached

Author

Topic

mufasa
Yak Posting Veteran

62 Posts

Posted - 2006-03-09 : 15:34:35

Can anyone explain how to get rid of this error?

The table I am reading from has over 12 million records, I am trying to update my table with only the last 4 weeks, about 60k records.

Thanks
Error
Server: Msg 7399, Level 16, State 1, Line 5
OLE DB provider 'SQLOLEDB' reported an error. Execution terminated by the provider because a resource limit was reached.
[OLE/DB provider returned message: Timeout expired]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned 0x80040e31: Execution terminated by the provider because a resource limit was reached.].

statement:

delete dbo.DYDFIL
FROM dbo.DYDFIL INNER JOIN
dbo.[This Year Last Year1] ON dbo.DYDFIL.dyd_date >= dbo.[This Year Last Year1].[4WKCivil]

insert into DYDFIL
SELECT TOP 100 PERCENT RIGHT('000000' + RTRIM(CONVERT(CHAR(15), DYDFIL.dyd_emp_code)), 6) AS EmpCode, DYDFIL.*
FROM [CANMTLSQL03].MEXX.dbo.DYDFIL DYDFIL INNER JOIN
dbo.[This Year Last Year1] ON DYDFIL.dyd_date >= dbo.[This Year Last Year1].[4WKCivil]

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-03-09 : 15:36:11

You need to increase your timeout value in your connection string. If this is a one time update, then just do it in Query Analyzer where no timeout exists by default.

Tara Kizer
aka tduggan

mufasa
Yak Posting Veteran

62 Posts

Posted - 2006-03-09 : 15:51:21

Tried that, still got this error

Server: Msg 7399, Level 16, State 1, Line 5
OLE DB provider 'SQLOLEDB' reported an error. Execution terminated by the provider because a resource limit was reached.
[OLE/DB provider returned message: Timeout expired]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned 0x80040e31: Execution terminated by the provider because a resource limit was reached.].

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-03-09 : 15:54:50

Then you need to increase the timeout value even more.

Tara Kizer
aka tduggan

mufasa
Yak Posting Veteran

62 Posts

Posted - 2006-03-09 : 17:06:01

There is no time-out, it is unlimited
Under futher investigation, it seems that a backup was running for 16 hours, which is causeing other programs that use the database to time out.

This is a new crinkle in the problem, but it seems that it is cause as well

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources