Skip to Content
avatar image
Former Member

code: UJO_READ_EXCEPTION_018

HiThere,

I am getting the following error while running a report. How should I resolve this error. Thanks a lot!

Bad request.

Server message:

code: UJO_READ_EXCEPTION_018
severity: error
description: MDX statement error: Error occurred when starting the parser: Error when opening an RFC connection (CPIC-CALL: '
log id: KOeWMtbE5D3X0800mAZbuG
DATAVALUE:Error occurred when starting the parser: Error when opening an RFC connection (CPIC-CALL: '
MDX: WITH  MEMBER [Measures].[YTD] AS 'IIF(([/CPMB/MADPNUV                 PARENTH1].[2/CPMB/ACCTYPE]="INC" OR [/CPMB/MADPNUV                 PARENTH1].[2/CPMB/ACCTYPE]="LEQ"),-([Measures].[/CPMB/SDATA], CLOSINGPERIOD([/CPMB/MADGIUI                 PARENTH1].[LEVEL02])), ([Measures].[/CPMB/SDATA], CLOSINGPERIOD([/CPMB/MADGIUI                 PARENTH1].[LEVEL02])))' SOLVE_ORDER=3##MEMBER [Measures].[PERIODIC] AS 'IIF(([/CPMB/MADPNUV                 PARENTH1].[2/CPMB/ACCTYPE]="INC" OR [/CPMB/MADPNUV                 PARENTH1].[2/CPMB/ACCTYPE]="EXP") AND NOT ([/CPMB/MADGIUI                 PARENTH1].[2/CPMB/PERIOD]="TOTAL" OR  [/CPMB/MADGIUI                 PARENTH1].[2/CPMB/PERIOD]="Q1"  OR [/CPMB/MADGIUI                 PARENTH1].[2/CPMB/PERIOD]="JAN" ), [Measures].[YTD]-([Measures].[YTD],[/CPMB/MADGIUI                 PARENTH1].LAG(1)), [Measures].[YTD])' SOLVE_ORDER=3## MEMBER [Measures].[QTD] AS 'IIF(([/CPMB/MADPNUV                 PARENTH1].[2/CPMB/ACCTYPE]="INC" OR [/CPMB/MADPNUV                 PARENTH1].[2/CPMB/ACCTYPE]="EXP"),IIF([/CPMB/MADGIUI                 PARENTH1].[2/CPMB/TILEVEL]="QUARTER",[Measures].[PERIODIC],IIF([/CPMB/MADGIUI                 PARENTH1].[2/CPMB/TILEVEL]="MONTH" OR [/CPMB/MADGIUI                 PARENTH1].[2/CPMB/TILEVEL]="WEEK" OR [/CPMB/MADGIUI                 PARENTH1].[2/CPMB/TILEVEL]="DAY",SUM(PERIODSTODATE([/CPMB/MADGIUI                 PARENTH1].CURRENTMEMBER.PARENT.LEVEL, [/CPMB/MADGIUI                 PARENTH1].CURRENTMEMBER),[Measures].[PERIODIC]),NULL)),[Measures].[YTD])' SOLVE_ORDER = 3  SELECT NON EMPTY  {[/CPMB/MADPNUV                 PARENTH1].[BS000                           /CPMB/MADPNUV] ,[/CPMB/MADPNUV                 PARENTH1].[BS100                           /CPMB/MADPNUV] ,[/CPMB/MADPNUV                 PARENTH1].[BS200                           /CPMB/MADPNUV] } ON 0  from  [/CPMB/MAMJ1OI/!!O/CPMB/MAMJ1OI]  WHERE ( [Measures].[QTD] ,[/CPMB/MADEEOE                 PARENTH1].[Input] ,[/CPMB/MAD3X9E].[Actual] ,[/CPMB/MADGDQW                 PARENTH1].[Balance] ,[/CPMB/MADVHCG                 PARENTH1].[I_NONE] ,[/CPMB/MADD7TW].[EUR] ,[/CPMB/MADNUUT].[S_None] ,[/CPMB/MADGIUI                 PARENTH1].[2012.01] ,[/CPMB/MADVV1B].[TE1] )
V1:Error occurred when starting the parser: Error whe
V2:n opening an RFC connection (CPIC-CALL: '
V3:
V4:

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

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

R

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    May 14, 2013 at 12:52 AM

    Hi Rebecca,

    It is caused by the TCP\IP MDX PARSER. Please refer to note 1817817 and note 1032461.

    Regards,

    Hengye

    Add comment
    10|10000 characters needed characters exceeded

  • May 14, 2013 at 08:28 AM

    Hi Rebecca,

    see please this note http://service.sap.com/sap/support/notes/1859013

    and apply this one to solve the issue http://service.sap.com/sap/support/notes/1139396

    Kind regards

         Roberto

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 23, 2013 at 12:58 PM

    Hello Rebecca,

    I am having the same error message. When I execute the report several times, this error pops up for several times and then at a random iteration, the reports executes successfully.

    Did you find a solution for it?

    Thank you in advance,

    Joseph.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      You need to apply the note 1821859. Please check note 1932672 - UJO_READ_EXCEPTION_018 BPC 10NW.This is a BW program error.

      Regards,

      Varsha.

  • avatar image
    Former Member
    Nov 23, 2013 at 03:59 PM

    Hi,

    You need to apply the note 1821859. Please check note 1932672 - UJO_READ_EXCEPTION_018 BPC 10NW.This is a BW program error.

    Regards,

    Varsha.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 16, 2013 at 04:32 PM

    Hi Rebecca,


    Please apply note 1572695 and Run Connection Test on RFC Dstination MDX Parser.


    Thanks,

    Anil

    Add comment
    10|10000 characters needed characters exceeded