Uploaded image for project: 'JS - JobScheduler'
  1. JS - JobScheduler
  2. JS-1367

Order.state_text with more than 100 characters stops JobScheduler

    XMLWordPrintable

    Details

    • Type: Fix
    • Status: Released (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.3.1
    • Fix Version/s: 1.9
    • Component/s: None
    • Labels:
      None

      Description

      After assigning Order.state_text (via API) a string with more then 100 characters, JobScheduler stops after failing to write the value into the database, logging the following error message:

      SCHEDULER-303  Problem with database: SCHEDULER-306  Error when updating table SCHEDULER_ORDERS: Z-JAVA-105  Java exception org.h2.jdbc.JdbcSQLException: Value too long for column "STATE_TEXT VARCHAR(100)": "'*** VERY LONG TEXT ... ***'' (110)"; SQL statement: UPDATE SCHEDULER_ORDER_HISTORY  set "STATE"='END',"STATE_TEXT"='*** VERY LONG TEXT ... ***'  where "HISTORY_ID... [sos::scheduler::order::Order::db_update2]
      

        Attachments

          Activity

            People

            • Assignee:
              jz Joacim Zschimmer
              Reporter:
              jz Joacim Zschimmer
              Resolver:
              Joacim Zschimmer
              Approver:
              Andreas PĆ¼schel
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: