[Timer Map] Version 3.0.1 throwing ORA-00904: "LOGENTRIES"."Cyclic_Job_Key": invalid identifier
Forge component by António Dias
Platform Version
11.9.2 (Build 29615)

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!

TimerMapCS.oml

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.