Hello,
Running BO 4 Server (On Server Machine) and Client tools 4 (on my local laptop) . I have tried the following..
Succesfully
1. With the information tool Created a project
2. Created a connection to a excel file on a network drive as a source
2. Published connection, created short cuts
3. Created data foundation
4. Creeated Business layers
5. Linked all tables inserted summary etc (data can be viewed in the viewer)
I publish everything above to the repository and everthing works perfectly.
I have created the ODBC links to the excel file both on my local laptop and server using the 32 bit admin tool (ODBC) in windows.
Current Issue
When i log into the BI Launch pad and open web intellgence, i try to create new and use the univerise i have published. I receieve the following error.
The dataSource cannot be generated for the specified dataSource name "zEmptyBusiness_Layer". (WIS 00000)
com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: The dataSource cannot be generated for the specified dataSource name "zEmptyBusiness_Layer".
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.datasource.strategy.BuiltInDataSourceStrategyImpl.addDataProvider(BuiltInDataSourceStrategyImpl.java:99)
at com.sap.sl.sdk.workspace.service.WorkspaceServiceImpl.addDataProvider(WorkspaceServiceImpl.java:77)
at com.sap.sl.sdk.workspace.service.WorkspaceServiceImpl.addDataProvider(WorkspaceServiceImpl.java:60)
at com.sap.webi.ui.context.managers.DataManager.addDataProviderFromDataSourceInfo(DataManager.java:382)
at com.sap.webi.ui.tasks.workflows.AddDataProviderUITask.doIt(AddDataProviderUITask.java:106)
at com.sap.webi.ui.tasks.workflows.AddDataProviderUITask.doIt(AddDataProviderUITask.java:19)
at com.sap.webi.toolkit.ui.tasks.WebITask.doInBackground(WebITask.java:113)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.businessobjects.sdk.core.server.ServerException: The dataSource cannot be generated for the specified dataSource name "zEmptyBusiness_Layer".
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
any help at all would be much appreciated 😊