Symptom
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.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
Keywords
threshold
oper_role , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.