Symptom
After an upgrade of 15.7 SP130 to 15.7 SP134, the following errors can be seen when executing a procedure or function:
- Procedure error #11031:
Warning 11031
Example:
SP_xxxxx,Error: SQL Server returned error status value from executing
Sybase Server xxxxx`:`warning 11031 (severity 16) from stored procedure 'dbo.xxxxx', line 97: Execution of procedure xxxxx failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.xxxxx.
Sybase Server xxxxx`:`warning 103 (severity 15) from stored procedure 'dbo.xxxxx', line 97: The identifier that starts with 'xxxxx' is too long. Maximum length is 30.0
- Function error #11798:
Msg 11798, Level 15, State 10
Example:
Msg 11798, Level 15, State 10: Server 'xxxxx_157': Illegal CREATE FUNCTION statement within a scalar SQL function.
Msg 11031, Level 16, State 1: Server 'xxxxx_157', Procedure 'dbo.xxxxx':
Execution of SQL function xxxxx failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate
dbo.xxxxx.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 15.7
Keywords
CR789192, CR#789192, 789192, dbcc, upgrade_object , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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.