My Oracle Support Banner

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

Last updated on MARCH 19, 2021

Applies to:

Oracle Agile Product Collaboration - Version 9.3.4.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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