Home Screen Performance Issue

We are running Agile PLM version 9.3.6, WebLogic 12.1.2, Windows server 2012, separate APP and SQL servers.  We are experiencing a performance issue regarding the load of the home screen – taking 1-2 mins upon login and when returning to the home screen for both the “workflow” and “My Assignments” tab.  Once on the home screen and have engaged both of these tabs – they respond very quickly when toggling between them.  However once you leave the home screen and attempt to return to it, you are again subject to a very slow response to both of these tab views until them are both viewed once.

Other PLM system functions have no performance issues.

There does not seem to be any server performance issue (CPU, disk, memory) to account for this specific system performance issue.  Our PLM system typically will have between 20-30 active users and the issues.

Any suggestions or know system patch to resolve this home page performance issue?  We are opening a case with Oracle support but I thought I would as this group also.

Agile User Asked on January 24, 2020 in Product Collaboration.
Add Comment
4 Answer(s)

How many notifications are there? I’ve seen this happen when there are 1000s of notifications on the home page.

Agile Angel Answered on January 25, 2020.
Add Comment

There does seem to be a relationship here in that the response will be faster (but not acceptable) if the “pending” option is changes from All to 30 days.  I do not think anyone is in the 1000+ range.  For my case it is around 170 pending notifications.

Agile User Answered on January 25, 2020.
Add Comment

We had a consultant resolve a similar issue with performance

Agile User Answered on January 25, 2020.

Any insight as to what was done to correct the issue that you can share?

on January 25, 2020.
Add Comment

Hello

It could be because there are too many  records in the notification_fields table. So, even though the user has less notifications, it is taking lot of time to show what the user has. Probably, you need to clean some old read records

Please refer to this metalink article and it has some pointers

Here is a snippet

<<

This document provides SQL scripts for deleting read notifications by all read notifications, a specific user’s read notifications, or notifications received in a specific time frame.  In addition to clearing out notifications, these scripts can provide relief from performance symptoms related to excessive undeleted notifications

>

Hope this helps

-Raj

Agile Angel Answered on January 27, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.