Repeatedly receiving a error message Secondary indexes are missing

[Former Member]

Dear All,

In DB02-Alert message

Repeatedly receiving a error message Secondary indexes are missing,

I have manually created missing indexes before in Db02-Diagnostics-Missing table Indexes

Again by today same indexes are missing.

Thanks & Regards,

Rathish.S

[AtulKumarJain]

Hi Rathish,

Please check

http://scn.sap.com/thread/1624917.

Best Regards,

Atul

[Former Member]

Thanks Atul,

I have rebuild the indexes for the following files

/bio/fopa_c01-110

/bio/fopa_c01-100

/bio/fopa_c01-090

/bio/fopa_c01-080

/bio/fopa_c01-070

/bio/fopa_c01-060

/bio/fopa_c01-050

/bio/fopa_c01-040

/bio/fopa_c01-020

Is there any program to automatically rebuild the Indexes

Thanks and Regards,

Rathish

[former_member188883]

Hi Rathish,

Is your system SAP BI ?

If yes, you may include this process into daily process chains.

Regards,

Deepak Kori

[Former Member]

Thanks Deepak,

Yes it is a SAP BI system, Could you please elabrate the process and one of the Job in process chain is cancelled with a error unkown event

Thanks & regards

Rathish

[former_member188883]

Hi Rathish,

I am not a BI expert but could share some links having steps on process chains and index creation as well as deletion.

http://help.sap.com/saphelp_nw70/helpdata/en/67/13843b74f7be0fe10000000a114084/content.htm

http://scn.sap.com/thread/1657399

https://scn.sap.com/message/10947751

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Thanks Deepak,

By running the report SAP_INFOCUBE_INDEXES_REPAIR it repaired the missing Indexes and I have scheduled a job in a daily interval.

Best Regards,

Rathish.S

[former_member188883]

Hi Ratish,

Good to know your problem is resolved .You may close this thread.

Regards,

Deepak Kori