SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Job was failed


Job was failed

Author
Message
shiv-356842
shiv-356842
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4119 Visits: 1222
Hi Team,

Job was failed due to this error,

Error 50001, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage. [SQLSTATE 42000] (Error 18054). The step failed.



I had searched in msdn i got the below information

http://ignaciosalom.com/2010/01/17/sql-2005-errors-18054-50001/

Can you please suggest me, How can i work out here. i m bit confusing..



Thanks in advance.
Ninja's_RGR'us
Ninja's_RGR'us
SSC Guru
SSC Guru (288K reputation)SSC Guru (288K reputation)SSC Guru (288K reputation)SSC Guru (288K reputation)SSC Guru (288K reputation)SSC Guru (288K reputation)SSC Guru (288K reputation)SSC Guru (288K reputation)

Group: General Forum Members
Points: 288553 Visits: 9673
2nd post today about this issue.

I'm giving this thread as reference so you guys can help one another.


http://www.sqlservercentral.com/Forums/Topic518471-146-1.aspx
shiv-356842
shiv-356842
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4119 Visits: 1222
Hi Team,

that is different one.

Tx
Ninja's_RGR'us
Ninja's_RGR'us
SSC Guru
SSC Guru (288K reputation)SSC Guru (288K reputation)SSC Guru (288K reputation)SSC Guru (288K reputation)SSC Guru (288K reputation)SSC Guru (288K reputation)SSC Guru (288K reputation)SSC Guru (288K reputation)

Group: General Forum Members
Points: 288553 Visits: 9673
I've helped as much as I could. I don't know anything about that error.
MarkusB
MarkusB
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: General Forum Members
Points: 35852 Visits: 4208
50001 is a user defined error, not a system error.
You first need to find out which application\database has created this error and when it's fired.
You can also check in sys.messages if there is a message text defined for this error or not.

select * from sys.messages
where message_id = 50001

Markus Bohse
shiv-356842
shiv-356842
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4119 Visits: 1222
Hi team,

I have checked this command

select *from sys.messages
where id = 500001

but i m not getting any result, any suggestions on this.
KrishDBA
KrishDBA
Mr or Mrs. 500
Mr or Mrs. 500 (545 reputation)Mr or Mrs. 500 (545 reputation)Mr or Mrs. 500 (545 reputation)Mr or Mrs. 500 (545 reputation)Mr or Mrs. 500 (545 reputation)Mr or Mrs. 500 (545 reputation)Mr or Mrs. 500 (545 reputation)Mr or Mrs. 500 (545 reputation)

Group: General Forum Members
Points: 545 Visits: 80
Add as much logging as possible in your job. And also set a ouput file for the job. This can be done in Advanced options of the job. From the Job history you cannot get the detailed information of the jab failure. But this type of output file will have the exact error where the job stopped.

Hope this will help you.
MarkusB
MarkusB
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: General Forum Members
Points: 35852 Visits: 4208
What exactly is your job doing?
Does it run a TSQL script or a stored procedure which contains a RAISERROR (50001,16,1) ?
In that case if error number 50001 is not defined in sys.messages you would receive that kind of error because no message is defined for this error.

Markus Bohse
shiv-356842
shiv-356842
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4119 Visits: 1222
fdsfdsf
MarkusB
MarkusB
SSC-Dedicated
SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)SSC-Dedicated (35K reputation)

Group: General Forum Members
Points: 35852 Visits: 4208
I see 2 times your calling RAISERROR 50001

 RAISERROR (50001, -- Message id.
16, -- Severity,
1, -- State,
N'xp_cmdshell call in [dbo].[adminManagePartition_Trace] failed. Purge not complete.'); -- First argument supplies the string.



Since you already stated that there's no error message 50001 defined in sys.messages you receive the error. Change the code to this and it should work:

 RAISERROR (50001, 
N'xp_cmdshell call in [dbo].[adminManagePartition_Trace] failed. Purge not complete.',
16,1)



Markus Bohse
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum









































































































































































SQLServerCentral


Search