Skip to Content

UJO_READ_EXCEPTION_018 in BPC 10.0 for NW

Hi experts, i've been trying to find a solution for this error, but i couldn't find anything about it

There's a lot of post about UJO_READ_EXCEPTION_018 but none of them seems to be the problem i'm facing

it happens when i try to create a new report in Excel on EPM add-in under specific circumstances, let me know if they're relevant

here's the error:

"One or more errors occurred.

The execution of report Default Report failed. Please contact your administrator.

Bad request.

Server message:

code: UJO_READ_EXCEPTION_018

severity: error

description: MDX statement error: Value KXX001 /CPMB/NBDIE82 for characteristic /CPMB/NBDIE82 unknown

log id: 051MX7cx7jIPXc9wWOLin0

DATAVALUE:Value KXX001 /CPMB/NBDIE82 for characteristic /CPMB/NBDIE82 unknown

MDX: SELECT NON EMPTY {[/CPMB/NBDIE82 PARENTH1].[KXX001 /CPMB/NBDIE82] ,[/CPMB/NBDIE82 PARENTH1].[KXX002 /CPMB/NBDIE82] ,[/CPMB/NBDIE82 PARENTH1].[KXX005 /CPMB/NBDIE82] ,[/CPMB/NBDIE82 PARENTH1].[KXX003] ,[/CPMB/NBDIE82 PARENTH1].[KXX004] ,[/CPMB/NBDIE82 PARENTH1].[KXX006] ,[/CPMB/NBDIE82 PARENTH1].[KXX007] ,[/CPMB/NBDIE82 PARENTH1].[KXX008] ,[/CPMB/NBDIE82 PARENTH1].[KXX009] ,[/CPMB/NBDIE82 PARENTH1].[KXX010] } ON 0 from [/CPMB/NBMGQRA/!!O/CPMB/NBMGQRA] WHERE ( [Measures].[/CPMB/SDATA] ,[/CPMB/NBDIVUT PARENTH1].[TOT_CANAL /CPMB/NBDIVUT] ,[/CPMB/NBDI0JB PARENTH1].[TOT_BSMX /CPMB/NBDI0JB] ,[/CPMB/NBDIFIU PARENTH1].[AUX_DATASOURCE] ,[/CPMB/NBDIRO8 PARENTH1].[TOT_MERCADO /CPMB/NBDIRO8] ,[/CPMB/NBDM9JH].[2012] ,[/CPMB/NBD6ZEJ PARENTH1].[TOT_PROD /CPMB/NBD6ZEJ] ,[/CPMB/NBDCQEQ].[EUR] ,[/CPMB/NBDY3PN PARENTH1].[2006.TOTAL /CPMB/NBDY3PN] ,[/CPMB/NBDI7BQ].[V1] ,[/CPMB/NBDIW8M].[ACTUAL] )

V1:Value KXX001 /CPMB/NBDIE82 for characteristic /CPM

V2:B/NBDIE82 unknown

V3:

V4:

-----------------

Framework message:

Remote server Error: (400) Incorrect Request "

I'll apreciate any help or advice.

Thank you very much.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Posted on Nov 18, 2015 at 08:16 PM

    My suggestion is to save and process your dimensions. You have a disconnect somewhere. My account dimension had changed drastically just before I got that error. Processing the account dim fixed it. Good luck.

    -Jon

    Add a comment
    10|10000 characters needed characters exceeded

    • You are right Jon, processing dimensions has fixed most of such issues for me as well. But this was one off case, where if I remember it correctly "MDX: SELECT NON EMPTY" was the key word in the error message (as mentioned above). And when I checked TCP/IP connection through SM59, the connection test failed. Ideally, it should always pass.

      -Rishi

  • Posted on Nov 05, 2014 at 08:41 AM
    Add a comment
    10|10000 characters needed characters exceeded

    • Hi, Thank you for your answer, however, the first note suggest to apply the SP 08 for BW, and we're currently in the SP 12 of that component, the second note it's about the UJO_READ_EXCEPTION, but does not have the same description, and it does not look like it will help, it also requires to patch the kernel, we're in Kernel 720 patch 600 according to system status, please let me know if you still think that the second note could be helpfulll

      Thank you

  • Posted on Nov 05, 2014 at 02:55 PM

    Hi,

    UJO_READ_EXCEPTION_018 is standard read error that can occur from multiple reasons.


    In your case, it looks like you are trying to retrieve some values related to dimension "/CPMB/NBDIE82" for Value "KXX001". Can you elaborate more on this dimension and member details concentrating on member

    KXX001 ?


    Prat


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2015 at 07:12 AM

    I am facing the similar issue now. Kindly suggest me the solution for this.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2015 at 07:25 AM

    Hi Leonardo,

    Did check this SAP note:

    2127175 - UJO_READ_EXCEPTION_018 with MDX statement error: Value & for

    characteristic & unknown

    I think it is relevant to your case. I hope it will help.

    Regards,

    Safa


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 24, 2015 at 10:54 AM

    Login into BW

    Run transaction code SM59 > TCP/IP connections > MDX Parser > Run "connection test"

    If it fails with timeout error, please ask your basis team to update it with the recent version or look into it.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.