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.
SAP Knowledge Base Article - Preview