Hello,
Our business is complaining that a specific process (EH_UNSAccountB_Insert_OADM Retrieve Contact Information) is taking too much time (around 4-5 minutes). When creating a customer account in the OIM web interface, they assign a contact identifier (OADM Id) and this process is triggered to retrieve contact information from another system (OADM). Information are retrieved by a web service call to OADM.
We changed the specific code of this process: the code linked to a log was activated for every process run. It is not the case anymore. This code is now activated only if a configuration parameter is set to True (just in case of debugging).
Another idea is to increase the priority of process steps related to this process. The priority of those process steps has been changed from 3 to 2.
You can see below an example of test carried out after having changed the code and the priority of process steps:
GenProcID | JobChainName | Queue | Priority | TaskName | StartAt | EndedAt | Time Processing |
eff5889c-c694-4361-8270-75c3f29e6d0f | Created by QBMDBQueueProcess:PersonInAERole | \D1JUFRDTC01 | 5 | FireGenEvent | 28/11/2019 17:07:04 | 28/11/2019 17:08:07 | 00:01:03 |
eff5889c-c694-4361-8270-75c3f29e6d0f | Created by QBMDBQueueProcess:PersonInAERole | \D1JUFRDTC01 | 5 | FireGenEvent | 28/11/2019 17:07:04 | 28/11/2019 17:08:07 | 00:01:03 |
eff5889c-c694-4361-8270-75c3f29e6d0f | Created by QBMDBQueueProcess:PersonHasTSBAccountDef | \D1JUFRDTC01 | 5 | FireGenEvent | 28/11/2019 17:11:24 | 28/11/2019 17:12:38 | 00:01:13 |
eff5889c-c694-4361-8270-75c3f29e6d0f | TSB_PersonHasTSBAccountDef_Autocreate_UNSAccountB | \D1JUFRDTC01 | 3 | Exists | 28/11/2019 17:12:38 | 28/11/2019 17:14:07 | 00:01:29 |
eff5889c-c694-4361-8270-75c3f29e6d0f | TSB_PersonHasTSBAccountDef_Autocreate_UNSAccountB | \D1JUFRDTC01 | 3 | Exists | 28/11/2019 17:12:38 | 28/11/2019 17:14:08 | 00:01:29 |
eff5889c-c694-4361-8270-75c3f29e6d0f | TSB_PersonHasTSBAccountDef_Autocreate_UNSAccountB | \D1JUFRDTC01 | 3 | ScriptExecSingle | 28/11/2019 17:12:38 | 28/11/2019 17:14:11 | 00:01:33 |
eff5889c-c694-4361-8270-75c3f29e6d0f | TSB_PersonHasTSBAccountDef_Autocreate_UNSAccountB | \D1JUFRDTC01 | 3 | Insert | 28/11/2019 17:12:38 | 28/11/2019 17:14:11 | 00:01:33 |
eff5889c-c694-4361-8270-75c3f29e6d0f | EH_UNSAccountB_Insert_Calculate Permissions | \D1JUFRDTC02 | 3 | Update | 28/11/2019 17:14:11 | 28/11/2019 17:15:12 | 00:01:01 |
eff5889c-c694-4361-8270-75c3f29e6d0f | EH_UNSAccountB_Insert_OADM Retrieve Contact Information | \D1JUFRDTC01 | 2 | ScriptExec | 28/11/2019 17:14:11 | 28/11/2019 17:14:24 | 00:00:12 |
eff5889c-c694-4361-8270-75c3f29e6d0f | EH_UNSAccountB_Insert_OADM Retrieve Contact Information | \D1JUFRDTC01 | 2 | Execute SQL | 28/11/2019 17:14:11 | 28/11/2019 17:14:23 | 00:00:11 |
eff5889c-c694-4361-8270-75c3f29e6d0f | EH_Person_Insert_Update_Push data for IRP Distribution Plan | \D1JUFRDTC01 | 3 | ScriptExec | 28/11/2019 17:14:24 | 28/11/2019 17:15:40 | 00:01:15 |
eff5889c-c694-4361-8270-75c3f29e6d0f | EH_PersonHasTSBAccountDef_Update_Synchronize Permissions | \D1JUFRDTC01 | 3 | ScriptExec | 28/11/2019 17:15:12 | 28/11/2019 17:15:39 | 00:00:27 |
eff5889c-c694-4361-8270-75c3f29e6d0f | EH_PersonHasTSBAccountDef_Update_Synchronize Permissions | \D1JUFRDTC01 | 3 | Not Exists | 28/11/2019 17:15:12 | 28/11/2019 17:15:38 | 00:00:25 |
We could also change the priority of process steps of the standard process TSB_PersonHasTSBAccountDef_Autocreate_UNSAccountB but this is not allowed in the Designer: the priority is greyed (Priority.CanEdit is False on Extended tab of process step properties).
Do you advise to change the priorities of process steps of such a standard process? If yes, directly by SQL?
Do you see any other options that we could use to improve the time processing of this specific process?
Kind regards,
P. Vittadello
Euler Hermes IAM Competenicy Centre