Error UJO_READ_EXCEPTION_018 refresh EXCEL

[Former Member]

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

[Former Member · Accepted solution]

This SAP note resolved the issue:

2183923 - MDX: Termination when function ABS used