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

Last updated on MARCH 08, 2017

Applies to:

Oracle Agile Product Collaboration - Version 9.3.1.2 and later
Oracle Agile PLM Framework - Version 9.3.1.2 and later
Oracle Agile Technology Platform - Version 9.3.1.2 and later
Information in this document applies to any platform.

Symptoms

<p >*Symptoms
<span >Briefly describe the symptoms of the problem. Remember to delete any customer specific information

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. Run BOM comparison report with huge BOM

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms