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

Single panel exclusion query returns error

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.09b
    • 1.7.09c
    • CRC Cell
    • None
    • Query Tool
    • Constraints - Exclusion
    • All databases, Oracle, PostgreSQL, SQL Server

    Description

      When you run a single panel query that is marked for exclusion an error is returned from the server.

      IMPORTANT: This error only happens when the following parameter in the crc.properties file is set to true:

      # DERIVED FACT TABLE
      queryprocessor.multifacttable=true


      If the above parameter is set to false, meaning you are not using multiple facts, then you will not encounter this error.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          jmd86 Janice Donahoe created issue -
          jmd86 Janice Donahoe made changes -
          Field Original Value New Value
          Assignee Lori Phillips [ lcp5 ]
          jmd86 Janice Donahoe made changes -
          Description When you run a single panel query that is marked for exclusion an error is returned from the server. When you run a single panel query that is marked for exclusion an error is returned from the server.

          NOTE:
          This only happens when the following parameter in the crc.properties file is set to true:

          # DERIVED FACT TABLE
          queryprocessor.multifacttable=false
          jmd86 Janice Donahoe made changes -
          Affects Database/s Oracle,SQL Server [ 10187, 10189 ] All databases,Oracle,PostgreSQL,SQL Server [ 10219, 10187, 10188, 10189 ]
          jmd86 Janice Donahoe made changes -
          Description When you run a single panel query that is marked for exclusion an error is returned from the server.

          NOTE:
          This only happens when the following parameter in the crc.properties file is set to true:

          # DERIVED FACT TABLE
          queryprocessor.multifacttable=false           		When you run a single panel query that is marked for exclusion an error is returned from the server.

          IMPORTANT: This error only happens when the following parameter in the crc.properties file is set to true:

          # DERIVED FACT TABLE
          queryprocessor.multifacttable=true


          If the above parameter is set to false, meaning you are not using multiple facts, then you will not encounter this error.
          jmd86 Janice Donahoe made changes -
          Fix Version/s 1.7.09c [ 10713 ]
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status New [ 10000 ] Resolved [ 5 ]
          jmd86 Janice Donahoe added a comment -
          Tested to be included in 1.7.09c and it appears to be working correctly. As part of the testing scenarios, the fix was tested with the multifacttable parameter turned on (value=true) and turned off (value=false). In addition, all types of queries in which exclusions could be used were re-tested to verify they are still working correctly. No issues were found during the testing process.
          jmd86 Janice Donahoe added a comment - Tested to be included in 1.7.09c and it appears to be working correctly. As part of the testing scenarios, the fix was tested with the multifacttable parameter turned on (value=true) and turned off (value=false). In addition, all types of queries in which exclusions could be used were re-tested to verify they are still working correctly. No issues were found during the testing process.
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

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

            Dates

              Created:
              Updated:
              Resolved: