SAP Knowledge Base Article - Preview

2493757 - Fault Error 100030 raised by DBCC CHECKSTORAGE - SAP ASE

Symptom

  • DBCC CHECKSTORAGE raised 1 fault and Error 100030 was listed in sp_dbcc_faultreport.

1> sp_dbcc_faultreport @dbname=test
2> go

Generating recommendations for database test
================================================================================
Database level recommendations:
   Reload the database from a clean backup.
================================================================================
Recommended corrective action for object test_rule, objid 1356531866:
   Drop the object and recreate it.
================================================================================
Contact Sybase Technical Support if the recommended corrective action does not resolve the faults.

Database Name : test

Table Name   Index   PartitionId       Fault Type                 Page Number
------------ ------- ----------------- -------------------------- -----------------
test_rule    255     1356531866 100030 (page format error)           1178558
(1 row affected)

  • However, the following DBCC checks are clean.

dbcc checkdb(test)
dbcc checkcatalog(test)
dbcc checktable (test_rule)
dbcc tablealloc ('test_rule ', 'full', 'nofix')
dbcc textalloc ('test_rule ', 'full', 'nofix')


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

spurious, persistent, rebuild_text , 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.