Skip to Content
0

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

Aug 16, 2017 at 07:06 PM

92

avatar image
Former Member

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

h1-from-bw.jpg

system-details.jpg

h1-error.jpg (12.0 kB)
h1-from-bw.jpg (19.5 kB)
system-details.jpg (17.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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

Share
10 |10000 characters needed characters left characters exceeded