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

• 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.

SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0

sp_modifythreshold,  duplicate, CR779616, CR#779616, 779616 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed