none
SQL Job FAILURE FOR A STORED PROC.

    Question

  • Executed as user: NT AUTHORITY\SYSTEM. The Allocation currency values do not balance to zero [SQLSTATE 42000] (Error 50000).  The step failed.


    Please help where would be the problem.

    Wednesday, January 16, 2013 3:05 PM

Answers

  • Seems user defined error. Check the particular stored procedure for execution error.

    Srinivasan

    • Marked as answer by chinna738 Wednesday, January 16, 2013 4:55 PM
    Wednesday, January 16, 2013 3:10 PM
  • This is a message generated from code that is installed your system. If this is an application developed internally, find the development team and talk to them. If this is a third-party vendor, contact the vendor's support desk.

    This is not a problem we can help you with in this forum. While the error occurs when running a job step, it is not a message that is generated by SQL Server itself; it is only the messenger.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    • Marked as answer by chinna738 Thursday, January 17, 2013 10:07 AM
    Wednesday, January 16, 2013 10:53 PM

All replies

  • Seems user defined error. Check the particular stored procedure for execution error.

    Srinivasan

    • Marked as answer by chinna738 Wednesday, January 16, 2013 4:55 PM
    Wednesday, January 16, 2013 3:10 PM
  • hi srinivasan,

    why do we get errors  [SQLSTATE 42000] (Error 50000) please can you explain?

    thank you.

    Wednesday, January 16, 2013 3:15 PM
  • This is a message generated from code that is installed your system. If this is an application developed internally, find the development team and talk to them. If this is a third-party vendor, contact the vendor's support desk.

    This is not a problem we can help you with in this forum. While the error occurs when running a job step, it is not a message that is generated by SQL Server itself; it is only the messenger.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    • Marked as answer by chinna738 Thursday, January 17, 2013 10:07 AM
    Wednesday, January 16, 2013 10:53 PM
  • Its execution error inside your stored procedure.Analayse your SP code step by step.
    Are you running this SP via Sql job?

    Srinivasan

    Thursday, January 17, 2013 6:02 AM
  • hi srinivasan,

    why do we get errors  [SQLSTATE 42000] (Error 50000) please can you explain?

    thank you.

    Hi

    Please refer to the following thread and the explanation about this error as Steef post.

    http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/thread/f34f3fcd-ceaa-4dd1-b17e-9f129131841c/

    Regards,

    Fanny Liu 


    Fanny Liu
    TechNet Community Support

    Thursday, January 17, 2013 10:07 AM
    Moderator
  • Hi Srinivas,

    Yes I have been running the stored proc in the job.

    Thanks.

    Thursday, January 17, 2013 10:08 AM