SQL Server Performance Forum – Threads Archive

Job Error

Hi all, I get always an error when running a maintenance plan Job. All steps in the job are succesfull but the job reports always : Executed as user: TEST2SYSTEM. …rsion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:31:24 Error: 2007-04-23 12:31:25.52 Code: 0xC0024104 Source: Reporting Task for subplan-{D0789C34-15D5-416C-A1F1-EC52752C5127} Description: The Execute method on the task returned error code 0x80131904 (Conversion failed when converting from a character string to uniqueidentifier.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error Warning: 2007-04-23 12:31:25.52 Code: 0x80019002 Source: Tmp_JF_MaintenancePlan Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Progr… The package execution fa… The step failed. If someone can help me … Thanks for your supports Bests Regards

First thing to check whether that user has relevant privilege on the specified database? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

The owner of the Job is ‘sa’ (sysadmin) which is mapped to the DB with user = dbo and default schema = dbo. Regards

I believe you have SP2 applied on SQL instance, KBAhttp://support.microsoft.com/kb/933508 fyi for another patch after SP2.
See that conversion error and check you are performing any changes to the table., Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

The patch is applied. How to see the conversion error and how to check the changes ? Thanks for your supports Regards

May be PROFILER will help in this regard. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

The end of the trace shows that : EXECUTE msdb..sp_maintplan_close_logentry ‘797A2FFE-7F8B-46C3-AB12-B9E200DDBF00’,NULL,1 –> So the plan succed .. then later : EXECUTE msdb.dbo.sp_sqlagent_log_jobhistory @job_id = 0xE4D7BBD233FB0D43878F29AFA8F84AEC, @step_id = 1, @sql_message_id = 0, @sql_severity = 0, @run_status = 0, @run_date = 20070424, @run_time = 101529, @run_duration = 332, @operator_id_emailed = 0, @operator_id_netsent = 0, @operator_id_paged = 0, @retries_attempted = 0, @session_id = 19, @message = N’Executed as user: TEST2SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:15:29 Error: 2007-04-24 10:15:30.49 Code: 0xC0024104 Source: Reporting Task for subplan-{D0789C34-15D5-416C-A1F1-EC52752C5127} Description: The Execute method on the task returned error code 0x80131904 (Conversion failed when converting from a character string to uniqueidentifier.). The Execute method must succeed, and indicate the result using an "out" parameter. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:15:29 Finished: 10:18:59 Elapsed: 210.078 seconds. The package execution failed. The step failed.’ I cannot see this conversion error …

Please explain the significance of this maintenance plan job on the server. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

The Maintenance Plan is : – Check Database integrity / Reorganize index / Update Statistics. I use only 1 DataBase for the test, moreover if I only Enable the Check DataBase integrity to diagnose the problem, I get always the error at the end of the plan. It’s strange because in the log, I see that the task is successfull but the plan report a failure. Thanks for your supports Regards

SImple plan and peculiar error, is it possible to drop and recreate this plan again, also try to create fresh plan for database integrity. If it happens again then report the feedback to MS connect onhttp://www.connect.microsoft.com as it seems a new one. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Great, I drop the plan and recreat-it and it’s working … Thanks a lot four your supports Regards

Hm, typical solution for MS products [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] and appreciate your feedback as it helps., Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</center>

As a note this also worked for me. The job was created when the server was at RTM level of SqL 2005 at which time I was getting errors setting the schedule for a maintenance plan. Applied SP3 and I could set the schedule for the plan (which was just a databae backup). The backups were succeeding but I received the errors listed above. I dropped the existing jobs and re-created them (with SP3 applied and they now run without error.

Welcome to the forums.
As you can see the post originates in 2007 which was a beginning of SP2 times and as you said RTM version of 2005 have had issues that were addressed in SP1 and further in cumulative update packages.

]]>