SQL Error: ORA-12801: error signaled in parallel query server P007

for ORA- 20000

check the note below it shows you have insufficient authorizations.

<b>Reason and Prerequisites</b>

You are using BW 7.00 with Support Package 07 or higher.

The BW module for the update statistics has been adjusted to SAPDBA or BRConnect (with regard to the heuristic, which is when, how and which statistics are created). To ensure that all table changes are taken into account, the relevant information must be flushed from the Oracle memory before the update statistics is carried out. For this purpose, the SAPCONN role (higher than ORA 10.2) or SAP SAP<sid> oder SAPR3 (ORA 10.1) requires additional authorizations that were not assigned up to now.

<b> Note 963760 - 'ORA-20000: Insufficient privileges' for creating statistics</b>

For Error -for SQL Error: ORA-01418: specified index does not exist

check note below-

<b>Note 337830 - BW: ORA-1418 in system log</b>

It seems that Index no longer exist which you are trying to delete.The 900 index, which exists on the F table only if the E table is partitioned, is deleted twice and on the second attempt it no longer exists.

<b>

Note 1003360 - BW fact tables: Deleting index from process chain terminates</b>

If it relates your error it requires corrections for SP-12.

Hope it Helps

Chetan

@CP..