===================================
Saving maintenance plan failed.
===================================
One or more arguments are invalid
:
Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.Save()
Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()
SQL Express doesn't include the Maintenance Plan Wizard so you're not using Express. I'm moving this to a more appropriate forum.
Mike
|||What version of SQL Server is this? Can you give us any more context?
Please install SQL Server 2005 SP1, if you have not already.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
I am having this same issue and have updated my install of SQL 2005 Standard with SP1. I am getting the following message when trying to create a maintenance plan with the wizard:
One or more arguments are invalid
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.Save()
at Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions()
Any thoughts?
Thanks,
Steven Pearl
Business Automation Solutions, Inc.
|||Can you ensure the SSIS has been installed properly.|||
SQL Server 2005 Service Pack 2 has been released to the web. We have made many improvements to Maintenance Plans. You should apply SP2 and see if that solves your problem.
SQL Server 2005 Service Pack 2:
http://www.microsoft.com/sql/sp2.mspx
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
After installing SP2 for SQL 2005, when I click on "Maintenance Plans" in the management studio I get the following error:
Failed to retrieve data for this request. Additional Information: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) An exception occured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Invalid column name from_msx'. Invalid column name 'has_targets'. (Microsoft SQL Server, Error 207)
So I thought I would try creating a new Maintenance Plan using the wizard to see what happens. At the end when trying to save the plan I get this error:
Saving maintenance plan failed. Additional Information: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) An exception occured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Invalid column name 'msx_job_id'. (Microsoft SQL Server, Error 207)
What in the world happened to all of my maintenance plans? This has been working for months.
|||I'm the same person as above. I don't know how my name got set to PCDoper!
Anyway, I've just realized that all my Database Mail profiles and settings got wiped out with the install of SP2 as well. None of my email alerts or logs are getting sent anymore and when I open the console it wants be to configure mail like I did at the beginning!
What is going on here? Help!
|||This issue has been resolved. Evidently there WAS a bug in the SP2 package. The fix can be found here:
http://support.microsoft.com/kb/933508
Just for the record, I think the Microsoft SQL team is one of the best software divisions at Microsoft. They listen to users and fix issues promptly.
|||Fastpay IT Guy wrote:
Anyway, I've just realized that all my Database Mail profiles and settings got wiped out with the install of SP2 as well. None of my email alerts or logs are getting sent anymore and when I open the console it wants be to configure mail like I did at the beginning!
Is this still an issue? or was this fixed with the patch?
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
Yes, the patch fixed the issue. In fact as soon as I installed the patch all the emails that had been missed were sent out at once.
Thanks for the follow up!
|||I receive exact that error message as well. I have installed the latest SP2 so the patch wouldn′t be nessecary for me. Anyone have a suggestion?
Regards Daniel
|||We're getting the exact same error message. The refreshed SP2 has been applied, and Microsoft.SqlServer.MaintenancePlanTasks.dll is verified at version 9.0.3043.0. We cannot create a maintenance plan nor view the ones created prior to installing the refreshed SP2.
After installing SP2 for SQL 2005, when I click on "Maintenance Plans" in the management studio I get the following error:
Failed to retrieve data for this request. Additional Information: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) An exception occured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Invalid column name from_msx'. Invalid column name 'has_targets'. (Microsoft SQL Server, Error 207)
So I thought I would try creating a new Maintenance Plan using the wizard to see what happens. At the end when trying to save the plan I get this error:
Saving maintenance plan failed. Additional Information: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) An exception occured while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Invalid column name 'msx_job_id'. (Microsoft SQL Server, Error 207)
What in the world happened to all of my maintenance plans? This has been working for months.
|||The copy of SQLServer2005SP2-KB921896-x64-ENU.exe that we ran was the version 9.0.3042.1 refreshed SP2.
We also tried to run hotfix 3050, which resulted in a status of Failure for MSSQLSERVER, with the log indicating that it cannot rename mssqlsystemresource1.ldf. I'm logged on as a member of the local administrators group, and as a system administrator in SQL Server.
Product Installation Status
Product : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB933508_sqlrun_sql.msp.log
Error Number : 29538
Error Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: m:\DATA\mssqlsystemresource1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
Microsoft.SqlServer.MaintenancePlanTasks.dll is now at version 9.0.3050.0, but we still cannot view or create maintenance plans without getting the error. Another install with the refreshed SP2 installed before any maintenance plans were created is working correctly.
At this point, SP2 has broken our Maintenance Plans on this server.
|||
Stivan,
I am trying to reproduce the problem you are facing. It will greatly help if you can provide information about your machine configuration and the exact upgrade sequence?
Thanks,
Sirish
sql
No comments:
Post a Comment