• State Not Answered
  • Replies 5 replies
  • Subscribers 96 subscribers
  • Views 1266 views
  • Users 0 members are here
Options
Related

Schedules in Designer not running

stig ingvar hylen
over 1 year ago

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
  • 0 over 1 year ago

    select Ident_RulerDetect, SQLQuery from PWODecisionRuleRulerDetect where XDateUpdated > dateadd(dd, -10, getutcdate())

  • 0 over 1 year ago in reply to Niels de Groot

    Thanks Niels,

    There are no decision rules updated last 10 (or 20 days). 

  • 0 over 1 year ago in reply to stig ingvar hylen

    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

  • 0 over 1 year ago in reply to stig ingvar hylen

    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?

Reply
  • 0 over 1 year ago in reply to stig ingvar hylen

    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?

Children
No Data