SAP Knowledge Base Article - Preview

2749379 - How can a message be written to the ASE errorlog without writing it to the client - SAP ASE

Symptom

Would like a process to suppress messages from writing to a client; only send the message to the ASE errorlog.

For example:

  1. sp_addmessage 20500,"The login: '%1!' - The message and Ticket output: '%2!'", null, true, "replace"
    go
      
  2. If you raise the error with:

    declare @loginname varchar(30), @ticket varchar(40)
    select @ticket='Test'
    select @loginname=suser_name()
    raiserror  20500,@loginname,@ticket
    go
     

Actual Results:

To the client:
Msg 20500, Level 16, State 1:
Server 'servername', Line 4:
The login: 'sa' - The message and Ticket output: 'Test'

ASE errorlog:

Error: 20500, Severity: 16, State: 1
The login: 'sa' - The message and Ticket output: 'Test'

Desired results:

To the client:
Nothing written to the client

ASE errorlog:
Msg 20500, Severity: 16, State: 1
The login: 'sa' - The message and Ticket output: 'Test'


Read more...

Environment

SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

going receiving receive message log enhancement request , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.