Running Huge BOM Comparison Report Causing Agile Application Server to Hang With Stuck Thread (Doc ID 1552056.1)

Last updated on MARCH 08, 2023

Applies to:

Symptoms

Agile Application Server hangs and users are unable to login to Agile.
See below errors in Agile Application Server log:

<Error> <WebLogicServer> <BEA-000337> <[STUCK] ExecuteThread: '20' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "1,319" seconds working on the request "weblogic.servlet.internal.ServletRequestImpl@4cb468[
..
]", which is more than the configured time (StuckThreadMaxTime) of "1,200" seconds. Stack trace:
..
    com.agile.report.xmldiff.DiffManager.diff4(DiffManager.java:368)
    com.agile.report.xmldiff.DiffManager.diffAll(DiffManager.java:251)
    com.agile.report.xmldiff.DiffManager.diff(DiffManager.java:106)
    com.agile.report.xmldiff.DiffManager.diff(DiffManager.java:84)
    com.agile.report.server.pc.bomcomp.BOMComparison.getPrintData(BOMComparison.java:220)
    com.agile.report.server.common.BaseXMLReport.handleBIDynamic(BaseXMLReport.java:159)
    com.agile.report.server.common.BaseRptBusLogic.fetch(BaseRptBusLogic.java:351)
    com.agile.report.server.scheduler.ReportExecMgr.getData(ReportExecMgr.java:148)
    com.agile.report.server.ReportFacadeSessionBean.getData(ReportFacadeSessionBean.java:88)
    com.agile.report.server.ReportFacadeSessionBean.generateDataLayoutXML(ReportFacadeSessionBean.java:398)
    com.agile.report.server.ReportFacadeSessionBean_gjqzbz_EOImpl.generateDataLayoutXML(ReportFacadeSessionBean_gjqzbz_EOImpl.java:433)
    com.agile.ipa.pc.CMReport.generateDataLayoutXML(CMReport.java:595)
    com.agile.ui.pcm.report.ReportHandler.exportReportWithBIPubliser(ReportHandler.java:764)


Steps

The issue can be reproduced at will with the following steps:
1. Login to Web Client, and go to Standard Reports > Product Reports > BOM Comparison Report, and Execute
2. Select Layout, and Next
3. Select the number for Compare Level, and Next
4. Select Item with huge number of BOM items, and Finish

Changes

Cause

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