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.
SAP Knowledge Base Article - Preview