Skip to Content
author's profile photo Former Member
Former Member

Scheduling webi report error

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,

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Feb 06, 2012 at 10:07 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 06, 2012 at 11:19 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 06, 2012 at 11:38 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.