Symptom
- Upgrading from one Service Pack to another, i.e. SP03 PL08 to SP04 PL06.
- Stored procedures that have been manually "hidden" by editing syscomments.text fail to run after the upgrade.
- Executing or running dbcc upgrade_object reports Error 11031 along with error 156 (but could be any other syntax-like error).
1> exec testproc
2> go
Msg 156, Level 15, State 1:
Server 'ase', Procedure 'testproc', Line 1:
Incorrect syntax near the keyword 'end'.
Msg 11031, Level 16, State 1:
Server 'ase', Procedure 'testproc', Line 1:
Execution of procedure testproc failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.testproc.
Single-statement transaction has been rolled back.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
upgrade_object, hidden text , 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.