Skip to Content

Error UJO_READ_EXCEPTION_018 refresh EXCEL

Hi Experts,

While refresh report, 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?

BW and BPC version:

Error message:

One or more errors occurred.

The execution of report Informe predeterminado failed. Please contact your administrator.
Bad request.

Server message:

code: UJO_READ_EXCEPTION_018
severity: error
description: MDX statement error: Syntax error: Syntax Error : ..., row 55.876, item: 55.876
log id: 051Mi6E07jYWajmoowcx3m
DATAVALUE:Syntax error: Syntax Error : ..., row 55.876, item: 55.876
MDX: SELECT NON EMPTY {[/CPMB/ZSDIQGX PARENTH1].[2018.TOTAL /CPMB/ZSDIQGX] ,[/CPMB/ZSDIQGX PARENTH1].[2018.01] ,[/CPMB/ZSDIQGX PARENTH1].[2018.02] ,[/CPMB/ZSDIQGX PARENTH1].[2018.03] ,[/CPMB/ZSDIQGX PARENTH1].[2018.04] ,[/CPMB/ZSDIQGX PARENTH1].[2018.05] ,[/CPMB/ZSDIQGX PARENTH1].[2018.06] ,[/CPMB/ZSDIQGX PARENTH1].[2018.07] ,[/CPMB/ZSDIQGX PARENTH1].[2018.08] ,[/CPMB/ZSDIQGX PARENTH1].[2018.09] ,[/CPMB/ZSDIQGX PARENTH1].[2018.10] ,[/CPMB/ZSDIQGX PARENTH1].[2018.11] ,[/CPMB/ZSDIQGX PARENTH1].[2018.12] } * {[/CPMB/ZSDJRVE PARENTH1].[C400100 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500311T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500314T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500317 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500318T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500320T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500370 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500371T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500380 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500381 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500382T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500384 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500385 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500389T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500400T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500402T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500403T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500404T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500405T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500406T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500408T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500409T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500410T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500421 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500422 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500430T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500431T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500433T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500436T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500440T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500441T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500461T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500501T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500502T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500505 /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C500506T /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[CTO_FINANC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[DIF_CAMB /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[GAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[GCPEACTOPE /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[GCPEANTIMP /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[GCPEOPCONT /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[GTOIMPGCIA /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[ING_ACT_ORD /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[ING_FINANC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[OTRAS_PERD_GANAN /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[OTROS_ING /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[OTRO_GTOXFUNC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAREQUPRPCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAREQUTERCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAARREQUIPCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAARRINMBCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAARRINMBGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAARRINMUGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAASESGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAASESIACV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAUDITGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAUTORCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAUTORCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAUTORGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAUTORGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSABSCOMGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACIPERSCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACMRCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACMRGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACMRGAV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACOMISCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACOSTOFCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACOSTOFCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACOSTSEGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACOSTSEGCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACOSTSEGCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACOSTSEGGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSADEMURRAGCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSADEPAMORCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSADEPAMORGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSADEPAMORGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSADIFPREC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSADONACGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOADMBACKOFFICEGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOADMGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOBANCGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOBANCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOISOGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOOFGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOOFGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTOPROYGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTORECH /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTORECHCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAGTORECHGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAINGRESOS /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAINRCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAINRGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAINRGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAIVACV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAIVAGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAMARKCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAMARKGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAMARKGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAMATOPERCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAMGBRUTO /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAMGOPERAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAOTCOSPGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAOTGTORHGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPARTSAAMCL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPEREJECGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERGRALGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSAAMGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSSAAMCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSSAAMCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSTERCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSTERCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERTERGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERTERGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPROVGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPROYECTOCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPSGRALGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPSSAAMGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSARSTDOCTBLE /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASISCOMCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASISCOMGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASISTCOMGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSADMCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSADMGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSAGMACV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSBASICGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSBASICGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSBASICV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSDYMCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSFLOTACV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSINPERGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSINSPERCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSINSPERCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSINSPGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSLOGCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSOPERCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSPORTCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSTRANSCV /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASSTRANSGAL /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSATOTCTOS /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSATRANSPCF /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAVALLIQGAC /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAVEAS /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[RES_UNI_REAJ /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[VP /CPMB/ZSDJRVE] ,[/CPMB/ZSDJRVE PARENTH1].[C400100C] ,[/CPMB/ZSDJRVE PARENTH1].[C400100I] ,[/CPMB/ZSDJRVE PARENTH1].[C500200] ,[/CPMB/ZSDJRVE PARENTH1].[C500301] ,[/CPMB/ZSDJRVE PARENTH1].[C500302] ,[/CPMB/ZSDJRVE PARENTH1].[C500303] ,[/CPMB/ZSDJRVE PARENTH1].[C700508] ,[/CPMB/ZSDJRVE PARENTH1].[C700509] ,[/CPMB/ZSDJRVE PARENTH1].[C700510] ,[/CPMB/ZSDJRVE PARENTH1].[C700511] ,[/CPMB/ZSDJRVE PARENTH1].[C700512] ,[/CPMB/ZSDJRVE PARENTH1].[C700520] ,[/CPMB/ZSDJRVE PARENTH1].[C700521] ,[/CPMB/ZSDJRVE PARENTH1].[C700530] ,[/CPMB/ZSDJRVE PARENTH1].[C700531] ,[/CPMB/ZSDJRVE PARENTH1].[C700532] ,[/CPMB/ZSDJRVE PARENTH1].[C700534] ,[/CPMB/ZSDJRVE PARENTH1].[C700535] ,[/CPMB/ZSDJRVE PARENTH1].[C700537] ,[/CPMB/ZSDJRVE PARENTH1].[C700540] ,[/CPMB/ZSDJRVE PARENTH1].[C700541] ,[/CPMB/ZSDJRVE PARENTH1].[C700542]...................................................................................................................,[/CPMB/ZSDJRVE PARENTH1].[C9000403] ,[/CPMB/ZSDJRVE PARENTH1].[C9000404] ,[/CPMB/ZSDJRVE PARENTH1].[C9000405] ,[/CPMB/ZSDJRVE PARENTH1].[C9000406] ,[/CPMB/ZSDJRVE PARENTH1].[C9000407] ,[/CPMB/ZSDJRVE PARENTH1].[C990000] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAAUDITCV] ,[/CPMB/ZSDJRVE PARENTH1].[PCSACIPERSCV] ,[/CPMB/ZSDJRVE PARENTH1].[PCSAPERSGRALCV] ,[/CPMB/ZSDJRVE PARENTH1].[PCSASISCOMCV] } ON 0 from [$/CPMB/ZSMMMOH] WHERE ( [Measures].[/CPMB/SDATA] ,[/CPMB/ZSDN624 PARENTH1].[AG_ALL /CPMB/ZSDN624] ,[/CPMB/ZSDZF58 PARENTH1].[AuditTotal /CPMB/ZSDZF58] ,[/CPMB/ZSDKSFY PARENTH1].[SAAM_CC /CPMB/ZSDKSFY] ,[/CPMB/ZSDMQ48 PARENTH11].[SIN_CLI] ,[/CPMB/ZSDM28D PARENTH2].[SEG_NA /CPMB/ZSDM28D] ,[/CPMB/ZSDIHWJ PARENTH1].[S_MON] ,[/CPMB/ZSDOM2S PARENTH1].[LC] ,[/CPMB/ZSDPFYF].[SAAM] ,[/CPMB/ZSDVHVY].[Plan] ,[/CPMB/ZSDTQXZ].[NA] )
V1:Syntax error: Syntax Error : ..., row 55.876, item
V2:: 55.876
V3:
V4:

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

Framework message:
Error en el servidor remoto: (400) Solicitud incorrecta.

Error en el servidor remoto: (400) Solicitud incorrecta.

Regards,

Pedro Cueva

bpc4.png (8.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Jul 12, 2018 at 09:26 PM

    This SAP note resolved the issue:

    2183923 - MDX: Termination when function ABS used

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 06, 2018 at 11:22 AM

    Can be many reasons.

    Is this a new or existing report?

    Did the refresh work correctly previously and suddenly generate this error?

    Does issue only occur for one report or all reports?

    Does it occur for only one model or all models?

    If you have multiple environments, does it occur in all environments?

    Are you using HANA MDX?

    If no, does the error occur when executing the MDX query directly in MDXTEST?

    If yes, does the error occur when executing the MDX query directly in UJHANAMDX or Run UJHANA_MDX_TEST in SE38

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 07, 2018 at 05:47 PM

    Second hierarchy in TIME dimension is not supported! Remove it!

    Add comment
    10|10000 characters needed characters exceeded