DTP got failed in BW due to Dump Error

[former_member659381]

Error Message in DTP:

Dump: Internal session terminated with a runtime error DBSQL_SQL_ERROR (see ST22) Data Package 000003 in BW.

In ST22, it is showing as :

Database error text: "sql message:ora-00060:deadlock detected while waiting for resource.

Could you please help me to provide solution for this?

[DotEiserman]

Hi Suresh,

Can you let us know what version of BW you're using, as well as what type of object you're loading into.

Perhaps review the following note so long:

1944924 - Deadlock ORA-00060 during parallel loading/activation of BW ODS object - SAP ONE Support L...

Thanks

Dot

[former_member659381]

Hi ,

I am using BW 7.7 and also loading transaction data into F fact table of Infocube through DTP.

I have tried to process the data packages manually but again its failing.

Please let me know the analysis and resolution?

Regards,

Suresh

[DotEiserman]

Hi Suresh,

Did you load the data package by package and still got deadlock? I would open a ticket with SAP.

Thanks

Dot

[FCI]

Deadlocks occuring when loading an infoCube are generally due to the indexes. Try to delete these indexes (RSA1/Admin on the cube, tab peformance) before loading the cube and recreate them afterwards.

Regards,

Frédéric

[DotEiserman]

Hi Frederic,

Agreed, that could definately also cause the issue.

1692199 - Short Dump DBIF_RSQL_SQL_ERROR / WRITE_ICFACT

Thanks

Dot