Sql error:ORA-12801:error

[Former Member]

Hi,

This is a BW system.

There is lot of data in the cube table and now we are rolling up this table data into the Aggregate tables

We are getting this errror while running a job.

Sql error:ORA-12801:error signaled in parallel query server P001

Regards,

Rajiv

Edited by: Rajiv V on Oct 31, 2008 12:19 PM

[Former Member]

Issue resolved

[former_member204746]

check alert_SID.log for more clues.

also check SM21.

[Former Member]

hi,

This was resolved when the size of the file PSATEMP was increased.

Regards,

Visshwas

[Former Member]

Hi Rajiv,

ORA-12801: error signaled in parallel query server string

The cause for this error is A parallel query server reached an exception condition.

Action: Check the following error message for the cause, and consult your error manual for the appropriate action.

Thanks & Regards,

Sudheer.

[Former Member]

Hi sudheer...

Could you be more specific..

Thanks,

Rajiv

[Former Member]

follow note 651060 FAQ: Oracle Parallel Execution

cheers,

-Sunil

[Former Member]

The note says to check for

the real error message that accompanies the ORA-12801 error.

Here are more details.

SQL-END: 10/30/2008 14:27:06 00:42:07

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

Editing of aggregate 100033 in main process

Aggregate 100033(ZBW_CUST) is being filled

E table: block characteristic 0FISCPER, number of blocks: 4

Block 1: From SID 0 to SID 62006007 (with ChangeID = 0)

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

SQL Error: 12801