WEBI 4.0 multiple query problem with filter

[Former Member]

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

[former_member184594 · Accepted solution]

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.

[former_member188911 · Accepted solution]

Zahid is right, this type of error doesn't have a general fix but requires analysis of how the queries are being built. It can be a design error or a defect, in any case you would better open a support message

[Former Member]

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.

[Former Member]

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