Skip to Content
0
Former Member
Apr 07, 2013 at 03:24 AM

BO 4.0 SP5 Patch5 BICS issue

24 Views

Evening everyone:

Just upgraded to SP5 Patch 5 on a clustered node with one web-app server. UNV reports run fine but when we try to run BICS we receive the following error:

Query script generation failed. See your BusinessObjects administrator. {0} (WIS 00013) No member found for Caption 'B1/003.2013' in Characteristic 'Fiscal year/period'.

java.lang.ArrayIndexOutOfBoundsException: 9

at org.eclipse.emf.ecore.resource.impl.BinaryResourceImpl$EObjectInputStream.getEStructuralFeatureData(BinaryResourceImpl.java:1125)

at org.eclipse.emf.ecore.resource.impl.BinaryResourceImpl$EObjectInputStream.loadEObject(BinaryResourceImpl.java:1415)

at org.eclipse.emf.ecore.resource.impl.BinaryResourceImpl$EObjectInputStream.loadFeatureValue(BinaryResourceImpl.java:1439)

at org.eclipse.emf.ecore.resource.impl.BinaryResourceImpl$EObjectInputStream.loadEObject(BinaryResourceImpl.java:1416)

at org.eclipse.emf.ecore.resource.impl.BinaryResourceImpl$EObjectInputStream.loadFeatureValue(BinaryResourceImpl.java:1439)

at org.eclipse.emf.ecore.resource.impl.BinaryResourceImpl$EObjectInputStream.loadEObject(BinaryResourceImpl.java:1416)

at org.eclipse.emf.ecore.resource.impl.BinaryResourceImpl$EObjectInputStream.loadResource(BinaryResourceImpl.java:1156)

at com.sap.sl.core.emf.serial.EObjectSerializer$CustomBinaryResourceImpl.doLoad(EObjectSerializer.java:78)

at org.eclipse.emf.ecore.resource.impl.ResourceImpl.load(ResourceImpl.java:1445)

at com.sap.sl.core.emf.serial.EObjectSerializer.fromBinaryStream(EObjectSerializer.java:253)

at com.sap.sl.core.emf.serial.EObjectSerializer.fromBinaryBytes(EObjectSerializer.java:288)

at com.sap.sl.sdk.parser.xml.datasource.DataSourceParser.parseDSLDataSource(DataSourceParser.java:208)

at com.sap.sl.sdk.parser.xml.datasource.DataSourceParser.parseAttachments(DataSourceParser.java:182)

at com.sap.sl.sdk.parser.xml.datasource.DataSourceParser.parse(DataSourceParser.java:155)

at com.sap.sl.sdk.parser.xml.OutputParser.parseOutput(OutputParser.java:186)

at com.sap.sl.sdk.parser.xml.OutputParser.parse(OutputParser.java:147)

at com.sap.sl.sdk.parser.xml.OutputParser.parseOutputs(OutputParser.java:99)

at com.sap.sl.sdk.parser.responses.ServerResponseHelper.parseOutputResponses(ServerResponseHelper.java:54)

at com.sap.sl.sdk.workspace.service.internal.WorkspaceLoadingService.processWorkspaceRequest(WorkspaceLoadingService.java:102)

at com.sap.sl.sdk.datasource.service.internal.DataSourceLoadingService.loadDataSourceFromServer(DataSourceLoadingService.java:221)

at com.sap.sl.sdk.dataprovider.service.DataProviderServiceImpl.loadDataSource(DataProviderServiceImpl.java:106)

at com.sap.sl.sdk.dataprovider.service.DataProviderServiceImpl.getDataSource(DataProviderServiceImpl.java:74)

at com.sap.webi.qp.abstractlayer.AbstractLayer.loadDataSourceFromDataProvider(AbstractLayer.java:1475)

at com.sap.webi.qp.abstractlayer.AbstractLayer.getDataSource(AbstractLayer.java:362)

at com.sap.webi.ui.data.UniverseQuerySheet.getSheetPanel(UniverseQuerySheet.java:165)

at com.sap.webi.ui.workbench.datamanager.qpframe.QueryTabbedPane$QueryComponent.<init>(QueryTabbedPane.java:108)

at com.sap.webi.ui.workbench.datamanager.qpframe.QueryTabbedPane.addQuery(QueryTabbedPane.java:33)

at com.sap.webi.ui.workbench.datamanager.qpframe.QPWorkBench.addSheet(QPWorkBench.java:178)

at com.sap.webi.ui.workbench.datamanager.qpframe.QPFrame.addSheet(QPFrame.java:300)

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

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

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

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)

I can create BICS connections but can't create reports against them.

We have 8 APS recommended by SAP Best Practices APS split design.

  • Business Objects 4.0
    • SP05 Patch05
    • Clustered environment
      • § Two windows server 2008 r2 nodes @ 64gb of memory @ Intel Xeon E5502 1.87ghz (2 CPU)
      • § One web app server (virtual machine) with Tomcat @ 64gb of memory @ Intel Xeon E7330 2.4ghz (2 CPU)

Anyone come across this before?

Thanks!