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


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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.