Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 05:49 AM

    Hi

    Looking into notes : 159779

    regards

    KK

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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..

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.