Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-245

BATCH_MODE says PROCESSING even though query finished running

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.08a
    • 1.7.08b
    • CRC Cell
    • None
    • Timeline View
    • i2b2 Core
    • All databases
    • Code changes were done by Mike Mendis
    • verified the statuses are now updated correctly. When a query finishes running the BATCH_MODE is now set to FINISHED and the timeline will be automatically generated.

    Description

      The BATCH_MODE in the QT_QUERY_INSTANCE table is not getting set to the correct status when a query finishes running. Currently it is getting set to PROCESSING and it should be FINISHED.

      As a result the wrong status for the <batch_mode> is sent in the xml message that is returned to the client. If the result type of TIMELINE is checked when running a query the client will automatically generate the timeline when the query has finished running. The workbench uses the <batch_mode> sent in the response message to determine whether or not a query has finished. Since the <batch_mode> is being sent as PROCESSING, the Workbench determines it should not generate the timeline. As a result, users have to take the added steps of going to Previous Queries and manually dragging the query to the Timeline view to generate the timeline.

      Attachments

        Activity

          jmd86 Janice Donahoe created issue -
          jmd86 Janice Donahoe made changes -
          Field Original Value New Value
          Fix Version/s 1.7.08b [ 10601 ]
          Assignee Janice Donahoe [ jmd86 ]
          i2b2 Sponsored Project/s i2b2 Core [ 10196 ]
          Status New [ 10000 ] Open [ 1 ]
          jmd86 Janice Donahoe made changes -
          Rank Ranked higher
          jmd86 Janice Donahoe made changes -
          Sprint Release 1.7.08b [ 16 ]
          jmd86 Janice Donahoe made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          The BATCH_MODE in the QT_QUERY_INSTANCE table will now be updated to FINISHED once a query finishes running.

          The <batch_mode> sent in the response xml will now have the correct status of FINISHED.
          jmd86 Janice Donahoe added a comment - The BATCH_MODE in the QT_QUERY_INSTANCE table will now be updated to FINISHED once a query finishes running. The <batch_mode> sent in the response xml will now have the correct status of FINISHED.
          jmd86 Janice Donahoe made changes -
          Developer Notes Code changes were done by Mike Mendis
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Testing Notes verified the statuses are now updated correctly. When a query finishes running the condition_type status is now set to DONE.
          Status Testing [ 10002 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Testing Notes verified the statuses are now updated correctly. When a query finishes running the condition_type status is now set to DONE. verified the statuses are now updated correctly. When a query finishes running the BATCH_MODE is now set to FINISHED and the timeline will be automatically generated.
          Status Testing [ 10002 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

            jmd86 Janice Donahoe
            jmd86 Janice Donahoe
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: