locked
SQL Application Event ID RRS feed

  • Question

  • HI all,

    we have receiving below error in SQL 2012 Server...

    Sourec SQL server

    Event ID 18054..

    Need your assistance please

    Friday, August 7, 2015 5:06 AM

Answers

  • Hello,

    Please post always the complete error message, not only the number. Is it this error?

    select *
    from sys.messages
    where message_id = 18054

    => Error %d, severity %d, state %d 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.

    Some of the SQL code raises a customer error message which isn't registered in sys.messages.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by Charlie Liao Wednesday, September 9, 2015 9:10 AM
    Monday, August 10, 2015 8:50 AM

All replies

  • Read this thread

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e26732c5-7350-4fce-bf72-4cd7926f4a94/sql-server-error-id-18054?forum=sqldataaccess


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Friday, August 7, 2015 5:15 AM
    Answerer
  • Still same error...

    Saturday, August 8, 2015 11:31 AM
  • https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1dfcc687-1503-4d94-b889-13cebedb737f/sql-application-event-id?forum=sqldatabaseengine


    Hope this helps ! ------------------------------------------------------Please Mark This As Answer if it solved your issue. Please Vote This As Helpful if it helps to solve your issue

    Saturday, August 8, 2015 10:13 PM
  • Can you show us the entire error message ? Is this the same error as it described in the thread I posted above?

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Sunday, August 9, 2015 5:49 AM
    Answerer
  • Hello,

    Please post always the complete error message, not only the number. Is it this error?

    select *
    from sys.messages
    where message_id = 18054

    => Error %d, severity %d, state %d 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.

    Some of the SQL code raises a customer error message which isn't registered in sys.messages.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by Charlie Liao Wednesday, September 9, 2015 9:10 AM
    Monday, August 10, 2015 8:50 AM