Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi Anomaly
Nice to see that you found the solution. Thanks for providing it to the group.
For future reference, it's always recommended to give some details about the system environment (SAP/OS/DB).
Regards,
LEH
From: anomaly69 via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 11. september 2010 20:39
To: Lars-Erik Hallsten
Subject: RE:[sap-basis] Check Data Failed
Posted by anomaly69
on Sep 11 at 2:38 PM Mark as helpful
Found the Answer:
SELECT * FROM roots WHERE root = <root> (Page Number)
Thanks
---------------Original Message---------------
From: anomaly69
Sent: Saturday, September 11, 2010 1:57 PM
Subject: Check Data Failed
> Hi All,
>
> My Check Data Job is failing and I logged a ticket with SAP quite sometime back and they suggested I should just recluster those tables which are giving the problem.
>
> Now my question is how to I found out what tables need reclustering?
>
> I run the Check Data Job and all the information it gives me is the following:
>
> 91,Damaged B*tree structure found
> Damaged data page is referenced by data page with page number '20864110'
> 36,Check table failed
> Servertask Info: because bd01CheckFile failed
> Job 0 (Check Data) [executing] WaitingT109 Result=OK
> bd01CheckFile failed, Error code 6433 "system_error"
>
> I know it is giving me a page number but how do I found out what the table name is so I can fix it?
>
> Many Thanks for your time and look forward to your response :)
>
> Regards,
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  Lars-Erik Hallsten
SAP Basis Top Contributor
Contributed the most posts in a group for a month to earn a Silver Achievement Related Content White Papers
In the Spotlight  _.____.__ |
Mark as helpful
