Skip to Content
0
Former Member
Dec 08, 2011 at 01:56 AM

Excel as a data source - Error when trying to create new univerise

20 Views

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 😊