Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question