Need help! Problem Webi connect BW

[Former Member]

Anybody please help!!! . I use Webi connect BW via Universe to create report but I found some error as bellow.

The version that I use is

Webi (BO4.0 sp02)

BW 7.00 sps21

Here an error :

Database error: The MDX query SELECT  { [Measures].[0FM_AMOUNT1] }  ON COLUMNS FROM [$0PU_C02]  failed to execute with the error

Error occurred when starting the parser: timeout during allocate / CPIC-CALL:'ThSAPCMRCV'. (IES 10901) (WIS 10901)

Anyone face this error before? What I have to do to solve it.Many thanks in advance.

[Former Member]

What is the Version of your Integration Kit?

[Former Member]

Hi Ravi and Nikhil now I have try to create OLAP connection link to Bex query and it's work I can see all heirachy but when I try to create report on webi it show error as below.

1. 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.dataprovider.service.DataProviderServiceImpl.run(DataProviderServiceImpl.java:113)

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

                at
com.sap.webi.ui.tasks.workflows.RunDataProviderTask.doIt(RunDataProviderTask.java:77)

                at
com.sap.webi.ui.tasks.workflows.RunDataProviderTask.doIt(RunDataProviderTask.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)

                ... 19
more

[Former Member]

Hi,

causes are multiple ..

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

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

[Former Member]

Hi ,

1)Try to create the Web Intelligence qwery with right combination of objects.

2)If you take one key object (L04 0r L03..),then you have to drag all the L0X (L00,L01..) Key objects in Qwery objects list.Else there is a chance to get the above type of error(In case of Hierarchial Objects).

3)Try to give right combination of filter as said in 1.

Regards,

Venkat

[Former Member]

Hi Ravi and Nikhil now I have try to create OLAP connection link to Bex query and it's work I can see all heirachy but when I try to create report on webi it show error as below.

1. 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.dataprovider.service.DataProviderServiceImpl.run(DataProviderServiceImpl.java:113)

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

                at
com.sap.webi.ui.tasks.workflows.RunDataProviderTask.doIt(RunDataProviderTask.java:77)

                at
com.sap.webi.ui.tasks.workflows.RunDataProviderTask.doIt(RunDataProviderTask.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)

                ... 19
more

[Former Member]

Hi,

See OSS notes 1032461 and 336693 for resolution.

[ravi_chandra3]

Hi kasarus,

Please follow the below link

http://scn.sap.com/message/10644032

Regards,
RaviChandra

[ravi_chandra3]

Hi

Why can't you connect webi directly to BEx query. Since you are using 4.0 , You can connect to bex query directly.

Regards,

RaviChandra

[Former Member]

Hi RaviChandra,

Do you know how to create a connection from webi directly to BEx query? 😃

[Former Member]

Hi,

Here is the document for creating a webi report using bex query.

http://wiki.sdn.sap.com/wiki/display/BOBJ/Creating+a+Webi+Report+using+Bex+Query+in+BI+R4

[nikhil_joy2]

Hi Kasarus,

In BO 4.0 onwards, there is direct connectivity option for BEx query and webi. This is possible through BICS connectivity. You can create a BICS connection in IDT first and using this you can access your BEx queries directly from webi. refer below link to see how to create a BICS connection in IDT and publish it to BOE. Then from webi, select the source as BEx query and select your published connection.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/60ad3c37-b90f-2e10-da88-cbadc6f6fed1&override...

Regarding your error, refer below thread and SAP note 1032461.

http://scn.sap.com/thread/2065480

Regards,

Nikhil Joy