SAP Knowledge Base Article - Preview

2556199 - Error 12920 running dbcc CHECKSTORAGE or CHECKREPAIR - SAP ASE

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.