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

WEBI 4.0 multiple query problem with filter

Dear All.

i have two queries on WEBI running, and both are containing same filter, in 3.x when we run the report single prompt appear and get the values and apply on all the queries, but on WEB 4.0 when i try to run the query i am getting the following error.

Cannot build the query or generate the report. (WIS 30351) (WIS 30351)

however when i run each query separtely from the same WEBI document it runs without problem, i have to use some calculated measure from the 2nd query on my combine report and for that both queries should run at once, i am doing the same thing on WEBI 3.x without any problem.

if some body face this issue kindly please guide me.

and here is the detail exception.

com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: Cannot build the query or generate the report. (WIS 30351)

at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:144)

at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:101)

at com.businessobjects.sdk.core.server.common.CommonRequestHandler.afterProcessing(CommonRequestHandler.java:122)

at com.businessobjects.sdk.core.server.internal.AbstractServer.processIt(AbstractServer.java:178)

at com.businessobjects.sdk.core.server.internal.AbstractServer.process(AbstractServer.java:133)

at com.businessobjects.sdk.core.server.internal.InstanceServer.process(InstanceServer.java:93)

at com.sap.sl.sdk.services.util.ServerRequestProcessor.processServerRequest(ServerRequestProcessor.java:49)

at com.sap.sl.sdk.dataprovider.service.DataProviderServiceImpl.processDataProviderCommand(DataProviderServiceImpl.java:366)

at com.sap.sl.sdk.dataprovider.service.DataProviderServiceImpl.processDataProviderCommand(DataProviderServiceImpl.java:378)

at com.sap.sl.sdk.dataprovider.service.DataProviderServiceImpl.run(DataProviderServiceImpl.java:164)

at com.sap.sl.sdk.workspace.service.WorkspaceServiceImpl.run(WorkspaceServiceImpl.java:331)

at com.sap.webi.ui.tasks.workflows.RunWorkspaceTask.doIt(RunWorkspaceTask.java:73)

at com.sap.webi.ui.tasks.workflows.RunWorkspaceTask.doIt(RunWorkspaceTask.java:11)

at com.sap.webi.toolkit.ui.tasks.WebITask.doInBackground(WebITask.java:109)

at javax.swing.SwingWorker$1.call(SwingWorker.java:278)

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

at java.util.concurrent.FutureTask.run(FutureTask.java:138)

at javax.swing.SwingWorker.run(SwingWorker.java:317)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

at java.lang.Thread.run(Thread.java:619)

Caused by: com.businessobjects.sdk.core.server.ServerException: Cannot build the query or generate the report. (WIS 30351)

at com.businessobjects.sdk.core.server.common.CommonRequestHandler.newServerException(CommonRequestHandler.java:237)

at com.businessobjects.sdk.core.server.common.CommonRequestHandler.createAllServerExceptions(CommonRequestHandler.java:215)

at com.businessobjects.sdk.core.server.common.CommonRequestHandler.afterProcessing(CommonRequestHandler.java:118)

... 18 more

Caused by: com.businessobjects.sdk.core.server.ServerException: The prompt has not been answered.Click Help for more information.

at com.businessobjects.sdk.core.server.common.CommonRequestHandler.newServerException(CommonRequestHandler.java:237)

at com.businessobjects.sdk.core.server.common.CommonRequestHandler.createAllServerExceptions(CommonRequestHandler.java:213)

... 19 more

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jul 03, 2012 at 08:15 AM

    What kind of sources you are using in your queries? If you are using different types of sources for example one query based on Bex OLAP universe, another query SQL relational universe, and the other Bex BICS connection, you'll get this. That's a problem with BI 4.0.

    We couldn't manage to solve this problem. Try opening an incident with SAP.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2012 at 05:18 AM

    Hi,

    I am facing the same problem. Is you problem resolved?

    Could you please let me know the solution for this issue.

    Thanks in advance,

    Priya

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2012 at 07:21 AM

    Hi Syed,

    Cannot build the query or generate the report. (WIS 30351)

    This is due to one of the following reasons:

    1.The document was not initialised.

    

    2.The data source is not valid.

    

    3.The query was not defined.

    

    4.The query context was not defined at universe level.

    

    5.No values were specified for prompts at the universe level.

    

    Just see out those issues.Hope it helps you!!

    

    http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_ia_en.pdf.

    

    Refer this PDF.

    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.