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

[Former Member]

Hi all

I am getting the following error when doing aggregation for a cube

<b>SQL Error: ORA-12801: error signaled in parallel query server P007.</b>Job is showing as finished but no aggregation is hapenning.

regards

KK

[Former Member]

Hi

Looking into notes : 159779

regards

KK

[Former Member]

did that work?

few more ..

Note 651060 - FAQ: Oracle Parallel Execution

Note 785732 - ORA-12801 and ORA-1652 when using MERGE for compression

Note 986631 - ORA-12801, ORA-600: [32695] during an attribute run

Hope it Helps

Chetan

@CP..

[Former Member]

Chetan,

No still I am getting the same Problemmm

I am facing the problm only when I am activating my aggregates

Regards

KK

[Former Member]

Hi chetan,

Some more errors that I am facing .....

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

SQL Error: ORA-20000: Insufficient privileges

SQL Error: ORA-20000: Insufficient privileges

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

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

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

SQL Error: ORA-20000: Insufficient privileges

SQL Error: ORA-20000: Insufficient privileges

Regards

KK

[Former Member]

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..