Inactive User creating updates on Project 'Team Tab' in CA PPM
Article ID: 105730
Updated On:
Products
Clarity PPM SaaS
Clarity PPM On Premise
Issue/Introduction
The Team Tab of a Project is showing recent updates from a user who is no longer Active in CA PPM, in the field "Last Updated By."
They are originating from a user who has left the company, and whose user record is both Inactive and Locked.
The source of these updates is not known.
There are no Jobs against this user's name shown in the Job Logs.
This query enabled us to identify each time the issue occurred:
Where "team.last_updated_by" is the ID of the user (Resource) who is Inactive and who shows against the Last Modified By date.
And the date range allows you to narrow down the results to a current time period.
A result here indicates that an update has been made by the nominated user.
Inactive users should not be making entries.
Note that this query does not check whether the user is Active or Inactive.
They are originating from a user who has left the company, and whose user record is both Inactive and Locked.
The source of these updates is not known.
There are no Jobs against this user's name shown in the Job Logs.
This query enabled us to identify each time the issue occurred:
SELECT DISTINCT
(inv.code) AS Project_CODE,
inv.name AS PROJECT_NAME,
abc.user_name AS USER_NAME,
abc.FIRST_NAME,
abc.LAST_NAME,
team.last_updated_date
FROM inv_investments inv
JOIN prteam team
ON inv.id = team.prprojectid
INNER JOIN cmn_sec_users abc
ON inv.manager_id = abc.id
WHERE team.last_updated_by = 5104008
AND team.last_updated_date
BETWEEN TO_DATE('2018/03/01', 'yyyy/mm/dd') AND
TO_DATE('2018/06/19', 'yyyy/mm/dd')
(inv.code) AS Project_CODE,
inv.name AS PROJECT_NAME,
abc.user_name AS USER_NAME,
abc.FIRST_NAME,
abc.LAST_NAME,
team.last_updated_date
FROM inv_investments inv
JOIN prteam team
ON inv.id = team.prprojectid
INNER JOIN cmn_sec_users abc
ON inv.manager_id = abc.id
WHERE team.last_updated_by = 5104008
AND team.last_updated_date
BETWEEN TO_DATE('2018/03/01', 'yyyy/mm/dd') AND
TO_DATE('2018/06/19', 'yyyy/mm/dd')
And the date range allows you to narrow down the results to a current time period.
<Please see attached file for image>
A result here indicates that an update has been made by the nominated user.
Inactive users should not be making entries.
Note that this query does not check whether the user is Active or Inactive.
Environment
CA PPM 15.3 SAAS.
Cause
The root cause is that a Job had become orphaned.
It was still running, but not visible through the user interface.
The root cause trigger is not known. It was investigated in detail from the backend of queries run, and a regular cause was not identified.
We theorise that a Job became stuck while the user status was changed while a Job was processing.
It was still running, but not visible through the user interface.
The root cause trigger is not known. It was investigated in detail from the backend of queries run, and a regular cause was not identified.
We theorise that a Job became stuck while the user status was changed while a Job was processing.
Resolution
This has been addressed by:
1) Cleanly shutting down all known active Jobs.
2) Clearing all orphaned Jobs
3) Recycling the CA PPM Background Server.
These two documents were used as the reference source:
a) How to cleanup processes in Aborting State
https://comm.support.ca.com/kb/processes-aborting-state/kb000071773
b) CA PPM: Scheduled jobs stuck in waiting or scheduled status
https://comm.support.ca.com/kb/ppm-scheduled-jobs-stuck-in-waiting-or-scheduled-status/KB000049034
If a CA PPM SaaS site encounters this issue, please contact CA Support to run the above procedures.
A CA PPM On-Premise site may run through the steps directly.
NOTE: Common, valid causes should be investigated and ruled out first. The most common is that when a user starts a Job, this is visible to themselves, but not to an Administrator looking into the general Job queue through the interface. You would need to log in as that user to see their Jobs. (Or else deep dive into running Jobs on a production system, which is not typically practical.)
1) Cleanly shutting down all known active Jobs.
2) Clearing all orphaned Jobs
3) Recycling the CA PPM Background Server.
These two documents were used as the reference source:
a) How to cleanup processes in Aborting State
https://comm.support.ca.com/kb/processes-aborting-state/kb000071773
b) CA PPM: Scheduled jobs stuck in waiting or scheduled status
https://comm.support.ca.com/kb/ppm-scheduled-jobs-stuck-in-waiting-or-scheduled-status/KB000049034
If a CA PPM SaaS site encounters this issue, please contact CA Support to run the above procedures.
A CA PPM On-Premise site may run through the steps directly.
NOTE: Common, valid causes should be investigated and ruled out first. The most common is that when a user starts a Job, this is visible to themselves, but not to an Administrator looking into the general Job queue through the interface. You would need to log in as that user to see their Jobs. (Or else deep dive into running Jobs on a production system, which is not typically practical.)
Attachments
Feedback
Yes
No
Powered by
