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

Order.state_text with more than 100 characters stops JobScheduler

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.3.1
    • 1.9
    • None
    • 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

            jz Joacim Zschimmer
            jz Joacim Zschimmer
            Joacim Zschimmer Joacim Zschimmer
            Andreas Püschel Andreas Püschel
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: