September 28, 2010 at 8:01 am
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!!!
September 28, 2010 at 8:20 am
September 28, 2010 at 8:32 am
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'.
September 28, 2010 at 9:12 am
Check if running sysdbupg script helps. Refer this
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 28, 2010 at 9:58 am
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.
September 28, 2010 at 10:37 am
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
September 28, 2010 at 11:38 am
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