Unable To Export Data From Worksheet Into Excel - Getting ODPM-70205: Error while exporting data to Excel (Doc ID 2112423.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Worksheet

When attempting to Export data from Worksheet aggregated by Time Level into Excel using Entire View ,
the following error occurs.

ERROR
-----------------------
2016-01-20 17:17:44,706 IST [AWT-EventQueue-2] ERROR dpweb.actions.export :: ODPM-70205: Error while exporting data to Excel
java.lang.IllegalArgumentException: Point parameter outside of expected range: Row
at com.demantra.common.grid.XYPoint.testPointValueRange(XYPoint.java:69)
at com.demantra.common.grid.XYPoint.(XYPoint.java:22)
at com.demantra.partner.client.ui.pivot.PointValueFactory.getDataValue(PointValueFactory.java:198)
at com.demantra.pivot.point.PivotPointFactory.buildDataPoint(PivotPointFactory.java:56)
at com.demantra.pivot.processPoint.DataPointCreator.processPoints(DataPointCreator.java:38)
at com.demantra.pivot.processPoint.DataProcessor.processPoint(DataProcessor.java:45)
at com.demantra.pivot.model.PivotDataModel.createPoints(PivotDataModel.java:47)
at com.demantra.pivot.PivotBuilder.init(PivotBuilder.java:218)
at com.demantra.partner.client.ui.panel.CrosstabViewPanel.buildExportModel(CrosstabViewPanel.java:6277)
at com.demantra.partner.client.ui.panel.CrosstabViewPanel$ViewDataWriter.write(CrosstabViewPanel.java:4179)
at com.demantra.partner.client.ui.panel.CrosstabViewPanel$ExportToExcelWriter.write(CrosstabViewPanel.java:4291)
at com.demantra.partner.client.ui.panel.CrosstabViewPanel.exportDataToExcel(CrosstabViewPanel.java:4453)
at com.demantra.partner.client.ui.panel.CrosstabPanel.exportDataToExcel(CrosstabPanel.java:2840)
at com.demantra.partner.client.ui.panel.AbstractFullFuncPanel$ExportToExcelWorker.construct(AbstractFullFuncPanel.java:719)
at com.demantra.common.ui.SwingWorker$2.run(SwingWorker.java:60)
at java.lang.Thread.run(Unknown Source)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Collaborator Workbench.
2. Open an worksheet that has a Time Level into the aggregation.
3. Try to export data from worksheet to Excel, using Entire View option.
4. It fails.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms