cancel
Showing results for 
Search instead for 
Did you mean: 

Not possible to open DesignStudio reports via BI 4.0

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

VJ

Former Member
0 Kudos

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

IngoH
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos

Hi Ingo,

we can't see a mistake. Do you?

Dirk

Former Member
0 Kudos

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!!!

IngoH
Advisor
Advisor
0 Kudos

Hello Dirk,

is this issue still open ?

Ingo

IngoH
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos

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

IngoH
Advisor
Advisor
0 Kudos

and what exactly is the issue ?

regards

Ingo Hilgefort

Former Member
0 Kudos

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

Dirk

IngoH
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos

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

IngoH
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos

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

IngoH
Advisor
Advisor
0 Kudos

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

ingo

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

TammyPowlas
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

OK thanks!

I was hoping that the exception

com.sap.connectivity.cs.extended.ConnectionServer

only was a known bug.

TammyPowlas
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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?

Former Member
0 Kudos

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

0 Kudos

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

rama_shankar3
Active Contributor
0 Kudos

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

thanks,

Rama

Former Member
0 Kudos

Hi Rama,

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

Dirk

bharathsap
Employee
Employee
0 Kudos

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

Former Member
0 Kudos

Hi Bharath,

this does not work too -> same error message.

Dirk

IngoH
Advisor
Advisor
0 Kudos

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

Former Member
0 Kudos

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

IngoH
Advisor
Advisor
0 Kudos

Hi,

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

Ingo

Former Member
0 Kudos

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

TammyPowlas
Active Contributor
0 Kudos

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

You also have to look at the security inside the CMC

Regards,

Tammy

Former Member
0 Kudos

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).

BR

Dirk

TammyPowlas
Active Contributor
0 Kudos

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

bharathsap
Employee
Employee
0 Kudos

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

Former Member
0 Kudos

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

bharathsap
Employee
Employee
0 Kudos

Hi Dirk,

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

Regards,

Bharath

Former Member
0 Kudos

Good idea but same error within chrome.

Dirk

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Barath,

this one worked for me!

Thank you.

Cheers,

Marcus