Skip to Content
avatar image
Former Member

While generating the report, I get the Error saying 'UJO_READ_EXCEPTION_018

Hi Guys,

While generating the report from the consolidation model, I get the attached error message saying ' UJO_READ_EXCEPTION_018'.

The Remote server returned error. (400) Bad Request.

Could you please let me know how to resolve this.

Enclosed the copy of the system details. Using BPC 10.0 NW.

Server message:

code: UJO_READ_EXCEPTION_018
severity: error
description: MDX statement error: Syntax error: Syntax Error : ... PARENTH1].[LEVEL02])))' SOLVE_, row 0, item: 0
log id: MDzDh5B3383X0800j078M0
DATAVALUE:Syntax error: Syntax Error : ... PARENTH1].[LEVEL02])))' SOLVE_, row 0, item: 0
MDX: WITH MEMBER [Measures].[YTD] AS 'IIF(([/CPMB/PMD4BY2 PARENTH1].[2/CPMB/ACCTYPE]="INC" OR [/CPMB/PMD4BY2 PARENTH1].[2/CPMB/ACCTYPE]="LEQ"),-([Measures].[/CPMB/SDATA], CLOSINGPERIOD([/CPMB/PMDRHHI PARENTH1].[LEVEL02])), ([Measures].[/CPMB/SDATA], CLOSINGPERIOD([/CPMB/PMDRHHI PARENTH1].[LEVEL02])))' SOLVE_ORDER=3##MEMBER [Measures].[PERIODIC] AS 'IIF(([/CPMB/PMD4BY2 PARENTH1].[2/CPMB/ACCTYPE]="INC" OR [/CPMB/PMD4BY2 PARENTH1].[2/CPMB/ACCTYPE]="EXP") AND NOT ([/CPMB/PMDRHHI PARENTH1].[2/CPMB/PERIOD]="TOTAL" OR [/CPMB/PMDRHHI PARENTH1].[2/CPMB/PERIOD]="Q1" OR [/CPMB/PMDRHHI PARENTH1].[2/CPMB/PERIOD]="JAN" ), [Measures].[YTD]-([Measures].[YTD],[/CPMB/PMDRHHI PARENTH1].LAG(1)), [Measures].[YTD])' SOLVE_ORDER=3 SELECT NON EMPTY {[/CPMB/PMD4BY2 PARENTH1].[EQT /CPMB/PMD4BY2] ,[/CPMB/PMD4BY2 PARENTH1].[NAL /CPMB/PMD4BY2] ,[/CPMB/PMD4BY2 PARENTH1].[TBS /CPMB/PMD4BY2] } ON 0 from [/CPMB/PMMP18Y/!!O/CPMB/PMMP18Y] WHERE ( [Measures].[PERIODIC] ,[/CPMB/PMDVTMP PARENTH1].[INPUT] ,[/CPMB/PMDE95O PARENTH1].[TOTAL_BU /CPMB/PMDE95O] ,[/CPMB/PMDV77J PARENTH1].[ACTUAL] ,[/CPMB/PMDJCGW PARENTH1].[G_NONE] ,[/CPMB/PMD3DTV].[LC] ,[/CPMB/PMDN85F PARENTH1].[SG06] ,[/CPMB/PMDBVEB PARENTH1].[CLOSE /CPMB/PMDBVEB] ,[/CPMB/PMDRHHI PARENTH1].[2016.FEB] ,[/CPMB/PMDBPF0 PARENTH1].[I_NONE] )
V1:Syntax error: Syntax Error : ... PARENTH1].[LEVEL0
V2:2])))' SOLVE_, row 0, item: 0
V3:
V4:

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

Framework message:
The remote server returned an error: (400) Bad Request.

Regards,

Raj.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 04, 2017 at 08:41 AM

    Looking on your BW and BPC SP I can see that you have very old versions. Please upgrade to something recent.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 03, 2017 at 05:38 AM

    Detailed info on BPC and BW SP's required. Also screenshot of the time dimension administration.

    P.S. Primary tag is incorrect, change it to secondary.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 03, 2017 at 08:01 AM

    Hi Vadim,

    Enclosed the below items.

    1. SAP BPC.

    2.sap-bw.png

    3.time-dim.png

    Regards,

    Raj.

    Add comment
    10|10000 characters needed characters exceeded