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