My Oracle Support Banner

'java.lang.IllegalArgumentException: Null Connection Not Allowed' Error When Running Reports (Doc ID 2287648.1)

Last updated on MAY 30, 2023

Applies to:

Oracle SQL Developer - Version 4.2.0 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Trying to generate HTML Reports which has child reports built-in or user defined reports causes below exception. The issue occurs only for reports with child reports defined.

Same scenario occurs to system defined reports under View(Menu)-->Reports.

java.lang.IllegalArgumentException: null connection not allowed
at oracle.dbtools.db.DefaultConnectionIdentifier.<init>(DefaultConnectionIdentifier.java:29)
at oracle.dbtools.db.DefaultConnectionIdentifier.createIdentifier(DefaultConnectionIdentifier.java:21)
at oracle.dbtools.raptor.metadata.AbstractDisplayModel.getQuery(AbstractDisplayModel.java:393)
at oracle.dbtools.raptor.metadata.AbstractDisplayModel.getQuery(AbstractDisplayModel.java:377)
at oracle.dbtools.raptor.controls.display.html.TableHtmlGenerator.generateHtml(TableHtmlGenerator.java:63)
at oracle.dbtools.raptor.controls.display.DisplayHtml.generateStyleSpecificHtml(DisplayHtml.java:391)
at oracle.dbtools.raptor.controls.display.DisplayHtml.generateModelHtml(DisplayHtml.java:361)
at oracle.dbtools.raptor.controls.display.DisplayHtml.generateHtml(DisplayHtml.java:261)
at oracle.dbtools.raptor.controls.display.DisplayHtml.generate(DisplayHtml.java:202)
at oracle.dbtools.raptor.report.ui.ReportHtmlDialog$2.doWork(ReportHtmlDialog.java:272)
at oracle.dbtools.raptor.report.ui.ReportHtmlDialog$2.doWork(ReportHtmlDialog.java:244)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:629)
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:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)

Changes

 Sample steps causing the issue on User Defined Reports

1. Open All Reports-->User Defined Report--><Report Name>-->Right click on the Report.

2. Click on Edit and check if 'Child Reports' are available, if not add/edit a child Report.

3. Run the report in HTML format to see the exception.

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!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.