Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon
No ratings
prashantChauhan
Saviynt Employee
Saviynt Employee

Use Case

When creating a trigger chain job you note that the job does not run unless you reduce the count of jobs present in the trigger chain.
In theory, there should be no limitation to the total number of jobs in a single trigger chain job as long as the criteria for trigger chain jobs are met such as the appropriate number of WSRETRY jobs.

 However you may notice that some trigger chain jobs do not run as expected unless you reduce the total number of jobs in the trigger chain. Yet, other trigger chain jobs will run with the same number of jobs or more as part of the job's configuration.

 This can happen due to the character limit imposed by the externalconnection column in the ecmimportjob table.

This column has a limitation of datatype varchar(255). 

When the trigger chain is set to run, an entry for the trigger chain job will be written to the ecmimportjob table. All of the individual job names that are a part of the chain are combined into a single string with a comma separating job names and ##Continue appended to the end of the string.

That string of text is then written to the externalconnection column inside the ecmimportjob table as part of the entry for the trigger chain job. Therefore if the total number of characters in this string, including commas and ##Continue, exceeds anything more than 255 characters the job will not be able to insert the string of text, and the job will not proceed.

Example: 
UPDATEUSER_RESCINDED,WORKDAY_RESCHIRES,WORKDAY_RESC_TERMINATIONS,WORKDAY_DEMOGRAPHIC,WORKDAY_NEWHIRES,WORKDAY_TERMINATIONS,COMPUTE_SAMACCOUNTNAME_DN,AD_NEW_ACCOUNT_RETRY##Continue 
This string is 178 characters in total. This string can be inserted into the externalconnection column and the job entry will be written to the ecmimportjob table. The job will proceed to run.
Import_ActiveDirectory_Corp_Accounts,Import_ActiveDirectory_Corp_Service_Accounts,Import_ActiveDirectory_Privileged_Accounts,Import_ActiveDirectory_Stores_Account,Import_ActiveDirectory_Stores_Service_Accounts,Import_AD_MDC46673_Accounts_Full,Import_AD_MDC9292_Accounts_Full,Import_AD_MDC42_Accounts_Full##Continue

This string is 314 characters in total. This string cannot be inserted into the externalconnection column and the job entry will not be written to the ecmimportjob table. The job will not run.

 

Pre-requisites

 

NA

Applicable Version(s)


All
 

Solution

If you large number of jobs in the chain then get first copy each name to a text file. Add a comma between each job name and append ##Continue to the end of the string. Count the total number of characters in the string. If it exceeds 255 characters in total the trigger chain job will fail to run.

If this character limit is exceeded then reduce the number of jobs in the trigger chain or rename jobs with shorter names.


References

https://docs.saviyntcloud.com/bundle/EIC-Database-Schema-Reference/page/Content/Database-Schema-Refe...

Comments
ArvindKumar33
New Contributor III
New Contributor III

Hi, 

Thanks for the resolution on this use case. Is there a way to increase the database level datatype varchar(255) limit without reducing the jobs?

Regards, Arvind

 

 

 

rushikeshvartak
All-Star
All-Star

Why note is not added on job page ?

what is plan to extend size ?

 

BarCar
Regular Contributor
Regular Contributor

Regarding the solution "rename jobs with shorter names" - you cannot rename an existing job. See idea EIC-I-4390 Ability to rename various configuration item | Saviynt Ideas Portal.

Seems like the obvious solution would be to use some sort of Job ID rather than the name.

Version history
Last update:
‎07/11/2023 07:13 AM
Updated by: