SAP Knowledge Base Article - Preview

2558237 - IMRS log thresdhold sp_imrslog_thresholdaction reports error 101 and 137 - SAP ASE


  • Threshhold procedure sp_imrslog_thresholdaction for IMRSlog failed.
  • The following errors reported in the errorlog:

Error: 101, Severity: 15, State: 4
Line 1: SQL syntax error.
Error: 137, Severity: 15, State: 2
Must declare variable '@segment'.
background task message: The procedure sp_imrslog_thresholdaction has triggered in database 'dbname' for segment 'imrslogsegment' with 2097152 pages left. Required to pack pages.
background task message: sp_thresholdaction : 'dbname' dumped log, Free Pages: '2097152'
background task message: Database 'dbname' (retcode = 0, 0 pack ops) Required to pack pages : The number of inactive pages has changed from 34935 to (delta ). The number of free pages has changed from 2097063 to 2131776 (delta 34713). No rows have been packed. Elapsed time 0 h, 0 m, 0 s



SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL01


SAP Adaptive Server Enterprise 16.0


KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.