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

Search for additional results

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