AutoSys Workload Automation

 View Only
  • 1.  Builtin Failed Jobs Report Continues to Fail

    Posted Jul 15, 2019 04:34 PM
    I'm trying to run the buitin FAILED_JOBS report but it continues to fail with below text. This just started happening a few months ago, there was an issues with a server name being used for the DISPLAY variable but I removed it and continue to see the report fail to produce any results.

    Product is CAWA DE 12.1 build 1925, does anyone have any suggestions? I see things related to Oracle but I don't know where to begin.

    2019-07-15 16:26:11,344 INFO com.ca.wa.report.birtreportrunner.BirtReportRunner.info() - af2a46d9-7299-4522-b0bb-c38ad30f0c19 Converted parameters: [af2a46d9-7299-4522-b0bb-c38ad30f0c19, /cawa/CA/WorkloadAutomation/reporting, /cawa/CA/WorkloadAutomation/reporting/birt-runtime/ReportEngine, /cawa/CA/WorkloadAutomation/temp/r/8e6ac0c4-961e-44ac-9a81-6b318de77882/failed_jobs.rptdesign, /cawa/CA/WorkloadAutomation/temp/r/8e6ac0c4-961e-44ac-9a81-6b318de77882, af2a46d9-7299-4522-b0bb-c38ad30f0c19.reportResult, true, af2a46d9-7299-4522-b0bb-c38ad30f0c19.pdf]
    2019-07-15 16:26:11,346 INFO com.ca.wa.report.birtreportrunner.BirtReportRunner.info() - af2a46d9-7299-4522-b0bb-c38ad30f0c19 Report parameters: {end_date_time=[June 30, 2019 11:59:59 PM Eastern Daylight Time], show_details=[false], sort=[row["APPL_NAME"]], start_date_time=[June 1, 2019 12:00:00 AM Eastern Daylight Time]}
    2019-07-15 16:28:05,687 ERROR com.ca.wa.report.birtreportrunner.BirtReportRunner.error() - af2a46d9-7299-4522-b0bb-c38ad30f0c19
    org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.
    at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:282)
    at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:85)
    at com.ca.wa.report.birtreportrunner.BirtReportRunner.runReport(BirtReportRunner.java:309)
    at com.ca.wa.report.birtreportrunner.BirtReportRunner.main(BirtReportRunner.java:435)
    Caused by: java.lang.NoClassDefFoundError: oracle/jdbc/driver/T4C7Oversion
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:694)
    at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)
    at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:1162)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:208)
    at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:258)
    at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:212)
    at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:235)
    at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:160)
    at com.ca.wa.engine.reporting.oda.jdbc.ConnectionEx.open(ConnectionEx.java:83)
    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:222)
    at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:210)
    at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:208)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:406)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:316)
    at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:448)
    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:145)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:617)
    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:80)
    at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
    at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries(ExtendedGenerateExecutor.java:205)
    at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:65)
    at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.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.HTMLPageLM.layout(HTMLPageLM.java:90)
    at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
    at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)
    at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:260)
    ... 3 more
    Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.T4C7Oversion
    at org.eclipse.birt.core.framework.URLClassLoader.findClass1(URLClassLoader.java:168)
    at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClassLoader.java:154)
    at org.eclipse.birt.core.framework.URLClassLoader$1.run(URLClassLoader.java:1)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.eclipse.birt.core.framework.URLClassLoader.findClass(URLClassLoader.java:149)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
    ... 41 more
    2019-07-15 16:28:05,692 INFO com.ca.wa.report.birtreportrunner.BirtReportRunner.info() - af2a46d9-7299-4522-b0bb-c38ad30f0c19 Finished with exit code 92


  • 2.  RE: Builtin Failed Jobs Report Continues to Fail
    Best Answer

    Broadcom Employee
    Posted Jul 17, 2019 10:14 AM
    Hi,

    First look at the error , it shows that  the  problem with the jdbc driver. Can you please raise a defect for the same.


  • 3.  RE: Builtin Failed Jobs Report Continues to Fail

    Posted Jul 17, 2019 10:56 AM

    Thanks Kiran. When you say raise a defect is that the same as opening a case for this? Or is raising a defect done on the community site?

     






  • 4.  RE: Builtin Failed Jobs Report Continues to Fail

    Broadcom Employee
    Posted Jul 18, 2019 01:25 AM
    Hi,

    I meant to open a case.