Hello all,
We have made an Analytics to Disable the User Accounts on Termination Date and Scheduled "Run all Analytics Job".
The tasks were getting created as expected but as the time passes by, Duplicate tasks are getting created more often for a few users.
Analytics Query:
SELECT
u.USERNAME,
a.NAME,
u.enddate,
a.ACCOUNTKEY as acctKey,
e.ENDPOINTNAME,
'Disable Account' as Default_Action_For_Analytics
FROM
(
(
(
users u
INNER JOIN user_accounts ua ON ua.USERKEY = u.USERKEY
)
INNER JOIN accounts a ON a.ACCOUNTKEY = ua.ACCOUNTKEY
)
INNER JOIN endpoints e ON e.ENDPOINTKEY = a.ENDPOINTKEY
)
WHERE
(
(
u.enddate = curdate()
AND u.customproperty14 = 'Voluntary'
)
OR (
u.customproperty15 = 'Suspension Leave'
AND STR_TO_DATE(
SUBSTRING_INDEX(u.CUSTOMPROPERTY32, ' ', -1),
'%Y-%m-%d'
)= curdate()
)
)
and e.endpointname IN (
'Local Tenant', 'Global Tenant',
'Jira_Ticket'
)
WSRETRY Job (ProvisioningJob):
We have added 2 Security Systems in this Job as we have Jira as both Provisioning System and as Ticketing System.
ISSUE:
Once the Run all Analytics Job is scheduled, for a user, for Jira Ticketing System, 2 Disable account tasks were created at 2 different times where the Tasks IDs = 11 and 12.
Whenever the Provisioning Job is run for the tasks to create the tickets at Jira application, status of task ID-12=Complete and task ID - 11=No Action Required, which actually should be reverse in the case (Task ID-11 should be Completed and Task ID-12=No Action Required).
What might be the reason for the duplicate task creating for a few users at different times?
Thanks & Regards,
Saviynt Savvy
