Solved: Error UJO_READ_EXCEPTION_018 refresh EXCEL

Former Member · ‎07-05-2018

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 · ‎07-12-2018

This SAP note resolved the issue:

2183923 - MDX: Termination when function ABS used

SeerOfSig · ‎07-06-2018

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

former_member186338 · ‎07-07-2018

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

Error UJO_READ_EXCEPTION_018 refresh EXCEL

Accepted Solutions (1)

Accepted Solutions (1)

Answers (2)

Answers (2)

New Enhancement related to GST trial balance (Mult...

I am getting error in sales order while entering W...

Is there any possible the conversation amount go t...

Import Vendor invoice on Public cloud

Re: What is the function of "Show All Objects" wit...