Friday, February 10, 2012

Cannot find folder "\Maintenance Plans".

I've been looking for treads with a possible similar problem but thus far nothing.

I recently upgraded SQL 2000 (STD ed.) instance to SQL 2005 (STD ed.).

This includes the db's. All their compatibility levels were changed to level 90 (SQL 2005).

Everything seems to be working fine but when trying to migrate a legacy maintenance plan I keep getting the message, "Cannot find folder "\Maintenance Plans"." even though the folder is clearly listed.

Not sure where to start. I have created two virtual images and both have the same problem.

Any help would be greatly appreciated.

RoviWil

I still can't find anyone who had this problem and yet I got it in multiple tests.

I did however manage to use a workaround by means of system sp's.

I used SQL Profiler.

Verify that the folder is missing:
exec sp_executesql N'exec [msdb].[dbo].[sp_dts_getfolder] @.P1, @.P2',N'@.P1 nvarchar(17),@.P2 uniqueidentifier',N'Maintenance Plans','00000000-0000-0000-0000-000000000000'

Add the folder if missing:
exec sp_dts_addfolder '00000000-0000-0000-0000-000000000000','Maintenance Plans','08AA12D5-8F98-4DAB-A4FC-980B150A5DC8'

|||You for got to mention that you must do these commands from the using the msdb database. Took me 45 minutes to figure it out. I thought thier was a problem with the upgrade of my database so I compared all of the objects in a known good 2005 database to the converted one.

But thanks for the info anyway I would never ever have figured it out without it.

|||

Hi,

I'm having the same problem, and I've found your post on several sites, that all lead back to your post as the only fix right now. I saw on connections were it's accepted as a bug, but no resolution yet.

What I need help with, and I know this sound really stupid, but I don't understand how to use Profiler to run a SP. I know how to create one, and how to execute it either from Studio or a query or VB, but I don't understand how to execute one from Profier and apparently you have to do it from there because I've tried creating that as a stored procedure from the MSDB Database, and it throws an error and I still have the same problem.

I can get the lookup to run, and it comes back blank, but the create throws another expection error, now it comes back that I have a duplicate key.

Msg 2627, Level 14, State 1, Procedure sp_dts_addfolder, Line 14

Violation of UNIQUE KEY constraint 'U_sysdtspackagefolders90uniquepath'. Cannot insert duplicate key in object 'dbo.sysdtspackagefolders90'.

The statement has been terminated.

(1 row(s) affected)

Any help would be appreciated.

|||

Hi tropics43!

I just had exactly the same problem as you describe.... obviously the folder with the id '08AA12D5-8F98-4DAB-A4FC-980B150A5DC8' was already in the according msdb table.... check it out:

SELECT * FROM msdb.dbo.sysdtspackagefolders90

you will see that the folderid exists but has (for whatever reason...) the wrong name, not 'Maintenance Plans'. You can repair this by just using this statement:

UPDATE msdb.dbo.sysdtspackagefolders90
SET foldername = 'Maintenance Plans'
WHERE folderid='08AA12D5-8F98-4DAB-A4FC-980B150A5DC8'

It worked for me perfectly fine... after that maintenance plans can be created again....

Best regards,
Wolfgang

No comments:

Post a Comment