Hi folks,
Found and fixed the following error in Timer AggregateTimerMetrics, SQL CalculateTimerMetrics:
OutSystems.HubEdition.RuntimePlatform.DataBaseException: Error executing query. ---> OutSystems.HubEdition.RuntimePlatform.DataBaseException: Error in advanced query CalculateTimerMetrics in Timer_AggregateTimerMetrics in TimerMap_CS (SELECT LogEntries.[Cyclic_Job_Key], LogEntries.[Espace_Id], COUNT(LogEntries.[Instant]), SUM(CASE WHEN (LogEntries.[Error_Id] LIKE '') THEN 0 ELSE 1 END), AVG(CAST(LogEntries.[Duration] AS DECIMAL)), MIN(LogEntries.[Duration]), MAX(LogEntries.[Duration]) FROM ( SELECT {Log_Cyclic_Job}.* FROM {Log_Cyclic_Job} WHERE {Log_Cyclic_Job}.[Instant] >= @IntervalStart and {Log_Cyclic_Job}.[Instant] < @IntervalEnd UNION SELECT {Log_Cyclic_Job_Previous}.* FROM {Log_Cyclic_Job_Previous} WHERE {Log_Cyclic_Job_Previous}.[Instant] >= @IntervalStart and {Log_Cyclic_Job_Previous}.[Instant] < @IntervalEnd ) LogEntries GROUP BY LogEntries.[Espace_Id], LogEntries.[Cyclic_Job_Key] ): ORA-00904: "LOGENTRIES"."Cyclic_Job_Key": invalid identifier --- End of inner exception stack trace --- at ssTimerMap_CS.Actions.FuncActionTimer_AggregateTimerMetrics.QueryCalculateTimerMetrics(HeContext heContext, Int32 maxRecords, IterationMultiplicity multiplicity, Int64& outParamCount, DateTime qpdaIntervalStart, DateTime qpdaIntervalEnd) at ssTimerMap_CS.Actions.ActionTimer_AggregateTimerMetrics(HeContext heContext)at ssTimerMap_CS.TimerAggregateTimerMetrics.Execute(HeContext heContext, Int32 timeout)
Fix is in the attached module, in case anyone needs it. Suggest this component's team members upload it to a new version.
Cheers!