Symptom
- dbcc checkverify or checkrepair cannot be executed
- Error 12920 is raised by ASE:
Error: 12920 Severity 16
The last completed DBCC CHECKSTORAGE for this database has been processed.
You must perform another DBCC CHECKSTORAGE before you can use CHECKVERIFY or CHECKREPAIR.
Use sp_dbcc_summary_report to view the DBCC operations performed.
- Table dbccdb..dbcc_operation_log displays operations for dbcc checkstorage (optype =2) and
- Another operation in the same sequence number as the dbcc checkstorage operation (in this example opid = 86) are displayed:
select * from dbccdb..dbcc_operation_log
go
dbid opid optype suid start finish seq id maxseq
------ ------ ------ ----------- ------------------------------- ------------------------------- ------ ----------- ------
5 86 2 10334 Nov 1 2017 9:53PM Nov 1 2017 9:53PM NULL NULL 1
5 86 3 10334 Nov 1 2017 10:12PM Nov 1 2017 10:12PM 1 NULL NULL
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) - all versions
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.