Agile Performance Issue While Updating Change Order Affected Item: BOM Relines (Doc ID 2761111.1)

Last updated on JANUARY 20, 2023

Applies to:

Symptoms

Agile performance issue while updating Change Order Affected Item:  BOM relines, in some cases it takes the change right away and in many other cases, it takes upwards of 15 min per change.
The issue is intermittent and is impacting several users.

The issue can be reproduced at will with the following steps:
1. Login to web client
2. Update Changes with Affected Item: BOM Redlines
3. Update takes 15-20 mins sometimes

ERRORS

Acollect Advisor:

The following is details of the Stuck Thread:  ( Workmanager is Stuck )

Thread Name                                                                                                                      User                    Current Request                                                                                                                                                                            
[STUCK] ExecuteThread: '19' for queue: 'weblogic.kernel.Default (self-tuning)'      skxxxxxn        Workmanager: default, Version: 0, Scheduled=true, Started=true, Started time: 1628348 ms Current user: skaseman Remote Address: 10.1.11.89 Http Session: PEhP5EAh8gmXZ3JFwJ665x4ao9Xse6nGWYtUrPmVxDUx_8b6DJqZ Http Request Information: weblogic.servlet.internal.ServletRequestImpl@51b29856[POST /Agile/PCMServlet HOST: agileapp01.prd.xx.xxxxxxx.com:7002 ]

From the above we know the stuck tread was caused by User: skxxxxxn --> Refer to Acollect_Advisor.html for the User.
The following log shows there was a Stuck Thread with a Custom Report:  /u01/CustomReports/Custom_Report_xxxxxxx.xsl (No such file or directory)


[2021-01-29T12:10:46.267-08:00] [agileapp01-Agile] [WARNING] [] [oracle.xdo] [tid: [STUCK].ExecuteThread: '23' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: rkaur-ext] [ecid: d854da32-eb52-47c7-aad6-6c5818d62445-0001e25f,0] [APP: AgilePLM] [DSID: 0000NTFVe248Pt1_zt4EyW1W2cPP00011i] IOException is occurred in FOProcessor.setData(/u01/CustomReports/Custom_Report_xxxxxxx.xsl).
[2021-01-29T12:10:46.274-08:00] [agileapp01-Agile] [WARNING] [] [oracle.xdo] [tid: [STUCK].ExecuteThread: '23' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: rkaur-ext] [ecid: d854da32-eb52-47c7-aad6-6c5818d62445-0001e25f,0] [APP: AgilePLM] [DSID: 0000NTFVe248Pt1_zt4EyW1W2cPP00011i] oracle.xdo.XDOIOException: java.io.FileNotFoundException: /u01/CustomReports/Custom_Report_xxxxxxx.xsl (No such file or directory)[[
    at oracle.xdo.template.FOProcessor.setTemplate(FOProcessor.java:662)
    at com.bb.agile.plm.customreports.PrintToPdf.printToPdf(Unknown Source)
    at com.bb.agile.plm.customreports.PrintToPdf.processForPrinting(Unknown Source)
    at com.bb.agile.plm.customreports.PrintToPdf.doAction(Unknown Source)
    at com.agile.px.Extensions2$PXCustomActionNode.invoke(Extensions2.java:714)
    at com.agile.px.Extensions2.doCustomEvent(Extensions2.java:521)
    at com.agile.px.Extensions2.invokeAction(Extensions2.java:161)
    at com.agile.px.PxSessionBean.invokeAction(PxSessionBean.java:86)
    at com.agile.px.com_agile_px_PxSession_l8vd22_EOImpl.__WL_invoke(Unknown Source)
    at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:34)

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.