Skip to Content
author's profile photo
Former Member

Index not found for segment

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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

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

    Dear all,

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

    Thanks and Regards,

    Kiran

    Add comment
    10|10000 characters needed characters exceeded