Symptom
- 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
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0 SP03
Product
Keywords
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.