SAP Knowledge Base Article - Preview

2178418 - Error 7417: last chance threshold entry for logsegment is not present in threshold cache for database... - SAP ASE

Symptom

  • Multiple threasholds exist on the log segment:  

select * from systhresholds
go
 segment free_space    status proc_name 
 ------- ------------- ------ ------------------------
       2          8960      0 sp_threshold_log_comp  
       2          2560      0 sp_threshold_log_comp  
       2          2560      1 sp_thresholdaction     
       2          3584      0 sp_threshold_log_comp

  • ASE encounters the following error message on an attempt to drop a threshold:

sp_dropthreshold "testdb","logsegment",2560
go
Msg 512, Level 16, State 5:
Server 'SYBASE', Procedure 'sp_dropthreshold', Line 137:Subquery returned more than 1 value. This is illegal when the subquery follows =, !=, <, <= , >, >=, or when the subquery is used as an expression.
(return status = -6)

  • An ASE error message is printed into the ASE errrolog:

Error: 7417, Severity: 21, State: 1
The last chance threshold entry for logsegment is not present in threshold cache for database 'testdb'. Please use 'dbcc thresholds' to see the threshold cache contents and contact your system administrator.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

sp_modifythreshold,  duplicate, CR779616, CR#779616, 779616 , 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 ONE Support launchpad (Login required).

Search for additional results

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