SAP Knowledge Base Article - Preview

3019771 - Analysis for Office crashing when EnableNativeFormatting is set

Symptom

Issue occurs when adding a time field to Rows or Columns and EnableNativeFormatting is set.

error01 timefield.png

In the trace, you can also see the following error:

com.sap.ip.bi.pioneer.excel.models.EaItemGrid.Render|VSTA_Main|Exception in EaItemGrid Render: Bali Exception:

bali.lang.UnsupportedOperationException
at com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.AbstractQvCharacteristicConsumerMember.getTimeSpan()
at com.sap.ip.bi.pioneer.core.utils.CrBicsResultSetHelper.GetCellValue(ICrGridCell iCell, ICrBicsResultSetFormatConfiguration config)
at com.sap.ip.bi.pioneer.excel.views.grid.EaRenderStructure.GetValueFromGridCell(ICrGridCell iCell, EaFormulaHelper iFormulaHelper)
at com.sap.ip.bi.pioneer.excel.views.grid.EaRenderStructure.FillArraysFromCell(Int32 iCol, Int32 iRow, Int32 iCorrectedRow, ICrGridCell lCell)
at com.sap.ip.bi.pioneer.excel.views.grid.EaRenderStructure.FillArraysFromCell(Int32 iCol, Int32 iRow, ICrGridCell lCell)
at com.sap.ip.bi.pioneer.excel.views.grid.EaRenderStructure.CreateFromModel()
at com.sap.ip.bi.pioneer.excel.models.EaItemGrid.Render()
com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.AbstractQvCharacteristicConsumerMember.getTimeSpan(AbstractQvCharacteristicConsumerMember:74)


Read more...

Environment

SAP Analysis for Microsoft Office 2.8

Product

SAP Analysis for Microsoft Office 2.8

Keywords

getTimeSpan, time, drilldown, enablenativeformatting, Bali Exception, An exception occurred in one of the data sources, SAP BI Add-in has disconnected all data sources, If you want to restart, press the Restart Button below. (ID-111006), ID111006, 70ef-3f47-dc , KBA , BI-RA-AO-XLA , Excel Addin , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.