System error in program SAPLRRSI and form RRSI_SID_VAL_CONVERT-1-

[Former Member]

Hi everyone,

I’m having an error while refreshing any IFRS Starter Kit’s reports in BPC 10.1.

• In EPM it shows the following error information:

One or more errors occurred.

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

Bad request.

Server message:

code: UJO_READ_EXCEPTION_018

severity: error

description: MDX statement error: System error in program SAPLRRSI and form RRSI_SID_VAL_CONVERT-1-

log id: 051MdW4I7jMMtc7kT{Vp6m

DATAVALUE:System error in program SAPLRRSI and form RRSI_SID_VAL_CONVERT-1-

MDX: WITH  MEMBER [Measures].[YTD] AS 'IIF(([/CPMB/ODD6RE4 PARENTH1].[2/CPMB/ACCTYPE]="INC" OR [/CPMB/ODD6RE4                 PARENTH1].[2/CPMB/ACCTYPE]="LEQ"),-([Measures].[/CPMB/SDATA], CLOSINGPERIOD([/CPMB/ODDM4FG PARENTH1].[LEVEL02])), ([Measures].[/CPMB/SDATA], CLOSINGPERIOD([/CPMB/ODDM4FG PARENTH1].[LEVEL02])))' SOLVE_ORDER=3 SELECT NON EMPTY  {[/CPMB/ODDOJMZ                 PARENTH1].[F00] ,[/CPMB/ODDOJMZ PARENTH1].[F99] } * {[/CPMB/ODDCPTJ                 PARENTH1].[ALL_INPUT                       /CPMB/ODDCPTJ] ,[/CPMB/ODDCPTJ PARENTH1].[INPUT] ,[/CPMB/ODDCPTJ PARENTH1].[LOCAL_ADJ] } * {[/CPMB/ODD6RE4 PARENTH1].[TA000                           /CPMB/ODD6RE4] ,

...

                 PARENTH1].[L2610] ,[/CPMB/ODD6RE4 PARENTH1].[L2620] ,[/CPMB/ODD6RE4                 PARENTH1].[L26BU] ,[/CPMB/ODD6RE4 PARENTH1].[L3000] } ON 0 from  [$/CPMB/ODMXPPH]  WHERE ( [Measures].[YTD] ,[/CPMB/ODDDGVT].[LC] ,[/CPMB/ODD1IHH PARENTH1].[I_NONE] ,[/CPMB/ODDNSIT].[S_NONE] ,[/CPMB/ODDD0SI].[ACTUAL] ,[/CPMB/ODDM4FG PARENTH1].[2015.TOTAL                      /CPMB/ODDM4FG] ,[/CPMB/ODDJ20C PARENTH1].[CONSO] )

V1:System error in program SAPLRRSI and form RRSI_SID

V2:_VAL_CONVERT-1-

V3:

V4:

• Through "EPM Log" I can see the following information:

Framework message:

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

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

2015-09-14 17:12:56,244|ERROR|BPCProxy|FPMXLClient.BPCProxy.Common.Wcf.InterceptorChannelFactory`1+InterceptorRequestChannel.Request|JCHAVEZH|||||1|The remote server returned an unexpected response: (400) Bad Request.#

2015-09-14 17:12:56,260|ERROR|Dataservice|FPMXLClient.BPCProxy.MetaData_Data.DataServiceHelper.ExecuteReportAsGzipStream|JCHAVEZH|||||1|The remote server returned an unexpected response: (400) Bad Request.#

2015-09-14 17:12:56,260|ERROR|BPC10Connection|FPMXLClient.Connection.RESTConnection.ExecuteReport|JCHAVEZH|||||1|The remote server returned an unexpected response: (400) Bad Request.#

2015-09-14 17:12:56,276|ERROR|OfficeWrappers|FPMXLClient.Office.EPMReportManager.ExecuteReport|JCHAVEZH|||||1|The remote server returned an unexpected response: (400) Bad Request.#

2015-09-14 17:12:56,276|ERROR|OfficeWrappers|FPMXLClient.Office.EPMExcelReportManager+<>c__DisplayClass3b.<ExecuteParallelizedReportsFramework4>b__38|JCHAVEZH|||||1|The remote server returned an unexpected response: (400) Bad Request.#

2015-09-14 17:12:56,291|ERROR|AnalyzerOne|FPMXLClient.Office.EPMExcelWorkBookManager.RefreshBook|JCHAVEZH|||||1|Error in refresh sheet#

2015-09-14 17:12:56,447|ERROR|AnalyzerOne|FPMXLClient.AddIn.ExecuteUICommand|JCHAVEZH|||||1|Error in refresh sheet#

• And through SLG1 (BW), I can see same error:

@5C\QError@   MDX statement error: System error in program SAPLRRSI and form RRSI_SID_VAL_CONVERT-1-                @5F\QNo detail exists@

Looking for to try to solve it, I’ve found something relative to this issue (SAP Note 1868492) it says that "there is a program error" and to solve it (in SAP NW BW 7.4) I need to upgrade to SP4, but I have installed SP11.

Is there someone who knows how to solve it?

Thanks very much in advance.

Regards,

Fernando.

[former_member186338]

Hi Fernando,

Please, provide your BW and BPC version and SP like here:

Vadim

[Former Member]

Hi Vadim,

I've added a image with BPC, EPM, NW and Office version.

Thanks very much.

Regards,

Fernando.

[Former Member]

Hi Vadim,

If I remove all members pertaining to column H1, reporting work fine (new reports and standard Starter Kit reports). But if I rebuild it (I've checked it is consistent) the error appears again. Do you know what can I do?

Thanks in advance.

Regards,
Fernando.

[former_member186338]

"If I remove all members pertaining to column H1" - Sorry, but what dimension you are talking about?

[Former Member]

Error appears when in reporting I select a parent member in any dimension and select any option regarding to its children (Member and Children, Member and Descendant...).

If I remove parents, such as Account, error disappears.

At the begin I though the problem could be concerning interconnection between BW and BPC, but I'm realizing the problem is in hierarchies...but I don't know how to solve it.

I attached SLG1 error screenshot:

Thanks.

[former_member186338]

Have you changed anything in BW related to BPC cubes?