SQL Server – Internal Stored Procedure Failure ID_TransUserActionCreate

sql serversql server 2014

On a SQL Server 2014 12.0.4237.0 system, the following errors have been logged periodically (11 times in past 66 days):

2018-03-22 09:28:11.170 Error: 50101, Severity: 16, State: 10.
2018-03-22 09:28:11.170 Internal Stored Procedure Failure – ID_TransUserActionCreate – SQL Error Number 0

As yet I haven't found any reference to an error with code 50101, and Google, amazingly, returns absolutely nothing for "ID_TransUserActionCreate".

As far as "what's happening at the time this is logged," I don't know yet as there are several databases on the system and we haven't yet started collecting detailed information to answer that question. So this question is to ask if anyone knows, or has a good idea, what this message means and/or if it is something I should be concerned with.

Best Answer

That's a user-defined error message that someone created on that instance.

DOCS

Is a user-defined error message number stored in the sys.messages catalog view using sp_addmessage. Error numbers for user-defined error messages should be greater than 50000. When msg_id is not specified, RAISERROR raises an error message with an error number of 50000

You can find it in sys.messages

select * 
from sys.messages
where message_id = 50101

I would guess ID_TransUserActionCreate was a column name a table--lbut this is just a guess.

Related Question