Webi Report throws error "Unknown Error in SL Service (WIS 00000)"

[Former Member]

Hi Everyone,

I trying to create a Webi report on top of a BEx Query in Webi 4.0, the Webi reports runs fine if I skip atleast one key figure from the available key figures in my BEx query.

If I try to bring all the key figures which is my requirement, it throws this error:

com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: Unknown Error in SL Service

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:127)

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:94)

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

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

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

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

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

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

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

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

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: Unknown Error in SL Service

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

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

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

... 18 more

I thought I need to change the settings for number of records retrieved as it is a huge query with two big hierarchies but that didn't help.

I am assuming I may have to change some cache settings as well on CMC but I am not sure.

Can anyone share any thoughts on this?

Any comments will be greatly appreciated.

Thanks & Regards,

SRV

[Henry_Banks]

Hi,

causes are multiple ..

Can be due to hidden dimensions or keyfigures in the BEx query

also, a bug fixed in Patch 2.4

also, can happen when 2 or more variables have the same description.

regards,

H