[Timer Map] TimerMap 3.0.1 throwing an error in Oracle, "ORA-01843: not a valid month"
Forge component by António Dias
Platform Version
11.9.2 (Build 29615)

Hi folks,


Any idea why this error, thrown by an Aggregate? While testing in Service Studio it does not throw any error, but also outputs no results, either.


[1] Error executing query.
at ssTimerMap.Flows.FlowMainFlow_v3.ScrnHeatmap_TimerRuns.FuncssPreparation.datasetGetMostFrequentTimes(HeContext heContext, Int32 maxRecords, IterationMultiplicity multiplicity, Int64& outParamCount, DateTime qpdaTimerRun_StartDate, Boolean qpboIncludeZeroDuration)
at ssTimerMap.Flows.FlowMainFlow_v3.ScrnHeatmap_TimerRuns.Preparation(HeContext heContext)
at ssTimerMap.Flows.FlowMainFlow_v3.ScrnHeatmap_TimerRuns.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[2] ORA-01843: not a valid month
at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF)
at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
at OutSystems.HubEdition.DatabaseProvider.Oracle.ExecutionService.ExecutionService.ExecuteReader(IDbCommand cmd)
at OutSystems.Internal.Db.DatabaseAccess.ExecuteWithoutRequestTimeout[T](Func`1 action)
at OutSystems.Internal.Db.ManagedCommand.ExecuteReader(String description, Boolean isApplication, Boolean transformParameters, Boolean skipLog)
at OutSystems.Internal.Db.DatabaseAccessProvider`1.ExecuteQuery[T](Command cmd, GenericRecordList`1 rl, String description, Boolean transformParameters, Boolean skipLog)
   at ssTimerMap.Flows.FlowMainFlow_v3.ScrnHeatmap_TimerRuns.FuncssPreparation.datasetGetMostFrequentTimes(HeContext heContext, Int32 maxRecords, IterationMultiplicity multiplicity, Int64& outParamCount, DateTime qpdaTimerRun_StartDate, Boolean qpboIncludeZeroDuration)



Image69.png

Hey Pedro,

Can you check if changing from:


To a nulldate():


Solves the error?

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