BI_BIA_NEWMD_INDEX in Process wait perpetually

[Former Member]

Hi All!

Subsequent to a sudden shutdown of BWA, certain master data indexes got corrupted and BWA indexing (roll up)of dependent cubes failed. Master data daemon job is now running for more than 13000 secs & job log shows "Process Wait 3" . The master data that its trying to index has 971,178 records in table RSDDTREXNEWSID. The WAITTIME & WRITETIME values have been increased. But the job is still stuck.

How to ensure successful completion of the  BI_BIA_NEWMD_INDEX job? Is there any alternative process to index the master data as the volume of data in RSDDTREXNEWSID is quite high?

Will highly appreciate suggestions from the community.

Thanks & regards,

Ruposhri

[Former Member]

Hi Ruposhri,

We are also facing the similar issue in our Production system.

Please suggest how did you resolve the issue at your end.

Regards,

Gunjan.