Cannot Export OTM Reports into Excel
(Doc ID 1933889.1)

Last updated on APRIL 01, 2017

Applies to:

Oracle Application Testing Suite - Version 12.3.0.1 to 12.4.0.1 [Release 12.3 to 12.4]Information in this document applies to any platform.

Symptoms

OTM reports cannot be exported in MS Excel format. Exporting a report results in the following error in wls_oats.log located at the indicated location. This behaviour is mainly observed on an OATS server running on non Windows platforms

<OATS_install>/logs/wls_oats.log

2014-09-17 14:56:06,669 WARN [RequestProcessor] Unhandled Exception thrown: class java.lang.ClassCastException2014-09-17 14:57:01,721 ERROR [OracleActionBase] Error while invoking action methodjava.lang.NoClassDefFoundError: sun/awt/X11GraphicsEnvironment at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:169) at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:68) at sun.font.FontManager.initSGEnv(FontManager.java:1307) at sun.font.FontManager.findFont2D(FontManager.java:1984) at java.awt.Font.getFont2D(Font.java:455) at java.awt.Font.canDisplay(Font.java:1904) at java.awt.Font.canDisplayUpTo(Font.java:1970) at java.awt.font.TextLayout.singleFont(TextLayout.java:451) at java.awt.font.TextLayout.<init>(TextLayout.java:509) at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:208) at org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn(HSSFSheet.java:1949) at org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn(HSSFSheet.java:1932) at oracle.oats.otm.reports.utils.ReportManager.createXSL(ReportManager.java:525) at oracle.oats.otm.reports.utils.ReportManager.generateReportData(ReportManager.java:85) at oracle.oats.otm.reports.actions.ReportAction.createReport(ReportAction.java:1981) at oracle.oats.otm.reports.actions.ReportAction.prepareReportForDelivery(ReportAction.java:1936) at oracle.oats.otm.reports.actions.ReportAction.exportReport(ReportAction.java:1591) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at oracle.oats.otm.web.OracleActionBase.execute(OracleActionBase.java:144) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)