Cannot create Maintenance plans - 2005 Sp3

Question

Post reply

Cannot create Maintenance plans - 2005 Sp3

EL_oh_EL

Old Hand

Points: 347
More actions
September 28, 2010 at 8:01 am

#142862

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!!!

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

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

skrilla99 SSCertifiable Points: 5795 More actions · Answer 1

skrilla99

SSCertifiable

Points: 5795

September 28, 2010 at 8:20 am

#1228394

Have you seen this?

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

-Dan B

EL_oh_EL Old Hand Points: 347 More actions · Answer 2

skrilla99 (9/28/2010)

Have you seen this?

http://qa.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'.

Adiga One Orange Chip Points: 27284 More actions · Answer 3

Adiga

One Orange Chip

Points: 27284

September 28, 2010 at 9:12 am

#1228459

Check if running sysdbupg script helps. Refer this

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

EL_oh_EL Old Hand Points: 347 More actions · Answer 4

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:

Date 9/28/2010 11:56:54 AM

Log Job History (UpdateAllStatistics.Subplan_1)

Step ID 1

Server SCMSQLNEW2

Job Name UpdateAllStatistics.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

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.