Error when refreshing the template??

[Former Member]

Hi All,

Please help on the below error. We are using SAP BPC 10.1 classic and BW on HANA

Thanks,

Naidu

[anil_agrawal · Accepted solution]

Hi Naidu,

If an unknown hierarchy node is used, the MDX statement execution terminates. The calling program receives the error message.

You must set the RSADMIN parameter MDX_ACCEPT_UNKNOWN_NODES to the value X. You can set, change, or delete this parameter using the report SAP_RSADMIN_MAINTAIN.

Thanks

Anil

[Former Member · Accepted solution]

Hi Anil,

Thanks for quick response.

RSADMIN parameter has already set to X only.

Thanks,

Naidu

[gajendra_moond · Accepted solution]

Is there any short dump in the backend? If so, please share.

[damovand]

Hello,

MDX query errors can happen for a variety of reasons including some required HANA tables not being available.  There are many notes available for HANA related issues.  My recommendations is to focus one the ones that will help you get the MDX or SQL query that is failing to execut.

If you can capture either the SQL or the runtime MDX query you can then execute them directly and get more detailed error.

To get the runtime MDX use either SLG1 or UJSTAT.  Please follow the instructions in note 2086208 and execute the query to get a more detailed error.

You can also capture the SQL query and then execute the query directly on HANA server. You can get the query by enabling the HANA trace using DBCOKPIT or DB02.  Please follow the instructions in notes 1998549 or 2119087.

The query will also show in the system log, using SM21 check system errors.  To get the runtime MDX use either SLG1 or UJSTAT.  Please follow the instructions in note 2086208 and execute the query to get a more detailed error.

After you have the query that is causing the error you can execute it directly on HANA studio. That will show you more specific HANA related errors.  I hope this helps.

Best Regard

[Former Member]

Hi Team,

Thanks all for ur replies.

We have got solution from SAP team and note was released on the same (sap note: 2238086)

Regards,

Naidu