Skip to Content
avatar image
Former Member

Problem with Hierarchy H1 for a specific dimension in BPC-locked by BPC_SERVICE

Hi all, we are facing an issue with Hierarchy H1 generation for a specific dimension, when I process the dimension it says the Hierarchy H1 is currently locked by BPC_SERVICE, and in the backed BW it always creates M version of hierarchy, it was working fine till yesterday, we copied this dimension and created a new one, that works perfectly fine.

We tested with another dimension which has H1 hierarchy, that also works fine.I cleared the cache using UJA_REFRESH_DIM_CACHE program but no luck, is there any issue or reason for not generating an active version of H1 for this dimension? I don't see any locks in SM12, I attached error messages and system details.




h1-error.jpg (12.0 kB)
h1-from-bw.jpg (19.5 kB)
system-details.jpg (17.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 19, 2017 at 10:23 PM

    Resolved this issue by clearing temporary tables using this program SAP_DROP_TMPTABLES.

    Add comment
    10|10000 characters needed characters exceeded