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

[Former Member]

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

[Henry_Banks · Accepted solution]

Hi,

Patch or SP version information is required !

This could be 1572038 - BI4.0: Cannot create a report with BILaunchpad WebIntelligence using an Excel-based universe

... fixed in Patch2.3

Actually, if you search with the terms "dataSource cannot be generated for the specified dataSource name" you will get lots of suggestions. link here: www.service.sap.com/notes

Regards,

H

[Former Member · Accepted solution]

Henry,

thanks for that.. I cannot seem to find that patch.....

How can i check if my version already has this patch included?

kind regards

david

[Henry_Banks · Accepted solution]

Hi ,

Go to : Control Panel - > Add / Remove Programs (or "Programs and Features" on win7)

looks for : SAP BusinessObjects BI Platform 4.0 Client Tool <- that's the base install

now look for an entry called SAP BusinessObjects BI Platform 4.0 Client Tools SP2 Patch2.8

these are not automatic updates, it would require an installer be launched on your PC.

Regards,

H