Clarity ppm performance issue for only one user in the application and no one else.

[Legacy User]

Hello,

 

This is a very strange situation we experience in Clarity ppm. One of the user (project manager) has mentioned performance issues while accessing projects and resources pages. We checked the application/servers and everything was fine and the application was working fine from our end. We confirmed that the issue doesn't exist for other users.

 

We then tried to login using the user's access into the non-production environment and strangely we experience the same issue mentioned by the user. 

Even our admin login (having access to thousands of resources and projects) is performing good and a project manager's account having comparatively lesser items is facing performance issues. 

 

We are planning on raising a CA case on this, Any suggestions or thoughts on what could be the reason? Thanks in advance.

 

We didn't get much on logs as well.

WARN 2017-02-27 04:21:50,548 [http-nio-8140-exec-2] uif.VXMLImages (clarity:y3C7ZW3G:16726941__334610C0-52C9-46B5-9FE0-33C9F2625FE3:mainnav.work) VXML Image "null" not found in VXMLImages map. Please add or change VXML to use the constant!
WARN 2017-02-27 04:23:46,212 [http-nio-8140-exec-7] uif.VXMLImages (clarity:y3C7ZW3G:16726941__334610C0-52C9-46B5-9FE0-33C9F2625FE3:projmgr.getResourceProjectObjectList) VXML Image "null" not found in VXMLImages map. Please add or change VXML to use the constant!

~Thanks,
Arun

[David Morton]

Does the user have lots of INSTANCE access rights?

(admins will tend to have GLOBAL rights rather than individual INSTANCE rights i would think)

[Deactivated User]

Which version is that.

If I recall correctly the instance rights in 12.0 were behaving just like that.

For global to open the project list with a couple of hundred projects 10 seconds

With instance rights 2 - 3 minutes or time out.

Due to bad queries when checking user access.

[Legacy User]

Thanks Urmas for the response.

 

We are using Clarity PPM 15.1.  The user totally has 12 instance rights on resources and projects object. We are currently checking the SQL trace.

 

~Arun

[Deactivated User]

It is easy to remove the instance rights and give global instead on the non-prod environment.

Why don't you try it for the fun of it?

[Legacy User]

Thanks David for the response.

 

The user totally has 12 instance rights on resources and projects object. We are currently checking the SQL trace to analyze the query execution delay.

~Thanks,
Arun

[David Morton]

^ thats not really 12 instance rights ; thats 12 types of instance rights - you don't see the instance(s) until you click into the right itself and then you'll see the list of instance(s) that the right is over.

 

Having said that, there is not any obvious "Project - View" types there, but I'd look at all the Resource ones - are they needed at instance level (or could they be OBS, GLOBAL).

 

(GUESSing obviously, the SQL trace will help)

[Andrew M]

Hi Arun,

 

There's nothing in the last patch for 15.1 for this area, something i'd expect by now if this were a wide spread issue.

 

First i'd start by taking a XOG read of the resource and checking out the rights in play.

Then clone those rights onto another fresh test user, then start stripping it back till performance is good.

You might be hitting a new bug, but it's likely just the performance of the security rights view

 

If you do raise a case with CA having this XOG and a SQL trace for the user will help get this moving.

 

Andrew

[vtleogal]

was a resolution or root cause ever found?