Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 22 at 09:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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