SAP Knowledge Base Article - Preview

2818647 - Received Msg 11035, Level 16, State 1: when executing a stored procedure after an upgrade - SAP ASE

Symptom

After the upgrade was completed, how can all stored procedures be verified before releasing to business users?  For example:


dbcc upgrade was run and it reported no errors - but when the execution took place, it failed.

set switch on 3604
go
dbcc upgrade_object(mydb, myproc)

go

DBCC upgrade_object: Upgrading PROCEDURE dbo.myproc
DBCC upgrade_object: PROCEDURE dbo.myproc upgraded successfully.

set switch off 3604
go
myproc
go

Msg 11035, Level 16, State 1:
Server 'myserver', Line 1:
Execution of procedure myproc failed because upgrade found no entry in syscomments for this object. Please drop and recreate dbo.myproc

OR

Database error code: 11031

Database error message:
Select Error:
Execution of procedure myproc failed because of errors parsing the source text in syscomments during upgrade.  Please drop and recreate dbo.myproc.


Read more...

Environment

SAP Adaptive Server Enterprise

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

upgrade, compiled objects, verify, verification, error, execution, syscomments , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.