Skip to Content
author's profile photo Former Member
0
Former Member

Index not found for segment

Posted on May 02, 2011 at 09:58 AM 12 Views

Hi Gurus,

I have found the below given entries in the checkDB log.

BR0838W Index /BIC/FATCO_ACT010 not found for segment SAPSR3./BIC/FATCO_ACT010./BIC/FATCO_ACT0000000158 - ignoring segment

BR0838W Index /BIC/FATCO_ACT010 not found for segment SAPSR3./BIC/FATCO_ACT010./BIC/FATCO_ACT0000000161 - ignoring segment

BR0838W Index /BIC/FATCO_ACT020 not found for segment SAPSR3./BIC/FATCO_ACT020./BIC/FATCO_ACT0000000158 - ignoring segment

BR0838W Index /BIC/FATCO_ACT020 not found for segment SAPSR3./BIC/FATCO_ACT020./BIC/FATCO_ACT0000000161 - ignoring segment

BR0838W Index /BIC/FATCO_ACT030 not found for segment SAPSR3./BIC/FATCO_ACT030./BIC/FATCO_ACT0000000158 - ignoring segment

BR0838W Index /BIC/FATCO_ACT030 not found for segment SAPSR3./BIC/FATCO_ACT030./BIC/FATCO_ACT0000000161 - ignoring segment

BR0838W Index /BIC/FATCO_ACT040 not found for segment SAPSR3./BIC/FATCO_ACT040./BIC/FATCO_ACT0000000158 - ignoring segment

BR0838W Index /BIC/FATCO_ACT040 not found for segment SAPSR3./BIC/FATCO_ACT040./BIC/FATCO_ACT0000000161 - ignoring segment

BR0838W Index /BIC/FATCO_RT010 not found for segment SAPSR3./BIC/FATCO_RT010./BIC/FATCO_RT0000000009 - ignoring segment

BR0838W Index /BIC/FATCO_RT020 not found for segment SAPSR3./BIC/FATCO_RT020./BIC/FATCO_RT0000000009 - ignoring segment

BR0838W Index /BIC/FATCO_RT030 not found for segment SAPSR3./BIC/FATCO_RT030./BIC/FATCO_RT0000000009 - ignoring segment

BR0838W Index /BIC/FATCO_RT040 not found for segment SAPSR3./BIC/FATCO_RT040./BIC/FATCO_RT0000000009 - ignoring segment

BR0838W Index /BIC/FATCO_RT050 not found for segment SAPSR3./BIC/FATCO_RT050./BIC/FATCO_RT0000000009 - ignoring segment

BR0838W Index /BIC/FATCO_RT060 not found for segment SAPSR3./BIC/FATCO_RT060./BIC/FATCO_RT0000000009 - ignoring segment

The issue is after 10g to 11g Oracle upgrade.

System details are : Kernel 701, oracle 11g, AIX.

We have daily DBstats running,

updated BRtools patches,

have run "brconnect -u / -c -f stats -t all -f collect -p 4" manually,

dropped temp tables via SAP_DROP_TMPTABLES,

DBDIFF have /BIC/FATCO_ACT and /BIC/FATCO_RT

All these didnt help, could you please suggest how i can get this resolved.

Thanks and Regards,

Kiran

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 04, 2011 at 11:57 AM
    0

    Dear all,

    The issue is resolved by dropping the above index during BI loading by our BI consultants.

    Thanks and Regards,

    Kiran

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.