SAP Knowledge Base Article - Preview

3526054 - Error 11031 reported for manually hidden stored procedure text after upgrade - SAP ASE

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.