cancel
Showing results for 
Search instead for 
Did you mean: 

code: UJO_READ_EXCEPTION_018

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member196060
Contributor
0 Kudos

Hi Rebecca,

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

Regards,

Hengye

Answers (4)

Answers (4)

anil_agrawal
Active Participant
0 Kudos

Hi Rebecca,


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


Thanks,

Anil

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

former_member186498
Active Contributor
0 Kudos

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