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

Order History can not be displayed for distributed orders

    XMLWordPrintable

Details

    • Fix
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.3.4
    • 1.3.5
    • Job Scheduler Binaries
    • None
    • Windows, MySQL, distributed orders

    Description

      11:28:52.281 scheduler 172 1824.CB0 701.875MB

      {scheduler}

      Execute <?xml version="1.0" encoding="ISO-8859-1"?><show_job_chain job_chain="/params_test" max_order_history="50" what="job_chain_orders job_chain_jobs order_history blacklist"/>
      11:28:52.281 scheduler 0 1824.CB0 701.875MB xmlSchemaValidateDoc()
      11:28:52.281 scheduler 0 1824.CB0 701.875MB .jdbc: prepareStatement select count from SCHEDULER_ORDERS where "SPOOLER_ID"='scheduler.balance' and "JOB_CHAIN"='params_test' and "DISTRIBUTED_NEXT_TIME" is not null
      11:28:52.281 scheduler 0 1824.CB0 701.875MB .jdbc: prepareStatement select count from SCHEDULER_ORDERS where "DISTRIBUTED_NEXT_TIME" is not null and "SPOOLER_ID"='scheduler.balance' and "JOB_CHAIN"='params_test' and "STATE"='start'
      11:28:52.281 scheduler 0 1824.CB0 701.875MB .jdbc: prepareStatement select "ID", "PRIORITY", "STATE", "STATE_TEXT", "INITIAL_STATE", "TITLE", "CREATED_TIME", "JOB_CHAIN", "OCCUPYING_CLUSTER_MEMBER_ID" from SCHEDULER_ORDERS where "SPOOLER_ID"='scheduler.balance' and "JOB_CHAIN"='params_test' and "STATE"='start' and "DISTRIBUTED_NEXT_TIME" is not null and ( "OCCUPYING_CLUSTER_MEMBER_ID"<>'scheduler.balance/al:4242' or "OCCUPYING_CLUSTER_MEMBER_ID" is null ) order by "DISTRIBUTED_NEXT_TIME", "PRIORITY", "ORDERING" limit 2147483647
      11:28:52.296 scheduler 16 1824.CB0 701.875MB .jdbc: prepareStatement SELECT "ORDER_XML" FROM SCHEDULER_ORDERS where "ID"='params_test' and "JOB_CHAIN"='params_test' and "SPOOLER_ID"='scheduler.balance'
      11:28:52.296 scheduler 0 1824.CB0 701.875MB .jdbc: prepareStatement select count from SCHEDULER_ORDERS where "DISTRIBUTED_NEXT_TIME" is not null and "SPOOLER_ID"='scheduler.balance' and "JOB_CHAIN"='params_test' and "STATE"='change'
      11:28:52.312 scheduler 15 1824.CB0 701.875MB .jdbc: prepareStatement select "ID", "PRIORITY", "STATE", "STATE_TEXT", "INITIAL_STATE", "TITLE", "CREATED_TIME", "JOB_CHAIN", "OCCUPYING_CLUSTER_MEMBER_ID" from SCHEDULER_ORDERS where "SPOOLER_ID"='scheduler.balance' and "JOB_CHAIN"='params_test' and "STATE"='change' and "DISTRIBUTED_NEXT_TIME" is not null and ( "OCCUPYING_CLUSTER_MEMBER_ID"<>'scheduler.balance/al:4242' or "OCCUPYING_CLUSTER_MEMBER_ID" is null ) order by "DISTRIBUTED_NEXT_TIME", "PRIORITY", "ORDERING" limit 2147483647
      11:28:52.312 scheduler 0 1824.CB0 701.875MB .jdbc: prepareStatement select count from SCHEDULER_ORDERS where "DISTRIBUTED_NEXT_TIME" is not null and "SPOOLER_ID"='scheduler.balance' and "JOB_CHAIN"='params_test' and "STATE"='end'
      11:28:52.312 scheduler 0 1824.CB0 701.875MB .jdbc: prepareStatement select "ID", "PRIORITY", "STATE", "STATE_TEXT", "INITIAL_STATE", "TITLE", "CREATED_TIME", "JOB_CHAIN", "OCCUPYING_CLUSTER_MEMBER_ID" from SCHEDULER_ORDERS where "SPOOLER_ID"='scheduler.balance' and "JOB_CHAIN"='params_test' and "STATE"='end' and "DISTRIBUTED_NEXT_TIME" is not null and ( "OCCUPYING_CLUSTER_MEMBER_ID"<>'scheduler.balance/al:4242' or "OCCUPYING_CLUSTER_MEMBER_ID" is null ) order by "DISTRIBUTED_NEXT_TIME", "PRIORITY", "ORDERING" limit 2147483647
      11:28:52.312 scheduler 0 1824.CB0 701.875MB .jdbc: prepareStatement select "ORDER_ID", "HISTORY_ID", "JOB_CHAIN", "START_TIME", "END_TIME", "TITLE", "STATE", "STATE_TEXT" from SCHEDULER_ORDER_HISTORY where "JOB_CHAIN"='params_test' and "SPOOLER_ID"='scheduler.balance' order by "HISTORY_ID" desc limit 50
      11:28:52.328 scheduler 16 1824.CB0 701.875MB [xc.insert 1, "java.sql.SQLException"]
      11:28:52.328 scheduler 0 1824.CB0 701.875MB [xc.insert 2, "Value '0000-00-00' can not be represented as java.sql.Timestamp"]
      11:28:52.328 scheduler 0 1824.CB0 701.875MB [xc.insert 3, "getString"]
      11:28:53.468 scheduler 1140 1824.CB0 701.875MB [ERROR Z-JAVA-105 Java exception java.sql.SQLException("Value '0000-00-00' can not be represented as java.sql.Timestamp"), method=getString []]

      Attachments

        Activity

          People

            vg Victor Garcia-Beltran (Inactive)
            al Andreas Liebert (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: