Cannot create Maintenance plans - 2005 Sp3

  • Hello,

    Yesterday I updated our sql 2005 box with SP3. (9.0.4035) and then updated my client tools with SQL 2005 sp3 (9.00.4035). But now i cannot create any maintenance plans. I get the error which i attached. any hints on what it maybe? SSIS is installed and running. This was a server that I upgraded from SQL2000 to SQL 2005 RTM and then applied sp3.

    THANK YOU!!!

  • Have you seen this?

    http://www.sqlservercentral.com/Forums/Topic530866-149-1.aspx

    -Dan B

  • skrilla99 (9/28/2010)


    Have you seen this?

    http://www.sqlservercentral.com/Forums/Topic530866-149-1.aspx

    -Dan B

    Thanks, yes! I confirmed my resource version are the same. and Also the log for the hotfix shows this:

    Failed to find installation media path due to datastore exception

    in FindSetupFolder()

    MSI (s) (B4!70) [16:07:51:327]: PROPERTY CHANGE: Adding SqlInstanceName property. Its value is 'MSSQLSERVER'.

    MSI (s) (B4!70) [16:07:51:327]: PROPERTY CHANGE: Adding INSTANCENAME property. Its value is 'MSSQLSERVER'.

    MSI (s) (B4!70) [16:07:51:343]: PROPERTY CHANGE: Adding SqlClusterSec property. Its value is '0'.

    MSI (s) (B4!70) [16:07:51:343]: PROPERTY CHANGE: Adding SECURITYMODE property. Its value is 'SQL'.

    MSI (s) (B4!70) [16:07:51:343]: PROPERTY CHANGE: Adding SqlSecurityMode property. Its value is 'SQL'.

  • Check if running sysdbupg script helps. Refer this

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • Adiga (9/28/2010)


    Check if running sysdbupg script helps. Refer this

    Thanks Pradeep! I found and ran the script and i was able to create a Update Stats MP.

    But when excuting the job, i get the follow error msg in the job history after failure:

    Date9/28/2010 11:56:54 AM

    LogJob History (UpdateAllStatistics.Subplan_1)

    Step ID1

    ServerSCMSQLNEW2

    Job NameUpdateAllStatistics.Subplan_1

    Step NameSubplan_1

    Duration00:00:01

    Sql Severity0

    Sql Message ID0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted0

    Message

    Executed as user: CONTROLSVR\SQLEXECN1. Microsoft (R) SQL Server Execute Package Utility Version 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:56:54 AM Warning: 2010-09-28 11:56:55.41 Code: 0x80012017 Source: UpdateAllStatistics Description: The package path referenced an object that cannot be found: "\Package\Subplan_1.Disable". This occurs when an attempt is made to resolve a package path to an object that cannot be found. End Warning DTExec: Could not set \Package\Subplan_1.Disable value to false. Started: 11:56:54 AM Finished: 11:56:55 AM Elapsed: 0.703 seconds. The package execution failed. The step failed.

  • Now try to register the DTS.dll using regsvr32.exe.

    The path is C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • Adiga (9/28/2010)


    Now try to register the DTS.dll using regsvr32.exe.

    The path is C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll

    Thanks again!! 🙂 This fixed it!

Viewing 7 posts - 1 through 6 (of 6 total)

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