Skip to Content
0
Former Member
Jan 30, 2007 at 07:59 AM

Deadlock ORA-00060 with Transformations

14 Views

Hi everyone,

we are on SP 10 together wih Oracle 10.2.0.2.0. In our development system I made already some big test loads (~Mio entries) from Data Store to cube. As sometimes in 3.0B we get a self-deadlock because processes killed each other, but now it happens more often. The bad thing with such an error from a Data Store to cube, that there is no possibility to make a manual update so a restart is necessary.

Has anyone suffered the same? Any proposals others than too less data or use PSA and Update-rules?

My current solution is to set the data-package size so high that the load is done in one package, what is really not a good solution. Is there a possibility to reduce the paralellility to one at a cube load other than my method?

Best regards

Harald.