When a threshold is reached the procedure fails to truncate the transaction log and reports an error:
server Error: 10364, Severity: 14, State: 4
server Permission denied. You must either be the database/object owner or possess any of the following roles in order to perform this operation: 'sa_role, oper_role'.
server background task message: CRITICAL: Threshold last chance (xx%) on database <database_name>, segment logsegment has failed to truncate the transaction log. Check related errors in errorlog and backuplog
server Threshold procedure '<threshold_procedure>' returned an error indication (@status=-4) when called for database '<database_name>', segment 'logsegment', free_space xxxx.
SAP Adaptive Server Enterprise (ASE)
oper_role , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis 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.