A deadlock has occurred while attempting to access table UJA_DIM_HIE_MAP2

[Former Member]

Hello, While trying to refresh a report, I am getting this error. Any ideas?

[former_member182709]

This is a know bug. See KBA 2482309

1. Apply the note 2477835- Fix the inconsistence of hierarchy cache table
2. Go to t-code "SE38", run the program "UJA_REFRESH_DIM_CACHE" for the problematic model. Go to EPM add-in side and clear the metadata cache before testing it again.

[former_member186338]

The note provide a solution for BW 750 and 752, not for 751...

[former_member182709]

This note is also valid for BW 751. In the note, you can see the code valid from BW 750 to BW 751. Btw, the BPC code in BW 751 has the precise mapping between 750 and 751. BW 750 SP05 is the same as BW 751 SP00. See KBA 1826727 - BPC NW version mapping matrix

[former_member182709]

Yes. This note is delivered in BW 751 SP04. If the system is bewteen 751 SP01 and SP03. This note can be applied directly by snote

[former_member186338]

The note you are talking about is:

https://launchpad.support.sap.com/#/notes/2456568

[former_member186338]

Detiled info about versions, report screenshot, error screnshot!

[Former Member]

SP 29 , screenshot attached.

[former_member186338]

Not EPM version, but BPC and BW!

[Former Member]

BW -Release 751 SP Level 0002

CPMBPC - I couldnt find I guess its been replaced with CPMS4H. For CPMS4H - Release 200 SP Level - 0000