Scheduling webi report error

[Former Member]

Hi Guys,

How u all? Guys I need help from your side, While refreshing Webi report in 3.1, getting error:

A database error occured. The database error text is: Failed to execute MDX query. Reason: Inconsistent input parameter (parameter: <unknown>, value <unknown>). (WIS 10901).

Kindly help me.

Thanks,

[Former Member]

Hi,

This error is very common when the report is based on BW query.

1. try to schedule the reports and when selecting the prompt values click on refresh the prompt data which will pull the new data values from BW, many times it happens that we take the by default value when refreshing which may have a space etc.

if the above condition doesn't work try

2. I would recommend to refresh the universe structure and map the objects i.e. pull the objects again in the reports

or

last option would be to enable MDX and SOFA logs to get more details: (Instrucitons on capturing the MDX statement from the Webi Server can be found in SAP Notes 1260004, 1380517 or 1235111.)

Thanks,

aKs

[Former Member]

The error is common, when we tried refreshing the report in Web Intelligence based on BEx query universe. The reason for the error that the Universe created from BEx query is not up-to-date. It might happen due to the object (Characteristics / Key Figures) which was used in the BEx query is replaced / removed.

Resolution

1. Open Universe Designer -> Universe Name

2. View -> Refresh Structure

3. Update OLAP Universe Wizard appear, Click Ok

4. Save and Export the universe to the repository

[arijit_das]

have you passed the parameter values correctly in the prompt ? Can you refresh the report manually with same selection ?

[Former Member]

Thanks for reply, yes I have passed correct parameter values and also refreshed report manually, but geeting same error.

Any other idea??

Regards, Manoj