Skip to Content
avatar image
Former Member

ransaction DB02 shows the missing database objects

Dear all.

When i run DBO2 in sap BI 7.3

it is showing me following results

Consistency check of date

Objects missing in the database

Primary indexes 0

Secondary indexes 15

/BI0/F0TCT_C21-P

/BI0/F0TCT_C21-050

/BI0/F0TCT_C21-040

/BI0/F0TCT_C21-020

/BI0/F0TCT_C21-010

/BI0/F0TCT_C23-P

/BI0/F0TCT_C23-100

/BI0/F0TCT_C23-090

/BI0/F0TCT_C23-080

/BI0/F0TCT_C23-070

/BI0/F0TCT_C23-060

/BI0/F0TCT_C23-050

/BI0/F0TCT_C23-040

/BI0/F0TCT_C23-020

/BI0/F0TCT_C23-010

Tables 2

/BI0/HCALMONTH2

/BI0/ICALMONTH2

How should i correct this,we recently upgraded system deom BW 3.x to BI 7.3

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 30, 2011 at 07:47 PM

    Hello Abhi,

    Your BW team should answer this question. They will create secondary indexes on these tables if needed or you can simply ignore these alerts.

    Usually secondary indexes will be dropped during dataloads on daily basis and will recreate once completed.

    Thanks,

    Siva Kumar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      There is no need to panic as you can create secondary indexes. What all you can do is just beside the below missing secondary indexes you will find a create option click on it..there ends the issue.

      Secondary indexes 15

      /BI0/F0TCT_C21-P

      /BI0/F0TCT_C21-050

      /BI0/F0TCT_C21-040

      /BI0/F0TCT_C21-020

      /BI0/F0TCT_C21-010

      /BI0/F0TCT_C23-P

      /BI0/F0TCT_C23-100