SAP Knowledge Base Article - Preview

3193812 - isql session hangs when audit table is full - SAP ASE for Business Suite


  • You are unable to change any DB parameter from isql using stored procedure "sp_configure": the session is getting hang.
  • ASE auditing is enabled (ASE configuration parameter "auditing" = 1) which is normally the default setting for Business Suite on ASE systems.
  • Checking the current audit database it is reported that there is only one audit table like in this sample:

isql -S<SID> -Usapsso -X -w999

1> use sybsecurity
2> go
1> sp_helpsegment
2> go
 segment name       status
 ------- ---------- ------
       0 system          0
       1 default         1
       2 logsegment      0
       3 aud_seg_01      0 <<<< one audit table
(return status = 0)

  • Checking existence of threshold for audit segments, you'll have this output where there is no reference of audit table segment "aud_seg_01":

isql -S<SID> -Usapsso -X -w999

1> use sybsecurity
2> go
1> exec sp_helpthreshold
2> go

segment name   free pages   last chance   threshold procedure
-------------- ------------ ------------- ------------------------
logsegment              568             1 sp_thresholdaction



SAP Adaptive Server Enterprise (ASE) 16.0
SAP Netweaver - All versions


SAP Adaptive Server Enterprise 16.0


KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem

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.