Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Java Error When Exporting Data to Excel 2003+ worksheet In Oracle SQL Developer

fa406dfd-66a0-48d6-9cea-ef9a189add74Mar 5 2020 — edited Mar 5 2020

Hello Oracle Community,

I have come across an issue when exporting data into an Excel 2003+ worksheet in Oracle SQL Developer, and want to see if anyone has come across this similar issue and know of steps to resolve the issue? The error is sometimes intermittent, but has occurred more and more often recently. I have posted the error I see below.

java.lang.NullPointerException

at oracle.dbtools.raptor.format.ExcelFormatter.closeStream(ExcelFormatter.java:287)

at oracle.dbtools.raptor.format.ExcelXFormatter.closeStream(ExcelXFormatter.java:73)

at oracle.dbtools.raptor.export.ExportGenerationOutputStream.closeCurrentStream(ExportGenerationOutputStream.java:533)

at oracle.dbtools.raptor.export.ExportGenerationOutputStream.finished(ExportGenerationOutputStream.java:464)

at oracle.dbtools.raptor.export.ExportAPI$1.doWork(ExportAPI.java:1446)

at oracle.dbtools.raptor.export.ExportAPI$1.doWork(ExportAPI.java:1409)

at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:199)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:702)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)

Please let me know if you have any questions. Any updates would be greatly appreciated!!

Thank you!!

Kevin J

Comments
Post Details
Added on Mar 5 2020
1 comment
644 views