Uploaded image for project: 'JOC - JobScheduler Operations Center'
  1. JOC - JobScheduler Operations Center
  2. JOC-1196

Daily Plan - Modify Variables - Column 'CONTROLLER_ID' cannot be null

    XMLWordPrintable

Details

    Description

      Current Situation

      • In some situations (e.g. internal error in the Daily Plan during evaluation of order variables) it is not possible to modify the order variables and the following error occurs:
        • SOSHibernateObjectOperationException: could not execute statement: 1048 (conn=33716) Column 'CONTROLLER_ID' cannot be null

      Desired Behaviour

      • The operation to modify variables should work.

      Test instructions

      • use attached joc_1196.zip configuration file
        • configure a schedule for execution later in the date
      • after deployment switch to the "Daily Plan" view an create the Daily Plan for the configured schedule
      • use MySQL Workbench and execute query:
        • DELETE FROM DPL_ORDER_VARIABLES where ORDER_ID='<use order id generated by Daily Plan>';
      • from the action menu of order in then Daily Plan view select Modify Variables and change the values of variables for the order.
        • check the execution result:
          • the variable(s) should be added to the order
          • check the joc.log file

      Attachments

        Activity

          People

            re Robert Ehrlich
            re Robert Ehrlich
            Aditi Dubey Aditi Dubey (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: