SQL Server Performance

Job Error

Discussion in 'SQL Server 2005 General DBA Questions' started by Hollywood, Apr 23, 2007.

  1. Hollywood New Member

    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
  2. satya Moderator

    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.
  3. Hollywood New Member


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

    Regards
  4. satya Moderator

    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.
  5. Hollywood New Member

    The patch is applied.

    How to see the conversion error and how to check the changes ?

    Thanks for your supports

    Regards
  6. satya Moderator

    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.
  7. Hollywood New Member

    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 ...

  8. satya Moderator

    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.
  9. Hollywood New Member

    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
  10. satya Moderator

    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.
  11. Hollywood New Member

    Great,

    I drop the plan and recreat-it and it's working ...

    Thanks a lot four your supports

    Regards
  12. satya Moderator

    Hm, typical solution for MS products [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] and appreciate your feedback as it helps.,<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>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.</i></font id="size1"></font id="teal"></center>
  13. cjmorgant110 New Member

    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.
  14. satya Moderator

    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.

Share This Page