ransaction DB02 shows the missing database objects

[Former Member]

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

[Former Member]

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

[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