SQL server management studio error  
Author Message
SHG





PostPosted: Team Foundation Server - General, SQL server management studio error Top

Hi

When I try to create a maintance plan, it stops with a message box 
saying
Guid should contain 32 digits with 4 dashes (xxxxxxxx....)

Whats wrong


Visual Studio Team System16  
 
 
Brad Peterson MSFT





PostPosted: Team Foundation Server - General, SQL server management studio error Top

Do you have all parts of SQL installed (Integration Services/Notification Services)  

THanks,

Brad



 
 
SHG





PostPosted: Team Foundation Server - General, SQL server management studio error Top

Hi

Yes i have them installed and running

I have narowed it down to:

I can create maintenance plan and exceute it, but i cant save/close (click on X) I got the guid error, but the 2 time it closes, and when i reopen there is no schedule (on demand)!!

So if I create a maintenance plan, with no schedule it save/closes ok

If I creat a maintenance plan, with schedule it save/closes with error

Soren


 
 
NetworkPro





PostPosted: Team Foundation Server - General, SQL server management studio error Top

I am having the same issue. Have you found a solution yet

This error message happens whether I have the Maintenance plan scheduled or not...


 
 
NetworkPro





PostPosted: Team Foundation Server - General, SQL server management studio error Top

I also tried installing the integration services from the SQL Server disks. Further, I am able to to a manual backup of the data base Via Server Objects --> backup Devices --> (and configuring a Backup devices)

I also would like to note I am trying to backup to a local partition d:\backups\DB\

 


 
 
NetworkPro





PostPosted: Team Foundation Server - General, SQL server management studio error Top

Ok, yet another update...

It appears that I got it working... Try doing the following;

#1 Install the integration services from the SQL Server 2005 Disk

#2 Then Delete all of the Jobs under (SQL Server Agent  --> Jobs -->)

#3 Delete all of the Maintenance Plans (Management --> Maintenance Plans -->)

#4 Right click on Maintenance Plans --> Select Maintenance Plan Wizard

#5 Follow the wizard through.. and it should work.

I think the essential piece is the integration services and deleting your existing maintenance plans...

Perhaps we will see a fix for this issue in the future with a service pack release...

 


 
 
Brian Harry





PostPosted: Team Foundation Server - General, SQL server management studio error Top

I have confirmed with the SQL team that maintenance plans require integration services to be installed.  They say this is a known issue and are looking at fixing it for an SP.  Until that you can install integration services and everything should work fine.

Brian


 
 
Gops Dwarak





PostPosted: Team Foundation Server - General, SQL server management studio error Top

Our next SP will address this and it will require tools to be installed and would not need Integration services and no more you would need to delete and recreate jobs.

 

Thanks,

Gops Dwarak

 

 

 

 

 



 
 
Gops Dwarak





PostPosted: Team Foundation Server - General, SQL server management studio error Top

 I would like to hear more feedback on our plan for SP1, the minimum need would be  tools install on the box and not Integration services, for running maintenance plans. Please advice.

Thanks,

Gops Dwarak



 
 
Kaligaclark





PostPosted: Team Foundation Server - General, SQL server management studio error Top

Thank you, I was having the same problem.
 
 
DBAcrobat





PostPosted: Team Foundation Server - General, SQL server management studio error Top

If you go to http://support.microsoft.com/kb/922651 there is an explanation of how you can workaround the problem of imported maintenance plans in SSIS giving the error "Guid should contain 32 digits with 4 dashes..." when you update the plan. I found that workaround a bit long winded and hard to understand so I came up with an alternative that may be a little more friendly:

Bottom line is because of MS bug, the subplan is missing. You can confirm this with "select * from ysmaintplan_subplans". First get subplan_id by going to BI studio, New Integration package, Solution Explorer, add SSIS package, pick the Maintenance Plan from the server in question, then double-click the dtsx package in question, click Reporting Task and get the ID from the properties section. This would be the subplan_id. You can also obtain this ID by simply editing the .dtsx version of the plan if you have exported that before.

The plan_id and job_id can be obtained from the following two queries. I have used 'Daily Backup' as a maintenance plan example.

select id from sysdtspackages90 where name = 'Daily Backup' -- this will be the plan_id
select job_id from sysjobsteps where step_name = 'Daily Backup' -- this will be the job_id

INSERT INTO SYSMAINTPLAN_subplans (
subplan_id,
subplan_name,
subplan_description,
plan_id,
job_id
)
values (
'D7EDA4BF-453A-4FC1-8674-29E72A2773EF',
'Daily Backup','',
'FE7CD620-AC6E-4069-ADF9-409E58C11531',
'D58DA8A1-D104-4E4E-9A96-ACDDD8099B04')

To synchronize the job schedule with the plan:

update sysmaintplan_subplans set schedule_id = (select schedule_id from sysschedules
where name = 'Daily Backup-Schedule') where subplan_name = 'Daily Backup'

This method has worked for me for every imported maintenance plan that errored with a GUID message.


 
 
Sune D. Moeller





PostPosted: Team Foundation Server - General, SQL server management studio error Top

I have applied SP1 and it didn't seem to help on the problems discussed here. I still have them.

- Sune


 
 
Waterski





PostPosted: Team Foundation Server - General, SQL server management studio error Top

When will this service pack to fix this issue be out

Is this fix incorporated in the Beta SP2

Thanks


 
 
ronmac





PostPosted: Team Foundation Server - General, SQL server management studio error Top

According to the SP2 fix list, this STILL has not been addressed. Can we get a firm timeline as to when this will be addressed

Thanks!


 
 
Cimares





PostPosted: Team Foundation Server - General, SQL server management studio error Top

I was having this GUID error when creating new maintenance jobs on a fresh install of SQL 2005 Std and have now applied SP2 and the problem has gone away for me.

Paul.