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
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.