Skip to Content
0
Former Member
Aug 03, 2016 at 03:47 PM

Excel Export Error

205 Views

Hello Everybody

I have one application on BO Launchpad that i created with Design Studio which contains 4-5 tabs and tables per each tab.

There is an Export to Excel button where they can export these tables with ExportType.EXCEL_xlsx format.

Problem is, for some business units, export to excel is getting below error :

It is interesting to see, some business units that are able to export, have less data than others.

Last finding: i tried to run the application locally and excel export is working for all business units.

My question is, is there any such limitation from data size perspective? I should also add that, tables are not huge. Per unit, biggest table has 200 rows and 6 columns.

Any opinions? Thank you all..

Design Studio Version : 16.0.5

BO Version : SAP BusinessObjects BI Platform 4.1 Support Pack 7 Patch 3

Internet Explorer : 11 (i also tried on Firefox, same issue)

"MissingResource for class com.sap.ip.bi.export.office.impl.excel2007.MsExcel2007Converter, key: MsExcel2007Converter_0001, locale: en"

Root Cause

The initial exception that caused the request to fail was:

while trying to invoke the method com.sap.ip.bi.base.application.display.matrix.IMxGridMatrix.getPivotCell(int, int) of a null object loaded from field com.sap.ip.bi.base.application.display.matrix.impl.MxGridMatrix.m_origin of an object loaded from local variable 'this'

java.lang.NullPointerException: while trying to invoke the method com.sap.ip.bi.base.application.display.matrix.IMxGridMatrix.getPivotCell(int, int) of a null object loaded from field com.sap.ip.bi.base.application.display.matrix.impl.MxGridMatrix.m_origin of an object loaded from local variable 'this' at com.sap.ip.bi.base.application.display.matrix.impl.MxGridMatrix.getPivotCell(MxGridMatrix.java:254) at com.sap.ip.bi.webapplications.ui.advancedcontrols.universalgrid.export.AcUniGridExport.getAxis(AcUniGridExport.java:481) at com.sap.ip.bi.webapplications.ui.advancedcontrols.universalgrid.export.AcUniGridExport.createRow(AcUniGridExport.java:440) at com.sap.ip.bi.webapplications.ui.advancedcontrols.universalgrid.export.AcUniGridExport.next(AcUniGridExport.java:326) at com.sap.ip.bi.export.office.impl.excel2007.Excel2007Writer.write(Excel2007Writer.java:135) [...]

Log ID da2d76de-6346-4019-8c3c-5c8c96b55d0d