Skip to Content

UJO_READ_EXCEPTION_018 - Runtime error SQL error ssing program CX_RS_SQL_ with parallel processing

Hello Gurus,

I have a problem when I am refreshing a Report. Here is what I happened:

I have 10 dimension in my Model: Entity, Currency, PERIODO, Assumptions, Category, Profit Center, Cost Center, Accounts, Company Code and ZSTAGL.

The dimension PERIODO was a shared dimension with other model, I had to make some changes to that dimension so I decided to create the new Dim PERIOD0. So I created de dimension, get it in to the model and have the problem that now when I try to refresh a Report I got the next message:

I have tried to do a lot of thing that I have fond: Clearing the CACHE from EPM and from UJ tcode, I even activate and deactivate the ENVIRONMENTSHELL. I put back the original dimension, I checked the dimension Formula and its the same as the ENVIRONMENTSHELL. After some testing, I found out the next:

I was using the formula EPMDimensionOverride in the template I am having the problem with. When I delete the formula and set the PERIODO from Edit Report, the report seems to work fine, when I write the formula I got the message posted above.

What els can I do?? ;S

Sys info:

message.jpg (92.6 kB)
sys-info.png (33.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 25, 2017 at 08:09 PM

    Screenshot of you PERIODO dimension administration!

    Text of dimension formula with explanation!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 25, 2017 at 08:49 PM

    "just a dummy member is called NA" - absolutely bad idea! All members in TIME dimension has to be in 3 level structure!

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Vadim,

      I was searching for a Solution, I didn't want to apply note 2283395 - SQL5702 error returned from BPC report terminating with SQL30046 error - SAP BW on ASE, but Basis applied it.

      It solved the problem. In addition, while Basis was applying the note I construct another identical model with no problems.

      Thanks for the posts.

      Best Regards.