SAP Knowledge Base Article - Preview

2692494 - Dbcc checkstorage returns error 11031 on sp_bindcache - SAP ASE

Symptom

  • When running dbcc checkstorage on a database, error 11031 is returned for sp_bindcache procedure:

dbcc checkstorage(mydb)
go
Checking mydb: Logical pagesize is # bytes
DBCC CHECKSTORAGE for database 'mydb' encountered an error. Some results may not be available. Correct the problems reported and reexecute the CHECKSTORAGE command.

  • With ASE errorlog showing error message

Error: 11031, Severity: 16, State: 1
Execution of procedure sp_bindcache failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.sp_bindcache.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP03

Product

SAP Adaptive Server Enterprise 16.0

Keywords

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.