Rebuild Index Error

  • Since upgrading to SP2, we have been receiving the following error message when running our rebuild indexes job:

    Description: The Execute method on the task returned error code 0x8007000E (Exception of type 'System.OutOfMemoryException' was thrown.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:00:00 AM Finished: 1:42:26 AM Elapsed: 2545.73 seconds. The package execution failed. The step failed.

    Does anyone know how to get the job to complete successfully?  This job used to work prior to SP2. I've also deleted the job & recreated it, but that didn't help any.  Thank you for any advice.

  • Did you ever find out what was happening here?  I am having the same problem.


  • No, I haven't figured out the error message.  I just scripted the index rebuild job instead.

  • It might be the memory leak, a problem Microsoft is facing for a long time. Here are some links for your references.

    It seems that Microsoft does not have a good solution for it at this moment.

  • I have gotten this error ever since upgrading to 3159, and it only occurs when i try and run a maintenance task for and integrity check.


  • I am having the exact same problem. We have a database maintenance plan with 1 task in it named "Check Database Integrity Task". Task details: Connection = Local server connection, Database(s): Specific databases (I only have master checked), include indexes is unchecked. When I right click on the plan and click Execute, the plan fails. If I right click on the plan and click View History, it displays the information: Server FH_SQL\Veritas, Task detail: Check Database integrity on Local server connection Databases: master, Error number: 0, Error message: Alter failed for Server 'FH_SQL\\Veritas'. I do not know why this message displays the double '\\' for the named instance, and this may be part of the problem with the job failing. I have also checked "Reporting & logging option" and here are the details:


    Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3042

    Report was generated on "FH_SQL\Veritas".

    Maintenance Plan: MaintenancePlan Integrity Check Test

    Duration: 00:00:00

    Status: Warning: One or more tasks failed..


    Check Database Integrity (FH_SQL\Veritas)

    Check Database integrity on Local server connection

    Databases: master

    Task start: 2008-07-28T10:00:54.

    Task end: 2008-07-28T10:00:54.

    FailedSad0) Alter failed for Server 'FH_SQL\\Veritas'.

    Please let me know what you think and thank you!

    Also, The last thing I did on the server was to move tempdb to another drive and I also changed the accounts that SQL server runs under. The SQL server and SQL server agent were localsystem and they are now different domain accounts.

  • Here are the Job History details:

    Date 7/28/2008 10:00:53 AM

    Log Job History (MaintenancePlan Integrity Check Test.Subplan_1)

    Step ID 1


    Job Name MaintenancePlan Integrity Check Test.Subplan_1

    Step Name Subplan_1

    Duration 00:00:01

    Sql Severity 0

    Sql Message ID 0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted 0


    Executed as user: TROTTLAW\fh_veritas_agent. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:00:53 AM Progress: 2008-07-28 10:00:54.14 Source: {F1D53ECB-F1F2-46E5-841D-6388CE3E8A3C} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:00:53 AM Finished: 10:00:54 AM Elapsed: 1.563 seconds. The package execution failed. The step failed.

  • I still received this error after installing the critical update for SQL 2005 SP2. I found another article from MS that suggested running the below script, after running it the Maintenance Plan ran without errors:

    sp_configure 'allow updates', 0

    reconfigure with override

  • Thank you this solution works for me .

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply