Not possible to open DesignStudio reports via BI 4...

Hello,

we have upgraded our BI 4.0. to SP6 - Patch 3 and have installed the DesignStudio ServerComponents (1.1 Patch 1). The application and the server appears in the CMC and we have granted the authorizations as described in the admin-documentation. We are also able to connect the Design Studio to the server and use OLAP-Connections.

Now the problem:

When we run the report locally everything works fine but when we run the report on server side following error message appears in the Browser (IE):

"An error has occurred: An error occurred while trying to view the document".

This also happens when use a report w/o a BI datasource (just a simple button)

Furthermore we are not able to open the report within the launchpad. When we click right-mouse button no option appears.

Someone of you knows this problem and can help us?

Great thanks in advance

Dirk

SAP Managed Tags:
SAP BusinessObjects Design Studio

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (6)

Dirk,

I to was running into the same issue. Adter reviewing the muitiple reply's I used the SAP Note from above and Add the following line to the APS.AnalysisApplication Command Line Parameters.

"-Dbusinessobjects.connectivity.directory=<BOE_INSTALL_DIR>\dataAccess\connectionServer"

Once this was done the Design Studio Applications started working correctly thru the BI Platform.

Scott

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Dirk,

We are having same issue as you. Design Studio not working in document link. Getting "An error occurred: An error occurred while trying to view the document" message.

Did you happen solve this issue? If so can you please share

Thanks

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Some new information:

LaunchPad: When I set the DS app as "Home Tab" within the "Preferences" it executes successfully after logon. This means to me that the installation on server-side works in this area.

But in the document and open document area the error still exists.

Dirk

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

HI Dirk,

I assume you have configured the Single Sign On Token Service ?

have you configured the OpenDocument to accept SAP token and use SAP authentication as primary authentication ?

ingo

Hi Ingo,

we can't see a mistake. Do you?

Dirk

Here is a scinario if anybody can help me.

We can open the design studio analysis application through app url (http://servername....) but trying to open the the same through web url and here is what happens.

- could able to log in to BI launchpad - open the design studio report - and this runs forever.

Any suggestions!!!

Hello Dirk,

is this issue still open ?

Ingo

Hello Pallab,

it is not clear what your issue is and in case it is different to the original entry I would suggest that you do create a new entry in the forum.

regards

Ingo Hilgefort, SAP

Hi Ingo,

yes the issue is still open.

For about 8 weeks SAP Support tell us, that they are working on it -> no success up to now (it's a shame)

We must deliver something to our users and unfortunately we now have to evaluate some other (Non-SAP) frontend-product that seems to be very good.

Dirk

and what exactly is the issue ?

regards

Ingo Hilgefort

The issue has not changed and is still the same: We are not able to start a DesignStudio-App via BOE -> see above.

Dirk

Hello Dirk,

some of those items might have been ask - if so - sorry:

- does this happen with all your applications or only with a particular one ?

- does the application use an OLAP connection ?

- did you try already a different browser ?

- I assume the server add on for Design Studio is installed and the user has the necessary rights ?

- when you click on the object in the Launchpad can you see a complete openDoc URL in the properties / Document Link ?

- What happens when you call this URL ?

regards

Ingo Hilgefort, SAP

Hi Ingo,

- does this happen with all your applications or only with a particular one ?

-> no, only DesignStudio

- does the application use an OLAP connection ?

-> we tested it with and w/o OLAP-connection -> both scenarios failed

- did you try already a different browser ?

-> yes

- I assume the server add on for Design Studio is installed and the user has the necessary rights ?

-> yes

- when you click on the object in the Launchpad can you see a complete openDoc URL in the properties / Document Link ?

-> yes

- What happens when you call this URL ?

-> Message: "An error has occurred: An error occurred while trying to view the document"

Further information:
When I set the DesignStudio-App as Start/Default-Page in the InfoView it executes here (strange).

SAP does not know where the problem is. They evaluated a lot of log-files but no solution up to now.

Dirk

hi Dirk,

when I referred to the applications I was referring to other application you created with Design Studio.

Does this happen only with one specific Design Studio app or with other design studio apps as well ?

So even when you execute the open document URL in a brand new window you get the error ?

thanks

ingo

Hi Ingo,

it happens with every DS app. For example: I created a simple app with just one button and the error occured - also by using the open document URL in a new window.

Dirk

Did you try to re-deploy the web applications using WDEPLOY?

ingo

I am not able to reach our technical guy (he is on vacation till 11.11) but I am quite sure we tried this.

Dirk

Hi Dirk,

Install Google chrome and set as default browser then open Design studio and click on execute from BI platform.

I have followed the same steps in my system and it is working fine

I hope this will solve your problem

Thanks

Ilayaperumal.A

Hi,

we have the same problem of Dirk.

Our configuration is:

SAP BusinessObjects BI Platform 4.1 Support Pack 3Version: 14.1.3.1257
Database Name: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SBOP Design Studio 1.2
Server info: Linux 3.0.76 x86_64

After installing Design Studio we have:

created a dedicated Server
Checked "User Security" (I'm administrator)
This is the error page I got when I try to open a Application by "BI Launch pad"

The stack of Exception is:


com.sap.ip.bi.base.exception.BIBaseRuntimeException: Error while generating data provider:
<parameterList>
<param name="BI_COMMAND_TYPE" value="CREATE_DATA_PROVIDER"/>
<param name="INIT_PARAMETERS">
<param name="DATA_SOURCE_DEFINITION">
<param name="DATA_SOURCE_INITIAL_STATE" value="eNrtWm1P20gQ/n7S/QfLlarrB3Ao7ZGjJtVib8he/VavHQg6aeU6C/FdYudsh8D9+hvHjmMnpqSBVv0QhNC+zDw7O/PM7myCfE4UyvoEX3Zkiu0+UTBTMVVsYjnENGBwQB2sM6QRRDsq1WSpNiJ/drE9YNTCSuf1OP3w8X4yFu54nARReCYeHbZEgYd+NAzC2zPRdboHbfHj69v0w+tXR8cffv0lU/l3xuOHZMr9089Zi0JLAJQwOb1PgjNxlKbTU0maz+eH8+PDKL6V3rZaR9KVrlF/xCfeQRAmqRf6XCy0SrxS148mh4k3PUzGh+WkWLHyRKyYJAilUZYXexOeglxtPpcYzqbjwPdSPrSjeWLF0ZTH6YPg+Wlwl42eiWk8A6PuvPGMFx2pAWfi3ds8jQMOgk4w4SSk3I/C4QqyQGg9qg7rFxB8uJ1WzCfRHceTafrwPOu98Tiam+mIx27CYyfCwyBdhHF3yJgnPFWiMOX3qRna/AYGRku4JoUEtj6tLSptxFP6WkCXAQ944sScC8C70/RhCkaucVP1Us+IhlxssOKLuRARQljhTMzbr45EIRjyMA1uAh6fiWz+/vpY11OGufnHO990WnfDUf/zOlzph9k4Nb/8zf00qcGY53+yt0fvATxfrAs+FjKPxdD4a9mAkcnUCx8Em/tjLxFUnmz4e5uVjp9YBk2nMDrkO4G3twAHw/2dwI/ard+fwp9EszAVfgPmQDIIyiyO4bx6eLOSMPhKarqQerOrMSfPNkYNEn8h44yebU372dZcxFGSZKZs55/sVAtSOHIhDdOmRJaKHGrO3iI7124PqeH6qIjIUuWCevIyI0bXZJZt9omK7U53pM7afeL25gnq3b5DCCm9f4xbgrrnlwk+dmSpLg9oTTdoTahwuWswfXCJNc3AlDJFM11VlIrLdP0EkbKbWcNKhgb7QIBPTdshxoWQH1Iq7iJXc9YEHeRsL1gZKGQVZDuYEmRkpquu4ogdWekhGykOtgl1oGxYHygML0+nCiiFJaW69Fe0j3dXbe+m+ok/3AS3M8iZJ/WlDS9IpUK1vXTsNzutT6gLfLxGCxQN97HWKSInS02Tso71c2wzpCjApo5s2Zhiw1mIrHU7KqGWhgbsEx7IUm2m3gW9Zu4s8KBDDKyyfGHKTBuoDc5SiV04AlEFGyqoy9JqELyTY0JrzeaKC2tmCF+CMC8eawoZhatuV1zqmDqzwLM6BtdmkesRbCNb6Q2E4YzDzZ0VQ8XP8uTLYGA12Bej2Cnb4GRyTjTiDDqLpoZlaXNqO0N/Vv9Xt/1tmbnn556fPys/23t+7vn5k/KzVmN8V5I6+MrZs3MLdvaIqmLjxcj5Pfy+DHzlkMuftTlAPpnttEnsZDux9qaY9Lg9OyaJYoITiEGz1O2SCxfmOtlnQJA9DTPyNbZNRl0rcx/N0uDCNl0rg82VHp/fpmRvYpRqE01jqnlpsDX5x59Reaay9WdX17RZde/7x9XLPK62dDe6yhiErggtLLDNyyxZyzMDJkG/jzs33jgBMhW9ggL5gdsCUle6slTRpgMdaGMTheUiuqmWWI1zy7PHMilZ7OXcdICAZYaU45u8X+gbpoEbOJ9jbwzDr4ocxODYsQfwF8ENrOZDCtY0+lgKPan3FEk7S3o+xYyFYHvXTJWy0NYCrJiaqxv7GP+IGK/S+eXi17Ux3gfvByXo8TPjJuXn62pZIQluQyv73iZMvXTxndo5hkMZM8NdFBTCfzyO6gKGaetIEyswy9qElkWKP/Kyz5l5HCRp4NcukvVySCqLzswyrBAAp50DOIjKjkwVKKqNC9aFjZr2YnJtSMa61UOUXGN1yZbKiEzJhQEXTR8WQVpJp9ogrA21jMYAV3G1vAbMudEw0SDMVoVU+Rz4qhQESl/iFRZVRmRkWdqANSA4ZnFl0jLHthAt8CC2OlTB3wC7lcYyCTed1zDRzNAKm16CWCd7Yu2J9T2I1d4Ta0+sdWJJ1Zt89aBhWTCZRnTiZEVP80RRGpkW1EDL5xW+UrC17MArWyXlw2v1bz//A2x/wlw="/>
<param name="DATA_SOURCE_NAME" value="FhDu8VIUHwsAHg4AAACHkNgIAFBWsE3T"/>
<param name="DATA_SOURCE_QUERY_SPEC" value="eNqlVFFv0zAQfkfiP1jmhT0saVfGStUwwdohEF22NkMIIVWec1uMEtvYTtP8ey5pmq5oWrvt7Xx333efz3ceni6zlCzAWKFkQLtehxKQXMVC3gX0Ojo/7NPTj69fDf/mYEqrgQ+uKmuGFkGotIOlFQFNnNMD3y+Kwit6njJ3/lGn0/V/Tr7PeAIZOxTSOiY50AbV8rVYrjLPMu3Z1GuD9J60E4o6CFkpuWSGZeAwWDvRHec6FZw5iKeqsJdGaTCuJIw7sai8AXUmx/ILlubQHPw1OGPLKTgjAKORyOCrnAFXMt7wNLDONgYrNTiIH0k1kKkFjDPtymeIY2mqitAlYK4tmEiNY+HqR3gijwEL7kxJB0sXyincoiNZc7RZFq+jt+hXoaH/UOPr1xBgIwNAcBIGrtRY+L9pGTHHLlQMdF3kJqz9RCJXQFf2my4lIgbpxK0AE9B5cfyrN5m4+RjCD+94GHUWcfLjas2xulCeuvDmD3Bnt7Dh52/zo+4xMq4qnGOHSHV1g8bvtYGeTDNZkinwlFkyAtt2ayd9bwf3J63RG8P+jP09GFEi35+x2++830WaqVw68hYfG8eTnOXG4P6XB5uMC9hk6Trr4EkKTl6sYCQsr3Oi5HkS+i+W8MUoa6v6j3Si+jCEw88Kd8S1++Q3s35viZp9qb5V/4F/Ff3/AEwx3pc="/>
<param modification_type="delete_if_value_not_equal" name="DATA_SOURCE_TYPE" value="UNIVERSE"/>
</param>
<param name="LOAD_IN_SCRIPT" value=""/>
</param>
<param name="NAME" value="DS_MWC"/>
<param name="TYPE" value="QUERY_DATA_SOURCE"/>
</parameterList>

at com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageCommandProcessor.doCreateDataProviderCommand(PageCommandProcessor.java:753)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.doCreateDataProviderCommand(Page.java:5770)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sap.ip.bi.util.MethodInvoker.callMethod(MethodInvoker.java:155)
at com.sap.ip.bi.webapplications.runtime.service.command.CommandProcessorHelper.processCommand(CommandProcessorHelper.java:473)
at com.sap.ip.bi.webapplications.runtime.service.command.CommandProcessorHelper.processCommand(CommandProcessorHelper.java:340)
at com.sap.ip.bi.webapplications.runtime.processor.CommunicationProcessor.processCommand(CommunicationProcessor.java:212)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.processCommandSuper(Page.java:4758)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.processCommand(Page.java:4337)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.processCommand(Page.java:1)
at com.sap.ip.bi.web.runtime.template.impl.items.TemplateAssembler.createPageObjects(TemplateAssembler.java:626)
at com.sap.ip.bi.web.runtime.template.impl.xml.XmlTemplateAssembler.reloadTemplate(XmlTemplateAssembler.java:180)
at com.sap.ip.bi.web.runtime.template.impl.xml.XmlTemplateAssembler.doInit(XmlTemplateAssembler.java:95)
at com.sap.ip.bi.web.runtime.template.impl.items.TemplateAssembler.init(TemplateAssembler.java:160)
at com.sap.ip.bi.webapplications.runtime.impl.object.template.Template.doInit(Template.java:122)
at com.sap.ip.bi.webapplications.runtime.object.page.impl.PageObject.doInit(PageObject.java:338)
at com.sap.ip.bi.webapplications.runtime.object.page.impl.PageObject.init(PageObject.java:304)
at com.sap.ip.bi.webapplications.runtime.rendering.renderer.ItemRenderer.init(ItemRenderer.java:41)
at com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageStateProcessor.initPageObject(PageStateProcessor.java:2808)
at com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageStateProcessor.setupPageObject(PageStateProcessor.java:2123)
at com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageStateProcessor.createPageObject(PageStateProcessor.java:2080)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.setTemplate(Page.java:5277)
at com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageCommandProcessor.doSetTemplateCommand(PageCommandProcessor.java:1431)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.doSetTemplateCommand(Page.java:5825)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sap.ip.bi.util.MethodInvoker.callMethod(MethodInvoker.java:155)
at com.sap.ip.bi.webapplications.runtime.service.command.CommandProcessorHelper.processCommand(CommandProcessorHelper.java:473)
at com.sap.ip.bi.webapplications.runtime.service.command.CommandProcessorHelper.processCommand(CommandProcessorHelper.java:340)
at com.sap.ip.bi.webapplications.runtime.processor.CommunicationProcessor.processCommand(CommunicationProcessor.java:212)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.processCommandSuper(Page.java:4758)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.processCommandInternal(Page.java:4426)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.processCommandSequence(Page.java:4585)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.doProcessRequest(Page.java:2502)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page._processRequest(Page.java:750)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.processRequest(Page.java:4998)
at com.sap.ip.bi.webapplications.runtime.impl.page.Page.processRequest(Page.java:4991)
at com.sap.ip.bi.webapplications.runtime.impl.controller.Controller.doProcessRequest(Controller.java:1204)
at com.sap.ip.bi.webapplications.runtime.impl.controller.Controller._processRequest(Controller.java:1060)
at com.sap.ip.bi.webapplications.runtime.impl.controller.Controller.processRequest(Controller.java:1028)
at com.sap.ip.bi.webapplications.runtime.impl.controller.Controller.processRequest(Controller.java:1)
at com.sap.ip.bi.server.runtime.sevice.impl.BIRuntimeServerService._handleRequest(BIRuntimeServerService.java:508)
at com.sap.ip.bi.server.runtime.sevice.impl.BIRuntimeServerService.handleRequest(BIRuntimeServerService.java:913)
at com.sap.ip.bi.server.execution.engine.runtime.BIExecutionEngineRuntime.executeRequest(BIExecutionEngineRuntime.java:48)
at com.sap.ip.bi.framework.base.execution.impl.BIExecutionService.executeRequest(BIExecutionService.java:54)
at com.sap.ip.bi.zen.boe.model.session.Session.executeBIRequest(Session.java:195)
at com.sap.ip.bi.zen.boe.server.transport.corba.SessionServant.executeBIRequest(SessionServant.java:69)
at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sap.framework.services.zen.ZenInterceptor.forwardRequest(ZenInterceptor.java:47)
at com.sap.framework.services.zen.ZenInterceptor.invoke(ZenInterceptor.java:39)
at com.businessobjects.framework.servers.platform.adapters.ebus.orb.CommonTransportInterceptor.invokeHelper(CommonTransportInterceptor.java:125)
at com.businessobjects.framework.servers.platform.adapters.ebus.orb.CommonTransportInterceptor.invoke(CommonTransportInterceptor.java:87)
at com.businessobjects.framework.servers.common.proxy.cglib.MethodInterceptorChain.intercept(MethodInterceptorChain.java:136)
at com.sap.ip.bi.zen.boe.transport.corba.CorbaSessionPOA$$EnhancerByCGLIB$$8f45aa53.executeBIRequest(<generated>)
at com.sap.ip.bi.zen.boe.transport.corba.CorbaSessionPOA._OB_op_executeBIRequest(CorbaSessionPOA.java:117)
at com.sap.ip.bi.zen.boe.transport.corba.CorbaSessionPOA._invoke(CorbaSessionPOA.java:84)
at com.crystaldecisions.thirdparty.com.ooc.OBPortableServer.ServantDispatcher.dispatch(ServantDispatcher.java:234)
at com.crystaldecisions.thirdparty.com.ooc.OBPortableServer.POA_impl._do_OB_dispatch(POA_impl.java:1980)
at com.crystaldecisions.thirdparty.com.ooc.OBPortableServer.POA_impl._OB_dispatch(POA_impl.java:1916)
at com.crystaldecisions.thirdparty.com.ooc.OB.DispatchRequest_impl.invoke(DispatchRequest_impl.java:122)
at com.businessobjects.framework.servers.platform.adapters.ebus.orb.ThreadPoolDispatchStrategy$Dispatcher.run(ThreadPoolDispatchStrategy.java:271)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:761)
Caused by: com.businessobjects.dsl.services.workspace.impl.WorkspaceException: csEX
at com.businessobjects.dsl.services.dataprovider.impl.AbstractDataProviderWithUniverse.createDataSource(AbstractDataProviderWithUniverse.java:485)
at com.businessobjects.dsl.services.dataprovider.impl.QuerySpecDataProvider.createInitialDataSource(QuerySpecDataProvider.java:612)
at com.businessobjects.dsl.services.dataprovider.impl.QuerySpecDataProvider.finalizeCreation(QuerySpecDataProvider.java:901)
at com.businessobjects.dsl.services.workspace.impl.AbstractBuiltInDataProviderBuilder.buildDataProvider(AbstractBuiltInDataProviderBuilder.java:36)
at com.businessobjects.dsl.services.dataprovider.impl.DataProviderFactory.createDataProviderWithUniverse(DataProviderFactory.java:190)
at com.businessobjects.dsl.services.dataprovider.impl.DataProviderFactory.createAndAddDataProvider(DataProviderFactory.java:108)
at com.businessobjects.dsl.services.workspace.impl.WorkspaceServiceImpl.addDataProvider(WorkspaceServiceImpl.java:62)
at com.businessobjects.dsl.services.workspace.impl.WorkspaceServiceImpl.addDataProvider(WorkspaceServiceImpl.java:41)
at com.sap.ip.bi.bics.dataaccess.resource.impl.dsl.query.DslQuery.createDataProvider(DslQuery.java:153)
at com.sap.ip.bi.bics.dataaccess.resource.impl.dsl.query.DslQuery.initialization(DslQuery.java:132)
at com.sap.ip.bi.base.application.impl.ServiceManagement.registerService(ServiceManagement.java:776)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createService(ServiceManagement.java:397)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createService(ServiceManagement.java:365)
at com.sap.ip.bi.base.application.impl.Application.createService(Application.java:491)
at com.sap.ip.bi.base.application.service.base.BaseServiceDescription.createService(BaseServiceDescription.java:142)
at com.sap.ip.bi.bics.dataaccess.provider.relational.impl.rel2queryview.Rel2QueryView.isApplicable(Rel2QueryView.java:297)
at com.sap.ip.bi.base.application.impl.ServiceManagement.checkAndCreateService(ServiceManagement.java:720)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createMultipleServicesByGroup(ServiceManagement.java:587)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createMultipleServices(ServiceManagement.java:515)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createService(ServiceManagement.java:384)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createService(ServiceManagement.java:365)
at com.sap.ip.bi.base.application.impl.Application.createService(Application.java:491)
at com.sap.ip.bi.base.application.service.base.BaseServiceDescription.createService(BaseServiceDescription.java:142)
at com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.SelectionObject.isApplicable(SelectionObject.java:529)
at com.sap.ip.bi.base.application.impl.ServiceManagement.checkAndCreateService(ServiceManagement.java:720)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createMultipleServicesByGroup(ServiceManagement.java:551)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createMultipleServices(ServiceManagement.java:515)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createService(ServiceManagement.java:384)
at com.sap.ip.bi.base.application.impl.ServiceManagement.createService(ServiceManagement.java:365)
at com.sap.ip.bi.base.application.impl.Application.createService(Application.java:491)
at com.sap.ip.bi.base.application.service.base.BaseServiceDescription.createService(BaseServiceDescription.java:142)
at com.sap.ip.bi.webapplications.dataproviders.selector.impl.WdpSelector.doInit(WdpSelector.java:320)
at com.sap.ip.bi.webapplications.runtime.object.page.impl.PageObject.init(PageObject.java:304)
at com.sap.ip.bi.webapplications.runtime.object.provider.impl.Provider.init(Provider.java:37)
at com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageStateProcessor.initPageObject(PageStateProcessor.java:2808)
at com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageStateProcessor.setupPageObject(PageStateProcessor.java:2123)
at com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageStateProcessor.createPageObject(PageStateProcessor.java:2080)
at com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageCommandProcessor.doCreateDataProviderCommand(PageCommandProcessor.java:738)
... 73 more
Caused by: java.lang.UnsupportedOperationException: csEX
at com.businessobjects.connectionserver.ConnectionServer.getInstance(ConnectionServer.java:165)
at com.businessobjects.connectionserver.ConnectionServer.getInstance(ConnectionServer.java:100)
at com.businessobjects.mds.services.relational.CsService.<init>(CsService.java:362)
at com.businessobjects.mds.services.solver.AbstractConnectionSolver.getCSService(AbstractConnectionSolver.java:180)
at com.businessobjects.mds.services.solver.AbstractConnectionSolver.addCredentialInfo(AbstractConnectionSolver.java:235)
at com.businessobjects.mds.services.solver.AbstractConnectionSolver.solve(AbstractConnectionSolver.java:136)
at com.businessobjects.mds.services.solver.AbstractConnectionSolver.solveRelational(AbstractConnectionSolver.java:151)
at com.businessobjects.mds.services.solver.AbstractConnectionSolver.solveRelational(AbstractConnectionSolver.java:147)
at com.businessobjects.mds.services.solver.AbstractConnectionSolver.solveRelational(AbstractConnectionSolver.java:143)
at com.businessobjects.mds.services.helpers.DataFoundationHelper.getConnection(DataFoundationHelper.java:907)
at com.businessobjects.mds.services.helpers.DataFoundationHelper.isErpDataFoundation(DataFoundationHelper.java:2990)
at com.businessobjects.mds.services.helpers.UniverseHelper.isErpUniverse(UniverseHelper.java:1562)
at com.businessobjects.dsl.services.datasource.DataSourceFactory.createQueryCapability(DataSourceFactory.java:290)
at com.businessobjects.dsl.services.datasource.DataSourceFactory.fillQueryCapability(DataSourceFactory.java:977)
at com.businessobjects.dsl.services.datasource.DataSourceFactory.getDataSource(DataSourceFactory.java:843)
at com.businessobjects.dsl.services.dataprovider.impl.AbstractDataProviderWithUniverse.createDataSourceFromUniverse(AbstractDataProviderWithUniverse.java:620)
at com.businessobjects.dsl.services.dataprovider.impl.AbstractDataProviderWithUniverse.retrieveDataSource(AbstractDataProviderWithUniverse.java:590)
at com.businessobjects.dsl.services.dataprovider.impl.AbstractDataProviderWithUniverse.buildDataSource(AbstractDataProviderWithUniverse.java:496)
at com.businessobjects.dsl.services.dataprovider.impl.AbstractDataProviderWithUniverse.createDataSource(AbstractDataProviderWithUniverse.java:480)
... 110 more
Caused by: java.lang.UnsupportedOperationException: csEX
at com.businessobjects.connectionserver.ConnectionServer.getImplementation(ConnectionServer.java:432)
at com.businessobjects.connectionserver.ConnectionServer.getInstance(ConnectionServer.java:132)
... 128 more
Caused by: java.lang.ClassNotFoundException: com.sap.connectivity.cs.extended.ConnectionServer
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:513)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:429)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:417)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
at java.lang.ClassLoader.loadClass(ClassLoader.java:313)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:249)
at com.businessobjects.connectionserver.ConnectionServer.getImplementation(ConnectionServer.java:428)
... 129 more

Any suggestions?

Regards

Hi, have you installed the Design Studio BI add-on to the platform?

If so, and you meet the prerequisites, I recommend opening a SAP support message/incident.

OK thanks!

I was hoping that the exception

com.sap.connectivity.cs.extended.ConnectionServer

only was a known bug.

I haven't heard of that with Design Studio - the last note with that error dealt with Web Intelligence/APS - see http://service.sap.com/sap/support/notes/1898878

Solved with NOTE:
1898878 - SBOP BI 4.0: scheduling of a Web Intelligence report fails with error: "csEX csEX com.sap...

But when I try to open a test application I get:

If I open it in local I get

Suggestions?

Resolved by creating an application based on universe based on JAVA JDBC connection

Hi Bharat,

We are facing the same issue after updating to 1.1. we were unable to execute the application in BI platform, but where as if i copied the URL from document link from CMC , its is working fine..

What should i have to do to make it work properly ...please guide me..

Thanks in Advance.

Srikanth K

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Is this the case with SP2 as well? Please let me knw.

thanks,

Rama

Hi Rama,

on the test system we installed SP2 and unfortunately it does not work..

Dirk

Hi Dirk/Srikanth,

Could you try to use IP address of the server instead of fully defined host name? in the opendoc url?

CMC --> Applications --> Open Document --> (context menu) Processing Setting

http://<;IP>:<port>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=%SI_CUID%

Ragards,

Bharath

Hi Bharath,

this does not work too -> same error message.

Dirk

Hi Dirk,

when you execute the application locally, Design Studio will leverage the local defined connections.

When you execute the application on the BI Platform you need to make sure the application is using the connections (OLAP connections) defined on the BI platform.

Did you switch the connection to the BI platform ?

Ingo

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Ingo,

thanks for your ideas. For the server application I use the OLAP-Connections.

I made an example without DataSource-Connection (just a simple button) and this app also does not work if execute it on BI-Plattform.

Dirk

Hi,

did you install the BIP Add ON and the services are configured and running ?

Ingo

Hi,

yes we installed the Analysis Application Service (Design Studio Addon) on the server and the service is running healthy.

It is possible to upload the DS apps to the server and to connect them via OLAP-Connections.

It is NOT possible to execute them on the server via LaunchPad (there exist no "View"-option in the context menu) and execute them via OpenDocument-Interface ("Execute on BI-Plattform").

Dirk

Have you installed the Analysis Platform Services on the BI Platform?

You also have to look at the security inside the CMC

Regards,

Tammy

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Tammy,

thanks for your help.

Yes we did this.

- We have installed the "Analysis Application Service" and this server runs healthy.

- Regading authorizations:

We have created a group "DesignStudio" and assigned it to the application "Design Studio Runtime". Our users are members of this group.

Beside this I made a direct assignment of my user to this application (View and Full-Control).

Dirk

Could you run a trace?

Please see this thread Design Studio: Problem with restricted Bex query

The bottom of the thread shows you how to activate the trace logs in Design Studio

That might show what the problem is

Regards,

Tammy

Hi Dirk,

Could you check the open doc url?

CMC --> Applications --> Open Document --> (context menu) Processing Setting

Please check if the url looks something like this:

http://<host>:<port>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=%SI_CUID%

If this looks ok, then Go to BI Launchpad --> Documents --> Folders --> <Select the Design Studio App> (Context menu)

Copy and paste the document link generated here in browser.

Check if this works fine.

Regards,

Bharath

Hello Bharath,

I already made this test -> negative. The same error message appears as when we start it from DesignStudio directly (I believe DS also uses the OpenDocument Interface).

Thanks for your help.

Dirk

Hi Dirk,

Could you cross check this with any other browser, best would be to check it with chrome.

Regards,

Bharath

Good idea but same error within chrome.

Dirk

Hi Tammy,

I checked this but there was no error message in the error panel. I believe this is a server issue and not on the client side because the DesignStudio works fine. (Creating application, using OLAP-Connections, saving application on server and testing application locally)

Only calling the server-saved application via OpenDocument (Execute on BI Platform) does not work and this looks like an server problem ;-(

Thanks and regards

Dirk

Hi Barath,

this one worked for me!

Thank you.

Cheers,

Marcus

Ask a Question

Top Q&A Solution Author

User

Count