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

[Former Member]

Dear all

We are in BI 7.0 and oracle 10.2.02 and OS AIX 5.3 and we are getting the ORA -12801 while attribute change run

and aggregates rollup.

plz help

Regards

Amiya Kumar

[Former Member]

solved

[Former Member]

Hi,

Could you please post the solution for this error, since I am facing the same error for "Create Index process type",

Thanks in advance, and point will be assigned for the help.

Regards,

Bheema

[Former Member]

Could you post your solution? I met this issue, too. Thanks!

[fidel_vales]

Hi,

ORA-0001 is "unique constraint violated"

It mean that your process is trying to insert a record that has the same primary key than another existing record.

You should try to find in which step the record is inserted and where it comes from to eliminate it.