Dead lock occured in DTP when data loading from Cube to Cube

[former_member198905]

Hi

I am loading data from one cube to other cube which is copy of source cube approx. 2.5 billion records but dead lock (ORA-00060: deadlock detected while waiting for resource) occurred in parallel processing 1st I tried 8 then 5 and then 3 parallel processes in DTP but dead lock occurred after 10-16hr.

How to resolve this issue?

Thanks

[Former Member]

Hi Imran,

Is this a delta load? I would suggest to check and increase parameter INITRANS in table RSADMIN, according to note:

750033 - INITRANS parameter for InfoCube secondary indexes

Also, execute report SAP_INFOCUBE_INDEXES_REPAIR from SE38 to target InfoCube.

Table reorg should be also an additional option:

1360603 - Reorganizing and rebuilding individual partitions

84348 - Oracle deadlocks, ORA-00060

Plus:

1842044 - ORACLE: dataload without dropping bitmap indexes

1946893 - ORA-00060 Deadlock in Cube load

1692199 - Short Dump DBIF_RSQL_SQL_ERROR / WRITE_ICFACT

Hope it helped,
Best regards, Andras

[former_member198905]

Hi Andras

Thanks for reply. Its a filtered load from cube1 to cube2 i.e.data for year 2018 only. When I load it in sequentially, loading processes completed in 24Hr and other cubes have approx. 3.5 billion records so it is not feasible to load it sequentially.

• Note:750033 for BW3.x
• Target Cube is new and empty

[RamanKorrapati]

Hi,

Data volume is very high, please do your load where there is no loads on your bw system or do it on weekend.

Deadlock will occur when other loads might be happening to your source/Target cube during your load time. to avoid such issues, Please run your load where there is no other loads scheduled.

Thanks

Raman