Application Error in Export of Change to MS Excel Due to Non-Standard Apache POI Version Used by Process Extension

(Doc ID 1208548.1)

Last updated on NOVEMBER 07, 2017

Applies to:

Oracle Agile Product Collaboration - Version 9.3.0.2 and later
Oracle Agile PLM Framework - Version 9.3.0.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to export a Change, the following error occurs.

ERROR
-----------------------
'Application error. This feature did not perform as expected. Please contact your Agile Administrator'

The OC4J log shows messages like
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFCell.setEncoding(S)V
at com.agile.ui.pcm.pdx.BackgroundExportHandler.convertOutputForExcel(BackgroundExportHandler.java:238)
at com.agile.ui.pcm.pdx.BackgroundExportHandler.outputtingFile(BackgroundExportHandler.java:164)
... 28 more
<2010-09-02 11:24:38,855> <ActionServlet:ERROR> source exception
java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFCell.setEncoding(S)V
at com.agile.ui.pcm.pdx.BackgroundExportHandler.convertOutputForExcel(BackgroundExportHandler.java:238)
at com.agile.ui.pcm.pdx.BackgroundExportHandler.outputtingFile(BackgroundExportHandler.java:164)
...
Caused by: java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFCell.setEncoding(S)V
at com.agile.ui.pcm.pdx.BackgroundExportHandler.convertOutputForExcel(BackgroundExportHandler.java:238)
at com.agile.ui.pcm.pdx.BackgroundExportHandler.outputtingFile(BackgroundExportHandler.java:164)
... 28 more
<2010-09-02 11:28:13,298> <ActionServlet:ERROR> source exception
java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFCell.setEncoding(S)V
at com.agile.ui.pcm.pdx.BackgroundExportHandler.convertOutputForExcel(BackgroundExportHandler.java:238)
at com.agile.ui.pcm.pdx.BackgroundExportHandler.outputtingFile(BackgroundExportHandler.java:164)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open a Change Object
2. Export as MS Excel

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