Symptom
sp_dbcc_faultreport complains about page 8. It reports some user table for the table name and indid 255.
dbcc checktable for the erroneously reported object comes back clean.
Also dbcc checktable on sysobjects came back clean.
sp_dbcc_faultreport short,<SID>,@hard_only=1
go
Database Name : <SID>
Table Name Index PartitionId Fault Type Page Number
------------ ------- ----------------- -------------------------- -----------------
<table_name> 255 475835062 100012 (wrong type error) 8
<table_name> 255 475835062 100012 (wrong type error) 8
<table_name> 255 475835062 100012 (wrong type error) 8
<table_name> 255 475835062 100012 (wrong type error) 8
<table_name> 255 475835062 100014 (reused page error) 8
<table_name> 255 475835062 100014 (reused page error) 8
<table_name> 255 475835062 100014 (reused page error) 8
<table_name> 255 475835062 100014 (reused page error) 8
<table_name> 255 475835062 100022 (chain start error) 8
<table_name> 255 475835062 100022 (chain start error) 8
<table_name> 255 475835062 100022 (chain start error) 8
<table_name> 255 475835062 100022 (chain start error) 8
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.x
Product
Keywords
wrong type error, sp_dbcc_faultreport, @hard_only=1 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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