My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.