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
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 ONE Support launchpad (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.