IBM Support

SEVERE: Error happened while running the report. java.lang.NoClassDefFoundError: oracle.dms.console.DMSConsole

Troubleshooting


Problem

Job which runs reportcli fails with the following exceptions in the job log:
now running the reportcli step
Mar 30, 2021 6:08:33 AM org.eclipse.birt.report.engine.api.impl.EngineTask handleFatalExceptions
SEVERE: Error happened while running the report.
java.lang.NoClassDefFoundError: oracle.dms.console.DMSConsole
   at oracle.jdbc.driver.DMSFactory.(DMSFactory.java:46)
   at oracle.jdbc.driver.PhysicalConnection.createDMSSensors(PhysicalConnection.java:1713)
   at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:849)
   at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:443)
   at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
   at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:712)
   at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:1274)
   at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:307)
   at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:236)
   at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:253)
   at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:163)
   at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
   at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
   at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
   at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
   at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
   at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:439)
   at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:327)
   at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:464)
   at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
   at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
   at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:179)
   at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:652)
   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
   at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)
   at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)
   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1954)
   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
   at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
   at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
   at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
   at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
   at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)
   at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)
   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)
   at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
   at org.eclipse.birt.report.engine.layout.html.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)
   at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)
   at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
   at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)
   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:273)
   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)
   at com.ibm.tws.report.manager.emitters.EmitterCsv.run(EmitterCsv.java:108)
   at com.ibm.tws.report.manager.producers.HistoricalProducer.run(HistoricalProducer.java:56)
   at com.ibm.tws.report.manager.ReportLauncher.run(ReportLauncher.java:91)
   at com.ibm.tws.report.cli.ReportCli.runcli(ReportCli.java:589)
   at com.ibm.tws.report.cli.ReportCli.main(ReportCli.java:188)
Caused by: java.lang.ClassNotFoundException: oracle.dms.console.DMSConsole
   at org.eclipse.birt.core.framework.URLClassLoader.findClass1(URLClassLoader.java:188)
   at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClassLoader.java:156)
   at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClassLoader.java:1)
   at java.security.AccessController.doPrivileged(AccessController.java:686)
   at org.eclipse.birt.core.framework.URLClassLoader.findClass(URLClassLoader.java:151)
   at java.lang.ClassLoader.loadClassHelper(ClassLoader.java:844)
   at java.lang.ClassLoader.loadClass(ClassLoader.java:823)
   at java.lang.ClassLoader.loadClass(ClassLoader.java:803)
   ... 54 more
AWSBRC100E Error.
Reason: Error happened while running the report.
AWSBRC113E Report generation failed.
===============================================================
= Status Message: AWSITA030E The job failed.
= Exit Status : 255

Document Location

Worldwide

[{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSGSPN","label":"IBM Workload Scheduler"},"ARM Category":[{"code":"a8m0z000000brIbAAI","label":"Documentation-\u003EORACLE DB"}],"ARM Case Number":"TS005318022","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
02 June 2021

UID

ibm16438851