SAP Knowledge Base Article - Preview

1848066 - How do you resolve "Error while trying to invoke the method com.businessobjects.mds.datafoundation.SQLDataSource.getConnection() of an object loaded from local variable 'sqlDataSource' (WIS 00000)" creating a new BI 4.0 Web Intelligence document?

Symptom

  • BI 4.0 SP02 Patch installation of SAP BusinessObjects BI Platform Server on the server machine.
  • BI 4.0 SP04 installation of SAP BusinessObjects BI Platform Client on the client machine.
  • A new single-source UNX Universe is created using the Information Design Tool (IDT) and published to BI Platform.
  • When trying to create a new Web Intelligence (WebI) document using the Rich Internet Application or the WebI Rich Client, the following error is raised when the Universe is selected:

    while trying to invoke the method com.businessobjects.mds.datafoundation.SQLDataSource.getConnection() of an object loaded from local variable 'sqlDataSource' (WIS 00000)
       
  • Tracing the Adaptive Processing Server (APS) that houses the DSL Service, we see the following exception:

    java.lang.NullPointerException: while trying to invoke the method com.businessobjects.mds.datafoundation.SQLDataSource.getConnection() of an object loaded from local variable 'sqlDataSource'
      at com.businessobjects.mds.consumption.CMSUniverseProviderService.manageConnectionMappingForDataFoundation(CMSUniverseProviderService .java:1118)
      at com.businessobjects.mds.consumption.CMSUniverseProviderService.applySecurity(CMSUniverseProviderService.java:247)
      at com.businessobjects.mds.consumption.CMSUniverseProviderService.getUniverse(CMSUniverseProviderService.java:152)
      at com.businessobjects.dsl.services.datasource.impl.DslUniverseProvider.provideUniverseFromRepositoryId(DslUniverseProvider.java:132)
      at com.businessobjects.dsl.services.datasource.impl.DslUniverseProvider.provideUniverseFromCms(DslUniverseProvider.java:63)
      at com.businessobjects.dsl.services.datasource.impl.AbstractUniverseProvider.provideUniverse(AbstractUniverseProvider.java:41)
      at com.businessobjects.dsl.services.universe.impl.AbstractUniverseService.provideUniverse(AbstractUniverseService.java:83)
      at com.businessobjects.dsl.services.universe.impl.UniverseServiceImpl.internalGetUniverse(UniverseServiceImpl.java:42)
      at com.businessobjects.dsl.services.universe.impl.AbstractUniverseService.getUniverse(AbstractUniverseService.java:66)
      at com.businessobjects.dsl.services.datasource.impl.AbstractDataSourceService.getUniverse(AbstractDataSourceService.java:113)
      at com.businessobjects.dsl.services.datasource.impl.CubeDataSourceServiceImpl.getAdaptableDataSource(CubeDataSourceServiceImpl.java:2 7)
      at com.sap.sl.proxyconsumption.services.datasourceservice.DataSourceServiceImpl.getDataSource(DataSourceServiceImpl.java:128)
      at com.sap.sl.proxyconsumption.protobuf.rpc.DatasourceRpc$dataSource.callMethod(DatasourceRpc.java:149)
      at com.sap.sl.proxyconsumption.services.server.DSLBridge.callService(DSLBridge.java:210)
      at com.sap.sl.proxyconsumption.services.server.DSLBridge.doIt(DSLBridge.java:148)
      at com.businessobjects.cdz_ext.slproxybridge.corba.ServerServant.doIt(ServerServant.java:116)
      at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at com.businessobjects.framework.servers.platform.adapters.ebus.orb.CommonTransportInterceptor.invokeHelper(CommonTransportIntercepto r.java:118)
      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.crystaldecisions.enterprise.ocaframework.idl.OCA.OCAcdz.slproxybridge.serverPOA$$EnhancerByCGLIB$$a2d346e9.doIt(<generat ed>)
      at com.crystaldecisions.enterprise.ocaframework.idl.OCA.OCAcdz.slproxybridge.serverPOA._OB_op_doIt(serverPOA.java:107)
      at com.crystaldecisions.enterprise.ocaframework.idl.OCA.OCAcdz.slproxybridge.serverPOA._invoke(serverPOA.java:83)
      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:1977)
      at com.crystaldecisions.thirdparty.com.ooc.OBPortableServer.POA_impl._OB_dispatch(POA_impl.java:1913)
      at com.crystaldecisions.thirdparty.com.ooc.OB.DispatchRequest_impl.invoke(DispatchRequest_impl.java:75)
      at com.businessobjects.framework.servers.platform.adapters.ebus.orb.ThreadPoolDispatchStrategy$Dispatcher.run(ThreadPoolDispatchStrat egy.java:271)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      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:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at java.lang.Thread.run(Thread.java:722)

    that indicate issues with accessing the Connection metadata.

 


Read more...

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3 ; SAP BusinessObjects Business Intelligence platform 4.1

Keywords

KBA , BI-BIP-SL , Semantic Layer , BI-RA-WBI , Web Intelligence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.