BO 4.0 SP5 Patch5 BICS issue

[Former Member]

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!

[DayaJha · Accepted solution]

Hi Thomas,

Please refer to these two  KBAs which deal with your same error message "SQL generation failed.See your business objects administrator . while trying to invoke method........(WIS 00013)"

"1647331 - BI4.0 - WebI BICS - Prompts dialog fails to show with error: "SQL generation failed"

Links:

http://service.sap.com/sap/support/notes/1647331

"1660156 - BI 4.0 - WebI BICS - Error: << SQL generation failed while trying to invoke the method com.sap.ip.bi.base.application.service.rfcproxy.IRfcFunction.getImportingParameters() of an object loaded from local variable 'function' >>"

Links:

http://service.sap.com/sap/support/notes/1660156

Or You can also refer the below thread.

Links:

http://scn.sap.com/thread/3259232

http://scn.sap.com/message/13948093

Links:

http://scn.sap.com/thread/1697844

http://scn.sap.com/thread/1263827

Hope this will help you as well.

Thanks,

Daya

[Former Member · Accepted solution]

Thanks for the post Daya.

I forgot to mention last night that I have looked over most of these so let me elaborate.

Note 1660156 looks irrelevant because it refers to a prior patch where I am service pack 5 patch 5.

Note 1647331 , I checked and already had monitoring enabled on both of these servers.

The thread links you sent me mostly refer to users being able to load the query but not being able to run it. I ,however, can't even load a BICS query via WEBI in BO 4.0.

Thanks for your help!!!

[Henry_Banks · Accepted solution]

Hi,

that error looks like it's coming from BW. maybe an RSTT trace could tell you more?

it looks like there's a problem with one of the selections (prompt or hardcoded) either in the bex variable, or the webi query panel (member selector) or webi prompt.

start by removing these, or changing the default values.

if no BICS connection is working, then it may be the user permissions defined in the IDT connection?

try recreating the OLAP connection etc.

Best of luck!

regards,

H