Skip to Content
0

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

Feb 17 at 06:08 PM

104

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Feb 20 at 09:49 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Andras Margitics
Feb 22 at 09:51 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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
0