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 for Me (Login required).

Search for additional results

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