IBM Support

IJ21445: 'APPLICATION ERROR' WHEN MODIFYING REPORTS CREATED BY A DIFFERENT USER OR ASSIGNING REPORT TO A NEW GROUP

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • It has been identified that an  "Application Error" can be
    generated when clicking the "Finish" button during modification
    of Reports in certain scenarios.
    Criteria of reports where modification can cause this issue:
    Report created by a different user, and the current user is
    modifying them for 1st time
          OR
    Trying to assign the report to new Group
         AND
    The report has VirtualViewReferenceID associated to it.
    Messages similar to the following might be visible in
    /var/log/qradar.log when this issue is occurring:
    [tomcat.tomcat] [ /console/do/reportwizard]
    com.q1labs.uiframeworks.action.ExceptionHandler: [ERROR]
    Chained SQL Exception [1/1]: You can't operate on a closed
    Statement!!!
    [tomcat.tomcat] [ /console/do/reportwizard]
    com.q1labs.uiframeworks.action.ExceptionHandler: [ERROR]
    [NOT:0000003000][-/- -]An exception occurred while processing
    the request:
    [tomcat.tomcat] [ /console/do/reportwizard]
    java.sql.SQLException: You can't operate on a closed
    Statement!!!
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setString(New
    ProxyPreparedStatement.java:969)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setStrin
    g(DelegatingPreparedStatement.java:315)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingCo
    nnection$LoggingPreparedStatement.setString(LoggingConnectionDec
    orator.java:1390)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setStrin
    g(DelegatingPreparedStatement.java:315)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setStrin
    g(DelegatingPreparedStatement.java:315)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setStrin
    g(DelegatingPreparedStatement.java:315)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.frameworks.session.PreparedStatementWrapper.setString
    (PreparedStatementWrapper.java:540)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.core.shared.group.FgroupTypeFactory.assignItemsToGrou
    ps(FgroupTypeFactory.java:1352)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.reports.ui.util.ReportGroupFactory.assignItemsToGroup
    s(ReportGroupFactory.java:398)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.reports.ui.action.ReportWizard.generateReport(ReportW
    izard.java:873)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.reports.ui.action.ReportWizard.fetchPageToDisplay(Rep
    ortWizard.java:556)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.reports.ui.action.ReportWizard.executeAction(ReportWi
    zard.java:260)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.uiframeworks.actions.WizardAction.execute(WizardActio
    n.java:38)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.struts.action.RequestProcessor.processActionPerform(R
    equestProcessor.java:484)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.uiframeworks.action.RequestProcessor.processActionPer
    form(RequestProcessor.java:101)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.struts.action.RequestProcessor.process(RequestProcess
    or.java:275)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.struts.action.ActionServlet.process(ActionServlet.jav
    a:1482)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.uiframeworks.action.ActionServlet.process(ActionServl
    et.java:122)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.struts.action.ActionServlet.doPost(ActionServlet.java
    :525)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
    (ApplicationFilterChain.java:231)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.catalina.core.ApplicationFilterChain.doFilter(Applica
    tionFilterChain.java:166)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.ja
    va:52)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
    (ApplicationFilterChain.java:193)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.catalina.core.ApplicationFilterChain.doFilter(Applica
    tionFilterChain.java:166)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.uiframeworks.postauthredirect.PostLoginRedirectFilter
    .doFilter(PostLoginRedirectFilter.java:70)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
    (ApplicationFilterChain.java:193)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.catalina.core.StandardHostValve.invoke(StandardHostVa
    lve.java:137)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.uiframeworks.valve.ErrorReportValve.invoke(ErrorRepor
    tValve.java:47)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.catalina.core.StandardEngineValve.invoke(StandardEngi
    neValve.java:87)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapte
    r.java:343)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:476
    )
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.coyote.AbstractProcessorLight.process(AbstractProcess
    orLight.java:66)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.coyote.AbstractProtocol$ConnectionHandler.process(Abs
    tractProtocol.java:808)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(Nio
    Endpoint.java:1498)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcess
    orBase.java:49)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExec
    utor.java:1160)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
    cutor.java:635)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(T
    askThread.java:61)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    java.lang.Thread.run(Thread.java:812)
    [tomcat.tomcat] [ /console/do/reportwizard] Caused by:
    [tomcat.tomcat] [ /console/do/reportwizard]
    java.lang.NullPointerException
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.maybeDirtyTra
    nsaction(NewProxyPreparedStatement.java:2069)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setString(New
    ProxyPreparedStatement.java:961)
    [tomcat.tomcat] [ /console/do/reportwizard]    ... 74 more
    [tomcat.tomcat] [ /console/do/reportwizard]
    com.q1labs.uiframeworks.action.ExceptionHandler: [ERROR]
    [NOT:0000003000][127.0.0.1/- -] [-/- -]Root cause:
    [tomcat.tomcat] [ /console/do/reportwizard]
    java.lang.NullPointerException
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.maybeDirtyTra
    nsaction(NewProxyPreparedStatement.java:2069)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setString(New
    ProxyPreparedStatement.java:961)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setStrin
    g(DelegatingPreparedStatement.java:315)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingCo
    nnection$LoggingPreparedStatement.setString(LoggingConnectionDec
    orator.java:1390)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setStrin
    g(DelegatingPreparedStatement.java:315)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setStrin
    g(DelegatingPreparedStatement.java:315)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setStrin
    g(DelegatingPreparedStatement.java:315)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.frameworks.session.PreparedStatementWrapper.setString
    (PreparedStatementWrapper.java:540)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.core.shared.group.FgroupTypeFactory.assignItemsToGrou
    ps(FgroupTypeFactory.java:1352)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.reports.ui.util.ReportGroupFactory.assignItemsToGroup
    s(ReportGroupFactory.java:398)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.reports.ui.action.ReportWizard.generateReport(ReportW
    izard.java:873)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.reports.ui.action.ReportWizard.fetchPageToDisplay(Rep
    ortWizard.java:556)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.reports.ui.action.ReportWizard.executeAction(ReportWi
    zard.java:260)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.uiframeworks.actions.WizardAction.execute(WizardActio
    n.java:38)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.struts.action.RequestProcessor.processActionPerform(R
    equestProcessor.java:484)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    com.q1labs.uiframeworks.action.RequestProcessor.processActionPer
    form(RequestProcessor.java:101)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.struts.action.RequestProcessor.process(RequestProcess
    or.java:275)
    [tomcat.tomcat] [ /console/do/reportwizard]    at
    org.apache.struts.action.ActionServlet.process(ActionServlet.jav
    a:1482)
    

Local fix

  • Either modify the report by the original user who created it
    without adding new groups, or while modifying the report
    unassign it from all existing groups
    

Problem summary

  • This issue has been fixed in QRadar QRM QVM release 7.3.3 patch
    2 and 7.4.0.
    

Problem conclusion

  • This issue has been fixed in QRadar QRM QVM release 7.3.3 patch
    2 and 7.4.0.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ21445

  • Reported component name

    QRADAR SOFTWARE

  • Reported component ID

    5725QRDSW

  • Reported release

    732

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-12-05

  • Closed date

    2020-02-13

  • Last modified date

    2020-07-28

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    QRADAR SOFTWARE

  • Fixed component ID

    5725QRDSW

Applicable component levels

[{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSBQAC","label":"IBM QRadar SIEM"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"732"}]

Document Information

Modified date:
29 July 2020