We are getting an error: "RUN_LOGIC: Error obtaining concurrency lock (foreign_lock)" in the formula log after submitting several data manager packages jobs running the same script file with different selection for Category/Entity/Time.
Solution:
You are having this issue because of BPC concurrent lock.
For BPC NW 7.0 and 7.5 version:
First, you have to Logon ABAP server and execute transaction UJR0 then find AppSet/Application and find parameter RECLEVEL_NR, increase the value, make it larger than parameter PACKAGE_SIZE.
Now save the result and run the package again.
For BPC NW 10.0 version:
First Logon ABAP server and execute transaction SPRO ->SAP reference IMG ->Planning and consolidation ->Configuration parameters ->Set model parameters then find Environment/Model and find parameter RECLEVEL_NR, increase the value, make it greater than parameter PACKAGE_SIZE.
Now Save the result and Run package again.
NOTE: By greater (in Step 4) try increasing RECLEVEL_NR parameter by 20% higher than PACKAGE_SIZE value
(Ex: PACKAGE_SIZE=40000 set RECLEVEL_NR to 48000)