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

Error returned from the CRC when running a query with result type of Encounter set

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.00, 1.7.01
    • 1.7.02
    • CRC Cell
    • None
    • PostgreSQL
    • Queries
    • Hide
      Tested in both the Web Client and Workbench and appears to be working correctly. Ran several queries in which Encounter set was selected as on of the result types (both alone and with other result types).

      Environment: Tested with the latest PostgreSQL database (bamboo)
      Show
      Tested in both the Web Client and Workbench and appears to be working correctly. Ran several queries in which Encounter set was selected as on of the result types (both alone and with other result types). Environment: Tested with the latest PostgreSQL database (bamboo)

    Description

      The following error occurs when running an i2b2 Query against a PostgreSQL database:

      Operator does not exist: integer = character varying


      The above error will occur only when the result type of Encounter set is selected when running the query.

      Attachments

        Activity

          jmd86 Janice Donahoe created issue -
          jmd86 Janice Donahoe made changes -
          Field Original Value New Value
          Workflow classic default workflow [ 10256 ] i2b2 Issues [ 10316 ]
          jmd86 Janice Donahoe made changes -
          Workflow i2b2 Issues [ 10316 ] i2b2 Issues Workflow [ 10449 ]
          mem61 Mike Mendis made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          mem61 Mike Mendis added a comment -
          I am unable to reproduce this. I ran a query and selected encounter set, and resulted in the correct number.
          mem61 Mike Mendis added a comment - I am unable to reproduce this. I ran a query and selected encounter set, and resulted in the correct number.
          mem61 Mike Mendis made changes -
          Assignee Mike Mendis [ mem61 ] Janice Donahoe [ jmd86 ]
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          jmd86 Janice Donahoe made changes -
          Component/s CRC Cell [ 10049 ]
          Component/s CRC Cell [ 10000 ]
          Key LEOPARD-158 CORE-103
          Project i2b2 [ 10000 ] i2b2 Core Project [ 10034 ]
          Affects Version/s 1.7.01 [ 10154 ]
          Affects Version/s 1.7.00 [ 10153 ]
          Affects Version/s 1.7.00 [ 10081 ]
          Affects Version/s 1.7.01 [ 10090 ]
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Build Number/s (Testing) 1.7.02.0005
          Fix Version/s 1.7.02 [ 10155 ]
          Testing Notes Tested in both the Web Client and Workbench and appears to be working correctly. Ran several queries in which Encounter set was selected as on of the result types (both alone and with other result types).
          Status Testing [ 10002 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Build Number (Fixed) 1.7.02.0005
          Resolution Fixed [ 1 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          Need to test against PostgreSQL.
          jmd86 Janice Donahoe added a comment - Need to test against PostgreSQL.
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          jmd86 Janice Donahoe made changes -
          Status Reopened [ 4 ] In Progress [ 3 ]
          jmd86 Janice Donahoe made changes -
          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 Tested in both the Web Client and Workbench and appears to be working correctly. Ran several queries in which Encounter set was selected as on of the result types (both alone and with other result types). Tested in both the Web Client and Workbench and appears to be working correctly. Ran several queries in which Encounter set was selected as on of the result types (both alone and with other result types).

          Environment: Tested with the latest PostgreSQL database (bamboo)
          i2b2 Feature/s Queries [ 10081 ]
          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:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: