Mass ExecuteTemplates after 9.2.1 upgrade ?

Which version did you upgrade from?

Which version did you upgrade from?

Hello Troy

Thank you for paying attention to my post.

We migrated from 9.0 LTS to 9.2.1.

We could consider that "ExecuteTemplates" is never harmful and necessarily lead to a more consistent situation but they are some cases where we live with inconsistencies which are temporary and that we intentionally don't repair. 

Many thanks for your advice. 

Michel

Any news after my precision on the version ? 
Maybe I should contact the support ? 

There is no way to disable the post-upgrade mass operation aka ExecuteTemplates. If you take the responsibility to work with inconsistent data - you can stop the JobService from running these jobs and get rid of them. But you may end up with inconsistent data. I do not think that support will tell you something different but as always you are free to ask.

OK but how to know in advance the list of tables on which the ExecuteTemplates is applied ? 
For each table, is it applied on all objects of the table or only some of them on the basis of a given rule ? 
I'd like being able to do a "pre-upgrade review" to be prepared for the inevitable modifications. 
Many thanks again Markus.

I created this script to look for objects with properties that have, let's call it: outstanding template calculations.
And use it as a maintenance/pre-upgrade check. Use at your own risk (i'm not a Quest employee), so understand and test first.

Get-Content .\OutstandingTemplatesPerson.xml | Select-String 'Columnname=".+?(?=\")' -AllMatches | ForEach-Object{$_.Matches.Value} | Group-Object

#If Not SCRIPTDEBUGGER Then
    Imports System.Collections.Generic
#End If

Public Function CCC_FindObjectsWithOutstandingTemplates(
    Optional ByVal dialogTableWhereClause As String = "TableName = 'Person'",
    Optional ByVal outputPath As String = "OutstandingTemplatesOverview.xml") As Boolean

    If String.IsNullOrEmpty(dialogTableWhereClause) Then
        dialogTableWhereClause = "1=1"
    End If     
        
    If outputPath.StartsWith(".") Or Not System.IO.Path.HasExtension(outputPath) Then
        Throw New Exception("Invalid outputPath")
    End If
    
    Dim f = Session.SqlFormatter()
    Dim hasOutstandingTemplates As Boolean = False
    
    Dim whereClause = f.AndRelation(
                        $"UID_DialogTable IN (SELECT UID_DialogTable FROM DialogColumn WHERE Template IS NOT NULL)", _
                        dialogTableWhereClause)

    Dim tableNames = Session.Source().GetCollection(Query _
                .From("DialogTable") _
                .Where(whereClause) _
                .Select("TableName"), EntityCollectionLoadType.Slim) _
                .Select(Function(e) e.GetValue(Of String)("TableName")) _
                .ToList()

    Dim outstandingTemplatesOverview As New StringBuilder()
    
    For Each tableName In tableNames
          Dim entityCol = Session.Source().GetCollection(Query.From(tableName).Where("1=1").SelectAll(),
                                                            EntityCollectionLoadType.Slim)
    
        For Each colElement As IEntity In entityCol
            Dim myObject = colElement.Create(Session, EntityLoadType.Interactive)        
            
            myObject.ExecuteTemplates(Session)
            If myObject.IsChanged Then
                Dim thePatch = EntityPatch.Create(myObject, Session.MetaData(), DiffMode.Changed)
                outstandingTemplatesOverview.AppendLine(thePatch.ToXml().ToString)
            End If
        Next
    Next

    If outstandingTemplatesOverview.Length > 0 Then
        Using writer As System.IO.StreamWriter =
            New System.IO.StreamWriter(outputPath)
            writer.Write(outstandingTemplatesOverview.ToString)
        End Using
        hasOutstandingTemplates = True
    End If
    
    Return hasOutstandingTemplates
End Function

Just discovered that all ExecuteTemplate jobs are not launched on all the columns but on the column "NeverConnectToPerson" only and therefore there is no reason to have a huge peak of updates in the jobqueue. I am now confident with the idea of letting things as is and to let the job "ExecuteTemplates" running. 

Thank you Niels for you great script ! But as I just explained above, I won't block anything since I discovered that all "ExecuteTemplates" jobs are launched only on the column "NeverConnectToPerson" and not on all the columns of the tables.There should not be any provisioning jobs that will be generated in the end.