Schedules in Designer not running

Hi,

We are having a urgent issue with scheduled jobs. The scheduled jobs are NOT starting. The issue started on june 30th. 

This is our findings:

  • From the system journal: Tasks not processed because the script assemblies are not valid
  • From the system journal:(execute slot single)50000 0 re-throw in Procedure QER_ZPWODecisionRuleMakeProc, Line 6350000 0 re-throw in Procedure QBM_PSQLCreate, Line 2650000 0 re-throw in Procedure QBM_PExecuteSQLWithRetry, Line 1150000 0 re-throw in Procedure QBM_PExecuteSQLWithRetry, Line 7207 0 detected in (SRV=SQL104, DB=OneIM) Procedure GEN_FTA991252E763F0A79F5085788, Line 3207 0 Invalid column name 'UID_PWORulerOrigin'.

  • From Compiling: Object reference not set to an instance of an object.

We are not able to see what the root cause is for this issue.

Any help is appreciated

Regards

Stig Hylen

Parents Reply Children
  • You could try this script in order to find the data change that might have caused this issue.
    I would recommend calling support.

    Public Sub ChangedData()
    	Dim f = Session.SqlFormatter()
    	
    	Dim tableNames = Session.Source().GetCollection(Query _
                .From("DialogTable") _
    			.Where($"UID_DialogTable IN (SELECT UID_DialogTable FROM DialogColumn WHERE ColumnName = 'XDateUpdated')") _
                .Select("TableName"), EntityCollectionLoadType.BulkReadOnly) _
    			.Select(Function(e) e.GetValue(Of String)("TableName")) _
    			.ToList()
    	
    	Dim dateAfter As DateTime = New DateTime(2023, 6, 29)
    	Dim dateBefore As DateTime = New DateTime(2023, 7, 1)
    	
    	Dim changedEntries As New StringBuilder()
    	
    	For Each tableName In tableNames
      		Dim iCount = Session.Source().GetCount(Query _
                .From(tableName) _
                .Where(f.AndRelation( _
                    f.Comparison("XDateUpdated", dateBefore, ValType.Date,
                        CompareOperator.LowerThan, FormatterOptions.ConvertNull),
                    f.Comparison("XDateUpdated", dateAfter, ValType.Date,
                        CompareOperator.GreaterThan, FormatterOptions.ConvertNull))) _
                .SelectCount())
    			
    		If iCount > 0 Then changedEntries.AppendLine($"{tableName} - {iCount}")
    	Next
    	Throw New Exception(changedEntries.ToString)
    End Sub

  • The PWODecisionRule mentioned in the error message can be identified with the following SQL.

    select dbo.QER_FCVRuleGUIDToFunctionName(UID_PWODecisionRule), UID_PWODecisionRule, DecisionRule, Description, UsageArea from PWODecisionRule 
    where
    dbo.QER_FCVRuleGUIDToFunctionName(UID_PWODecisionRule) = 'GEN_FT92A0FE6C59034655563CF408'

    About the compilation error, you should at least be able to identify at which part of the compilation (Templates, Scripts, Processes) the compilation fails. Is that the case or at which compilation phase are you seeing the error?