1897067 - MDX statement error:"The function call of RRMS_MESSAGE_HANDLING failed;" when creating a report. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1897067 - MDX statement error:"The function call of RRMS_MESSAGE_HANDLING failed;" when creating a report.

Symptom

  • Attempting to create a new web report.  Moving member into box gives this error:

web.png

MDX statement error:"The function call of RRMS_MESSAGE_HANDLING failed;"

  • Attempting to create an error in EPM Add-in gives this error:

addin.png

The execution of report Default report failed. Please contact your administrator.

Details:

Bad request.

Server message:

code: UJO_READ_EXCEPTION_000

severity: error

description: MDX statement error:"The function call of RRMS_MESSAGE_HANDLING failed;"

log id: KOm5Yty65V3X0800D2B}F0

DATAVALUE:The function call of RRMS_MESSAGE_HANDLING failed; a field may have been assigned to the parameter I_NUMBER whose type is not compatible with this

MDX: WITH  MEMBER [Measures].[YTD] AS 'IIF(([/CPMB/S0D08BZ                 PARENTH1].[2/CPMB/ACCTYPE]="INC" OR [/CPMB/S0D08BZ                 PARENTH1].[2/CPMB/ACCTYPE]="LEQ"),-([Measures].[/CPMB/SDATA], CLOSINGPERIOD([/CPMB/S0D8NVF                 PARENTH1].[LEVEL02])), ([Measures].[/CPMB/SDATA], CLOSINGPERIOD([/CPMB/S0D8NVF                 PARENTH1].[LEVEL02])))' SOLVE_ORDER=3  SELECT NON EMPTY  {[/CPMB/S0D8NVF                 PARENTH1].[2012.Q1                         /CPMB/S0D8NVF] ,[/CPMB/S0D8NVF                 PARENTH1].[2012.Q2                         /CPMB/S0D8NVF] ,[/CPMB/S0D8NVF                 PARENTH1].[2012.Q3                         /CPMB/S0D8NVF] ,[/CPMB/S0D8NVF                 PARENTH1].[2012.Q4                         /CPMB/S0D8NVF] ,[/CPMB/S0D8NVF                 PARENTH1].[2012.TOTAL                      /CPMB/S0D8NVF] } * {[/CPMB/S0D4C93                 PARENTH1].[APAC                            /CPMB/S0D4C93] ,[/CPMB/S0D4C93                 PARENTH1].[EU                              /CPMB/S0D4C93] ,[/CPMB/S0D4C93                 PARENTH1].[JV                              /CPMB/S0D4C93] ,[/CPMB/S0D4C93                 PARENTH1].[LATAM                           /CPMB/S0D4C93] ,[/CPMB/S0D4C93                 PARENTH1].[NA                              /CPMB/S0D4C93] ,[/CPMB/S0D4C93                 PARENTH1].[TOTAL_CONS                      /CPMB/S0D4C93] ,[/CPMB/S0D4C93                 PARENTH1].[CONSOL] ,[/CPMB/S0D4C93                 PARENTH1].[E_TOT] } ON 0  from  [/CPMB/S0MOMKR/!!O/CPMB/S0MOMKR]  WHERE ( [Measures].[YTD] ,[/CPMB/S0DM0HW                 PARENTH1].[ALL_AUDITID                     /CPMB/S0DM0HW] ,[/CPMB/S0DGD8W].[ARS] ,[/CPMB/S0DEMJJ                 PARENTH1].[TOTAL_DEST                      /CPMB/S0DEMJJ] ,[/CPMB/S0DMPE8                 PARENTH1].[END                             /CPMB/S0DMPE8] ,[/CPMB/S0DD58V                 PARENTH1].[TOTAL_FA                        /CPMB/S0DD58V] ,[/CPMB/S0D08BZ                 PARENTH1].[INC_STATEMENT                   /CPMB/S0D08BZ] ,[/CPMB/S0DXVZH                 PARENTH1].[TOP_DU01                        /CPMB/S0DXVZH] ,[/CPMB/S0D0PTD].[CORPORATE] ,[/CPMB/S0DKW96                 PARENTH1].[TOTAL_TP                        /CPMB/S0DKW96] ,[/CPMB/S0D74QT                 PARENTH1].[ACTUAL] )

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

Framework message:

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

  • In SLG1:

MDX statement error: The function call of RRMS_MESSAGE_HANDLING failed; a field may have been assigned to the parameter I_NUMBER whose type is not compatible with this

Message no. UJO_READ_EXCEPTION018
  • In MDXTEST this error is also thrown:

mdxtest.PNG

An error has been detected

Message no. BRAINOLAPAPI307


Read more...

Environment

SAP BusinessObjects Planning and Consolidation 10.X, version for SAP NetWeaver

Product

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver

Keywords

CATCH cx_badi_multiply_implemented,    cx_badi_not_implemented,    cx_badi_initial_reference INTO lr_exc, BADI epm bpc nw add-in web internet explorer report error create generate member dimension drag add , KBA , EPM-BPC-NW , NetWeaver Version , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.