Error in Analysis for Office

[former_member302630]

A Bex query is working in BEx analyzer but does not work in Analysis for Office.

In BOA, we get error after we execute at the selection screen with inputs,

Program error in class SAPMSSY1 method : UNCAUGHT_EXCEPTION (RSBOLAP-000)

System error in Program CL_RSR_RRK0_MULTIPROV_BUFH and form _FILL_PARTPROV-01-(BRAIN-299)

Why is this happening?

Some links point to 1679490. But I find my support package for 7.3 more than sufficient at 14.

Regards,

Cleo

[former_member269156 · Accepted solution]

Hi,

Did you try

2552339 - Error CL_RSR_RRK0_MULTIPROV_BUFH and form _FILL_PARTPROV-01-

Thanks,

Raju

[former_member302630]

Did not get this note in SNOTE 2552339. It says incomplete.

[TammyPowlas]

There's no applying the note. The SAP Note resolution says "

Resolution

When using the multiprovider pruning feature based on table RRKMULTIPROVHINT, partprovider filters need to conform with the multiprovider they are used upon.

• You need to ensure that that queries based on multiproviders using this feature do not contain such filters (e.g. filled via a (customer exit) variable).
• If this cannot be ensured this optimization feature must not be used (you need to remove the affected multiprovider from table RRKMULTIPROVHINT)."

[former_member302630]

BOA version : 2.3.3.64113, Excel 2016.

No dump in ST22.

This phenomenon is happening only for this query. Other BEx queries are running fine in BOA and Analyzer.

[TammyPowlas]

Cleo - can you or your BW admin check ST22 for short dumps?

Which version of Analysis Office are you using? Which version of Excel?