Symptom
After modifying the script, 'sp_thresholdaction_logfreespace.sql' sent via SAP Note 1801984, the procedure, 'sp_thresholdaction_logfreespace' does not work anymore.
Following errors are seen in the ASE log -
Error: 101, Severity: 15, State: 4 Line 5: SQL syntax error.
Error: 103, Severity: 15, State: 205 The identifier that starts with 'sp_thresholdaction_logfreespac' is too long. Maximum length is 30.
Error: 101, Severity: 15, State: 4 Line 40: SQL syntax error.
Error: 103, Severity: 15, State: 205 The identifier that starts with '@do_dumptran_by_DUMP_TRAN_usin' is too long. Maximum length is 30.
.................
.................
Error: 11031, Severity: 16, State: 1
Execution of procedure sp_thresholdaction_logfreespace failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.sp_thresholdaction_logfreespace.
Failed to execute the threshold procedure for database 4, segment 2, free space 52248.
Error: 1105, Severity: 17, State: 4
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
Product
Keywords
sp_thresholdaction_logfreespace, identifier, "too long" , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.