Error when Scheduling a task with cron syntax - Bugs & Issues - Bugs & Issues - Progress Community

Error when Scheduling a task with cron syntax

 Bugs & Issues

Error when Scheduling a task with cron syntax

  • Error when Scheduling a task with cron syntax
  • When scheduling a task, I get a SqlDateTime overflow error. Has anyone else encountered this (and resolved). Scheduling a task syntax/process I'm using:

    /// <summary>
    /// Schedule the next instant for the task
    /// </summary>
    public static void ScheduleTask()

    var newTask = new MyCustomScheduledTask

    ScheduleSpec = "* * * * * *", // The task will execute Each minute
    ScheduleSpecType = "crontab",
    Key = "MyUniqueGuidKey"
    ;

    var schedulingManager = SchedulingManager.GetManager();
    schedulingManager.AddTask(newTask);
    schedulingManager.SaveChanges(); // EXCEPTION THROWN HERE

    Exception details:

    Insert of '1813439742-23624f52-e7e1-6533-860d-ff00001065ab' failed: System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute(Nullable`1 commandTimeout) at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute(Nullable`1 commandTimeout) at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes, BatchControlInfo batchControl) INSERT INTO [sf_scheduled_tasks] ([application_name], [description], [enabled], [execute_time], [id], [instance_name], [is_recurring], [is_running], [ky], [language], [last_executed_time], [last_modified], [progress], [schedule_data], [status], [status_message], [subscr_lst_id], [task_data], [task_name], [title], [type_of_schedule], [voa_version]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (set event logging to all to see parameter values) System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute(Nullable`1 commandTimeout) at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute(Nullable`1 commandTimeout) at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes, BatchControlInfo batchControl)