Relational connection to SAP ERP

[Former Member]

Hello,

We are using SAP Business Objects 4.0 SP9 with  EHP6 FOR SAP ERP 6.0.

We are trying to make an Web Intelligence report over an Infoset  which was created as direct access to a table.

Everything works fine, the Business Layer query brings all the data, but when we try a new report in Web Intelligence, we get the following error:

We tried with two other different Business Objects servers, 4.0 SP8, and with two different another ERP.

On the SAP side, I create the infoset and generate it.

Is it something we are doing wrong?

Please help us, because we don't know what else to do,.

Thanks in advance,

Andreea D.

[Prabhith]

Hi ,

The creation using Multisource instead of Single source should solve your issue.

SAP Ecc uses JCO middleware.

BR

Prabhith

[former_member1016843]

Hi Prabhith,

I am having the exact same problem. My issue is that my client has multiple complex reports created on their single source universes and recreating these reports is not an option due to strict project timelines. What confuses me is why this problem only started last Friday after a restart of the BO server to sync time with SAP FI source for SSO authentification in BO connections. WEBI reports on single source now all give thius error message"PROJECT_SELECT_FIELD" after detailed testing and UAT sign-off from Client.

I have attempted the following in Dev server: Changed a universe's single source data-foundation to a multi-source data-foundation and repiblished to repository. This results in all objects becoming "UNRESOLVED". After re-entering required objects (Dims/measures) The WEBi's Data Preview in Query Panel works without error, but running the report removes all objects from the report requiring rebuild.

Objects in the Multi are the same as was in the Single source DF. Is there a way to do this change without having to update the Business Layer so report remains mapped to objects and intact.

VERY STRESSED and PROJECT AT MAJOR RISK FOR FAILURE due to this.

Any response is highly appreciated.

Thanks,

Regards,

Earl

[former_member1016843]

Hi Prabhith,

I am having the exact same problem. My issue is that my client has multiple complex reports created on their single source universes and recreating these reports is not an option due to strict project timelines. What confuses me is why this problem only started last Friday after a restart of the BO server to sync time with SAP FI source for SSO authentification in BO connections. WEBI reports on single source now all give thius error message"PROJECT_SELECT_FIELD" after detailed testing and UAT sign-off from Client.

I have attempted the following in Dev server: Changed a universe's single source data-foundation to a multi-source data-foundation and repiblished to repository. This results in all objects becoming "UNRESOLVED". After re-entering required objects (Dims/measures) The WEBi's Data Preview in Query Panel works without error, but running the report removes all objects from the report requiring rebuild.

Objects in the Multi are the same as was in the Single source DF. Is there a way to do this change without having to update the Business Layer so report remains mapped to objects and intact.

VERY STRESSED and PROJECT AT MAJOR RISK FOR FAILURE due to this.

Any response is highly appreciated.

Thanks,

Regards,

Earl

[Former Member]

Hello Earl,

We have finally succeeded by using something else - ABAP functions.

That means that we created a function ( in SE37) which says:

function YOUR_FUNCTION

SELECT * FROM YOUR_TABLE

INTO TABLE YOUR_TABLE.

ENDFUNCTION.

When you create your connection/data foundation/business layer try using this simple function.

Don't forget to make it RFC enabled in the Attributes tab. In the Tables field in se37 please state the name of YOUR_TABLE.

This is the only way it worked for us, hope it helps you.

Regards,

Andreea D.

[former_member1016843]

Hi Andreea,

Thanks, I see how this would work for new report's. Our challenge however is that our sources are SAP Queries and InfoSets based on Logical Databases. Also, reworking the DF by bringing in a ABAP result table would still result in an update of the Business Layer which will break the WEBI objects mappings. We are looking for a way to avoid rebuilding the reports due to time constraints. I also would like to know why this never happend right from the begining and only now. We already have an existing universe (as per previous post) in which we changed the DF to multi, but lost all report mappings resulting in unresolvable objects. Re-entering the objects ruins the report.

Thanks for your reply though.

Regards,

Earl.

[Former Member]

When refreshing the list of values i received the same error but with these details:

ava.util.concurrent.ExecutionException: com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: Database error: (CS) "Unknown property : PROJECT_SELECT_FIELD" . (IES 10901)

  at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)

  at java.util.concurrent.FutureTask.get(Unknown Source)

  at javax.swing.SwingWorker.get(Unknown Source)

  at com.sap.webi.qp.lovprompt.LOVTable.endFetch(LOVTable.java:333)

  at com.sap.webi.qp.lovprompt.LOVTable.propertyChange(LOVTable.java:510)

  at java.beans.PropertyChangeSupport.fire(Unknown Source)

  at java.beans.PropertyChangeSupport.firePropertyChange(Unknown Source)

  at javax.swing.SwingWorker$SwingWorkerPropertyChangeSupport.firePropertyChange(Unknown Source)

  at javax.swing.SwingWorker$SwingWorkerPropertyChangeSupport$1.run(Unknown Source)

  at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)

  at sun.swing.AccumulativeRunnable.run(Unknown Source)

  at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)

  at javax.swing.Timer.fireActionPerformed(Unknown Source)

  at javax.swing.Timer$DoPostEvent.run(Unknown Source)

  at java.awt.event.InvocationEvent.dispatch(Unknown Source)

  at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

  at java.awt.EventQueue.access$200(Unknown Source)

  at java.awt.EventQueue$3.run(Unknown Source)

  at java.awt.EventQueue$3.run(Unknown Source)

  at java.security.AccessController.doPrivileged(Native Method)

  at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

  at java.awt.EventQueue.dispatchEvent(Unknown Source)

  at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

  at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

  at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

  at java.awt.WaitDispatchSupport$2.run(Unknown Source)

  at java.awt.WaitDispatchSupport$4.run(Unknown Source)

  at java.security.AccessController.doPrivileged(Native Method)

  at java.awt.WaitDispatchSupport.enter(Unknown Source)

  at java.awt.Dialog.show(Unknown Source)

  at com.jidesoft.dialog.StandardDialog.show(Unknown Source)

  at java.awt.Component.show(Unknown Source)

  at java.awt.Component.setVisible(Unknown Source)

  at java.awt.Window.setVisible(Unknown Source)

  at java.awt.Dialog.setVisible(Unknown Source)

  at com.sap.webi.toolkit.ui.dialog.GenericDialog.setVisible(GenericDialog.java:119)

  at com.sap.webi.ui.context.managers.DataManager.resolvePrompts(DataManager.java:1655)

  at com.sap.webi.ui.context.managers.DataManager.resolveParameters(DataManager.java:1489)

  at com.sap.webi.ui.tasks.workflows.ResolveParametersUITask.doneProcess(ResolveParametersUITask.java:104)

  at com.sap.webi.toolkit.ui.tasks.WebITask$PrivateWorker.done(WebITask.java:367)

  at javax.swing.SwingWorker$5.run(Unknown Source)

  at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)

  at sun.swing.AccumulativeRunnable.run(Unknown Source)

  at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)

  at javax.swing.Timer.fireActionPerformed(Unknown Source)

  at javax.swing.Timer$DoPostEvent.run(Unknown Source)

  at java.awt.event.InvocationEvent.dispatch(Unknown Source)

  at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

  at java.awt.EventQueue.access$200(Unknown Source)

  at java.awt.EventQueue$3.run(Unknown Source)

  at java.awt.EventQueue$3.run(Unknown Source)

  at java.security.AccessController.doPrivileged(Native Method)

  at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

  at java.awt.EventQueue.dispatchEvent(Unknown Source)

  at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

  at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

  at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

  at java.awt.WaitDispatchSupport$2.run(Unknown Source)

  at java.awt.WaitDispatchSupport$4.run(Unknown Source)

  at java.security.AccessController.doPrivileged(Native Method)

  at java.awt.WaitDispatchSupport.enter(Unknown Source)

  at java.awt.Dialog.show(Unknown Source)

  at com.jidesoft.dialog.StandardDialog.show(Unknown Source)

  at java.awt.Component.show(Unknown Source)

  at java.awt.Component.setVisible(Unknown Source)

  at java.awt.Window.setVisible(Unknown Source)

  at java.awt.Dialog.setVisible(Unknown Source)

  at com.sap.webi.toolkit.ui.dialog.GenericDialog.setVisible(GenericDialog.java:119)

  at com.sap.webi.ui.workbench.datamanager.qpframe.QPFrame.showModal(QPFrame.java:339)

  at com.sap.webi.ui.workbench.datamanager.qpframe.QPFrame.showQueryPanel(QPFrame.java:299)

  at com.sap.webi.ui.context.managers.DataManager.showQueryPanel(DataManager.java:2494)

  at com.sap.webi.ui.context.managers.DataManager.editDataProvider(DataManager.java:476)

  at com.sap.webi.ui.tasks.workflows.EditDataProviderUITask.doneProcess(EditDataProviderUITask.java:91)

  at com.sap.webi.toolkit.ui.tasks.WebITask$PrivateWorker.done(WebITask.java:367)

  at javax.swing.SwingWorker$5.run(Unknown Source)

  at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)

  at sun.swing.AccumulativeRunnable.run(Unknown Source)

  at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)

  at javax.swing.Timer.fireActionPerformed(Unknown Source)

  at javax.swing.Timer$DoPostEvent.run(Unknown Source)

  at java.awt.event.InvocationEvent.dispatch(Unknown Source)

  at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

  at java.awt.EventQueue.access$200(Unknown Source)

  at java.awt.EventQueue$3.run(Unknown Source)

  at java.awt.EventQueue$3.run(Unknown Source)

  at java.security.AccessController.doPrivileged(Native Method)

  at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)

  at java.awt.EventQueue.dispatchEvent(Unknown Source)

  at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

  at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

  at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

  at java.awt.EventDispatchThread.run(Unknown Source)

Caused by: com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: Database error: (CS) "Unknown property : PROJECT_SELECT_FIELD" . (IES 10901)

  at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:152)

  at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:109)

  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.lov.service.processor.DefaultLovProcessor.getIntervals(DefaultLovProcessor.java:191)

  at com.sap.sl.sdk.lov.service.processor.AbstractLovProcessor.getLovIntervals(AbstractLovProcessor.java:78)

  at com.sap.sl.sdk.lov.service.LovServiceImpl.getIntervals(LovServiceImpl.java:177)

  at com.sap.webi.client.toolkit.prompts.LOVHelper.fetchPath(LOVHelper.java:522)

  at com.sap.webi.client.toolkit.prompts.LOVHelper.update(LOVHelper.java:517)

  at com.sap.webi.qp.lovprompt.RefreshLovWorker.doInBackground(RefreshLovWorker.java:46)

  at com.sap.webi.qp.lovprompt.RefreshLovWorker.doInBackground(RefreshLovWorker.java:13)

  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.runWorker(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: Database error: (CS) "Unknown property : PROJECT_SELECT_FIELD" . (IES 10901)

  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

[Former Member]

Try creating the Data Foundation as a Multisource instead of Single Source: I was getting the same error and fixed this way.

To be able to choose Multi instead of Single source you have to create a new Data Foundation not selecting the Database Connection first but starting from your Local Project and selecting New - Data Foundation.

Let us know if fixed.

Ciao
Aldo

[Former Member]

Thanks for your suggestion, I will try to do so!

[former_member4998]

HI

SAP Business Objects Business Intelligence connectivity to SAP ERP via SAP JCo. It provides access to the ABAP Functions.

There are some limitations to access the data from ERP, The JCo API does not support array fetch.