Error running script 'VI_ITShopOrderNextApprover': "Value InternalName was not found" (4370140)

Error running script 'VI_ITShopOrderNextApprover': "Value InternalName was not found"

The full error:

ErrorMessages (2022-11-08 08:31:38.097) [810222] Error running script 'VI_ITShopOrderNextApprover'.
[810117] Value InternalName was not found.
at VI.JobService.ProcessorThread._ExecuteJob(Job job, JobResult result)
at VI.JobService.JobComponents.MailComponent.Activate(String task)
at VI.JobService.JobComponents.MailComponent._SendRichMail()
at VI.Mail.MailComposer.<Compose>d__6.MoveNext()
at VI.Mail.MailComposer.Compose(IEntity richMail, MailParameters parameters)
at VI.Mail.MailComposer._RenderMessageBody(MailTemplate template, MailBodyFormat bodyFormat, MailParameters parameters, MailMessage msg)
at System.Text.RegularExpressions.Regex.Replace(String input, MatchEvaluator evaluator)
at System.Text.RegularExpressions.RegexReplacement.Replace(MatchEvaluator evaluator, Regex regex, String input, Int32 count, Int32 startat)
at VI.DB.Scripting.PlaceholderReplacer._Replace(Match m)
at VI.Base.SyncActions.Do[T,T1,T2](T1 p1, T2 p2, Func`3 function)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
--- End of stack trace from previous location where exception was thrown ---
at VI.DB.Entities.EntityWalker.<GetRawAsync>d__20.MoveNext()
---- Start of Inner Exception ----
at DynScripts.ProductScripts_vucXTRwJCpv1ccIoHk9bzeni03LywsGM.VI_ITShopOrderNextApprover(IEntity dbPwOHelperPwO)
at VI.DB.Entities.EntityBase.GetValue(String definition)
at VI.DB.Entities.EntityBase.GetRaw(String definition)
 

The default mail template (DialogRichMail) "IT Shop request - approval required" uses the script "VI_ITShopOrderNextApprover", which assumes the default display pattern "%InternalName% (%CentralAccount%)" for persons and selects the InternalName by name (analogous to customer-specific mail templates that use this script).

If the display pattern for the Person table has been customized (without using InternalName), errors occur when generating the emails for notifying the next decision-maker.

WORKAROUND

From the script "VI_ITShopOrderNextApprover", change "SelectDetails()" for "SelectAll()" and save it under a custom script.

STATUS

Hotfix #36214 is available by request from Support.

36214