Skip to Content

Issue with query on Webi

Good afternoon. I have a problem with a report in WebIntelligence. When i try create a report with a query appear this message:The error is only on prd with WebIntelligence because i make some tests with Analysis for Office and works fine, on dev works fine too. I make a retransport of the query and the results is the same. Any suggestion is accepted.

My version is BO 4.0 SP05 Pacht 3

Regards.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Oct 18, 2015 at 05:14 PM

    Hi,

    it seems issue with the BEx query variable.check if webi report is working in other env?

    might be you can check after assigning some default values in the BEx query variable.

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2015 at 08:16 AM

    Would you try assigning default values to your Bex query variable in Bex Query Designer? After that, check if your query works in WebI.

    Have a nice one.

    Add comment
    10|10000 characters needed characters exceeded

    • Zahid Yener Juan Elías Rivero Domínguez

      When I checked the error you are getting, it giving an error when the query is getting initialized with variables. For somehow, it's not getting the right variable values.

      If I were you, I would have opened a message to SAP support to find out what is really causing this error.

  • Oct 19, 2015 at 11:17 AM

    Hi Juan ,

    I guess there is no data in the Info Provider for the default values set for the variables .

    the default value which is set to variable may not be available in the Prod . Ex : In Dev , for a Year variable , 2010 is set as default . But in Prd there may not be data for 2010 .

    Remove all the default values set for variables and try .

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2015 at 07:41 PM

    Juan,

    Try to assign some default value from Bex query designer and try. This is exception caused while webi unable to read the empty variable from bex. If this still persists, try to reboot SIA, tom cat servers at the end of the day and see if it resolves. I had these issues and have to try multiple ways to fix.

    Regards

    Venkat 

    Add comment
    10|10000 characters needed characters exceeded