Uploaded image for project: 'i2b2 Web Client'
  1. i2b2 Web Client
  2. WEBCLIENT-261

Querytool- Ontology terms query run with breakdowns erroring out

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.7.11
    • 1.7.11
    • Web Client
    • None
    • i2b2 Core
    • Oracle
    • edu.harvard.i2b2.crc

    Description

      drag and drop an ontology term onto query tool panel group
      select any of the follwoing options in the query run box
       Length of stay breakdown
       Top 20 medications breakdown
       Top 20 diagnoses breakdown
       Inpatient and outpatient breakdown
      Run the query

      Expected result: Query run successful
      Actual result: Query erroring out

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          rm302 Reeta Metta created issue -
          rm302 Reeta Metta made changes -
          Field Original Value New Value
          Link This issue clone of CORE-315 [ CORE-315 ]
          rm302 Reeta Metta made changes -
          Link This issue clone of CORE-315 [ CORE-315 ]
          rm302 Reeta Metta made changes -
          Description user : demoid
          User role: Select any level except DATA_PROT
          Ontology Term : 'Protected Health Information" with :
          C_ProtectedAccess =N
          C_OntologyProtection= NULL

          log onto with above user
          Expected result: User should be able to view the Ontology term if Protected Access is not set for the Ontology Term irrespective of User role
          Actual result: User is not able to view the Ontology term without any Protected access, for any User role ( except in Data_Prot)
          		user : demoid
          log onto with above user
          drag and drop an ontology term onto query tool panel group
          select any of the follwoing options in the query run box
           Length of stay breakdown
           Top 20 medications breakdown
           Top 20 diagnoses breakdown
           Inpatient and outpatient breakdown
          Run the query

          Expected result: Query run successful
          Actual result: Query erroring out
          rm302 Reeta Metta made changes -
          Attachment screenshot-1.png [ 11140 ]
          rm302 Reeta Metta made changes -
          Link This issue clone of CORE-319 [ CORE-319 ]
          rm302 Reeta Metta made changes -
          Link This issue clone of CORE-319 [ CORE-319 ]
          rm302 Reeta Metta made changes -
          Status New [ 10000 ] Open [ 1 ]
          rm302 Reeta Metta made changes -
          Link This issue clone of CORE-321 [ CORE-321 ]
          rm302 Reeta Metta made changes -
          Link This issue clone of CORE-321 [ CORE-321 ]
          rm302 Reeta Metta made changes -
          Affects Version/s 1.7.11 [ 10703 ]
          mem61 Mike Mendis made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          mem61 Mike Mendis made changes -
          Assignee Mike Mendis [ mem61 ] Reeta Metta [ rm302 ]
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          rm302 Reeta Metta made changes -
          Fix Version/s 1.7.11 [ 10703 ]
          rm302 Reeta Metta made changes -
          Description user : demoid
          log onto with above user
          drag and drop an ontology term onto query tool panel group
          select any of the follwoing options in the query run box
           Length of stay breakdown
           Top 20 medications breakdown
           Top 20 diagnoses breakdown
           Inpatient and outpatient breakdown
          Run the query

          Expected result: Query run successful
          Actual result: Query erroring out
          		drag and drop an ontology term onto query tool panel group
          select any of the follwoing options in the query run box
           Length of stay breakdown
           Top 20 medications breakdown
           Top 20 diagnoses breakdown
           Inpatient and outpatient breakdown
          Run the query

          Expected result: Query run successful
          Actual result: Query erroring out
          rm302 Reeta Metta made changes -
          Attachment screenshot-1.png [ 11140 ]
          rm302 Reeta Metta made changes -
          Comment [ xml response:
               <item>
                      <hlevel>1</hlevel>
                      <item_name>Procedures</item_name>
                      <item_key>\\i2b2_PROC\i2b2\Procedures\</item_key>
                      <item_icon>FA</item_icon>
                      <tooltip>Procedures</tooltip>
                      <class>ENC</class>
                      <item_is_synonym>false</item_is_synonym>
                  </item>
              </panel>
          </ns3:query_definition>
          </request_xml>
                      </query_master>
                      <query_instance>
                          <query_instance_id>43</query_instance_id>
                          <query_master_id>43</query_master_id>
                          <user_id>demoid</user_id>
                          <group_id>SQLServerDemo</group_id>
                          <batch_mode>ERROR</batch_mode>
                          <start_date>2018-12-06T10:33:05.430-05:00</start_date>
                          <end_date>2018-12-06T10:33:15.964-05:00</end_date>
                          <query_status_type>
                              <status_type_id>4</status_type_id>
                              <name>ERROR</name>
                              <description>ERROR</description>
                          </query_status_type>
                      </query_instance>
                      <query_result_instance>
                          <result_instance_id>150</result_instance_id>
                          <query_instance_id>43</query_instance_id>
                          <description>Patient Set for "Procedures@10:31:59"</description>
                          <query_result_type>
                              <result_type_id>1</result_type_id>
                              <name>PATIENTSET</name>
                              <display_type>LIST</display_type>
                              <visual_attribute_type>LA</visual_attribute_type>
                              <description>Patient set</description>
                          </query_result_type>
                          <set_size>-1</set_size>
                          <obfuscate_method/>
                          <start_date>2018-12-06T10:33:05.437-05:00</start_date>
                          <end_date>2018-12-06T10:33:05.923-05:00</end_date>
                          <message/>
                          <query_status_type>
                              <status_type_id>4</status_type_id>
                              <name>ERROR</name>
                              <description>ERROR</description>
                          </query_status_type>
                      </query_result_instance>
                      <query_result_instance>
                          <result_instance_id>151</result_instance_id>
                          <query_instance_id>43</query_instance_id>
                          <description>Number of patients for "Procedures@10:31:59"</description>
                          <query_result_type>
                              <result_type_id>4</result_type_id>
                              <name>PATIENT_COUNT_XML</name>
                              <display_type>CATNUM</display_type>
                              <visual_attribute_type>LA</visual_attribute_type>
                              <description>Number of patients</description>
                          </query_result_type>
                          <set_size>-1</set_size>
                          <obfuscate_method/>
                          <start_date>2018-12-06T10:33:05.443-05:00</start_date>
                          <end_date>2018-12-06T10:33:05.923-05:00</end_date>
                          <message/>
                          <query_status_type>
                              <status_type_id>4</status_type_id>
                              <name>ERROR</name>
                              <description>ERROR</description>
                          </query_status_type>
                      </query_result_instance>
                      <query_result_instance>
                          <result_instance_id>152</result_instance_id>
                          <query_instance_id>43</query_instance_id>
                          <query_result_type>
                              <result_type_id>10</result_type_id>
                              <name>PATIENT_LOS_XML</name>
                              <display_type>CATNUM</display_type>
                              <visual_attribute_type>LA</visual_attribute_type>
                              <description>Length of stay breakdown</description>
                              <user_role_cd>DATA_LDS</user_role_cd>
                          </query_result_type>
                          <set_size>-1</set_size>
                          <obfuscate_method/>
                          <start_date>2018-12-06T10:33:05.450-05:00</start_date>
                          <end_date>2018-12-06T10:33:05.927-05:00</end_date>
                          <message/>
                          <query_status_type>
                              <status_type_id>4</status_type_id>
                              <name>ERROR</name>
                              <description>ERROR</description>
                          </query_status_type>
                      </query_result_instance>
                      <query_result_instance>
                          <result_instance_id>153</result_instance_id>
                          <query_instance_id>43</query_instance_id>
                          <query_result_type>
                              <result_type_id>11</result_type_id>
                              <name>PATIENT_TOP20MEDS_XML</name>
                              <display_type>CATNUM</display_type>
                              <visual_attribute_type>LA</visual_attribute_type>
                              <description>Top 20 medications breakdown</description>
                              <user_role_cd>DATA_LDS</user_role_cd>
                          </query_result_type>
                          <set_size>-1</set_size>
                          <obfuscate_method/>
                          <start_date>2018-12-06T10:33:05.457-05:00</start_date>
                          <end_date>2018-12-06T10:33:05.927-05:00</end_date>
                          <message/>
                          <query_status_type>
                              <status_type_id>4</status_type_id>
                              <name>ERROR</name>
                              <description>ERROR</description>
                          </query_status_type>
                      </query_result_instance>
                      <query_result_instance>
                          <result_instance_id>154</result_instance_id>
                          <query_instance_id>43</query_instance_id>
                          <query_result_type>
                              <result_type_id>12</result_type_id>
                              <name>PATIENT_TOP20DIAG_XML</name>
                              <display_type>CATNUM</display_type>
                              <visual_attribute_type>LA</visual_attribute_type>
                              <description>Top 20 diagnoses breakdown</description>
                              <user_role_cd>DATA_LDS</user_role_cd>
                          </query_result_type>
                          <set_size>-1</set_size>
                          <obfuscate_method/>
                          <start_date>2018-12-06T10:33:05.460-05:00</start_date>
                          <end_date>2018-12-06T10:33:05.930-05:00</end_date>
                          <message/>
                          <query_status_type>
                              <status_type_id>4</status_type_id>
                              <name>ERROR</name>
                              <description>ERROR</description>
                          </query_status_type>
                      </query_result_instance>
                      <query_result_instance>
                          <result_instance_id>155</result_instance_id>
                          <query_instance_id>43</query_instance_id>
                          <query_result_type>
                              <result_type_id>13</result_type_id>
                              <name>PATIENT_INOUT_XML</name>
                              <display_type>CATNUM</display_type>
                              <visual_attribute_type>LA</visual_attribute_type>
                              <description>Inpatient and outpatient breakdown</description>
                              <user_role_cd>DATA_LDS</user_role_cd>
                          </query_result_type>
                          <set_size>-1</set_size>
                          <obfuscate_method/>
                          <start_date>2018-12-06T10:33:05.467-05:00</start_date>
                          <end_date>2018-12-06T10:33:05.930-05:00</end_date>
                          <message/>
                          <query_status_type>
                              <status_type_id>4</status_type_id>
                              <name>ERROR</name>
                              <description>ERROR</description>
                          </query_status_type>
                      </query_result_instance>
                  </ns4:response>
              </message_body>
          </ns5:response> ]
          rm302 Reeta Metta made changes -
          Attachment screenshot-1.png [ 11156 ]
          rm302 Reeta Metta made changes -
          Fix Version/s 1.7.11 [ 10703 ]
          mem61 Mike Mendis made changes -
          Resolution Fixed [ 1 ]
          Status Ready to Test [ 10001 ] Resolved [ 5 ]
          rm302 Reeta Metta made changes -
          Component/s Web Client [ 10046 ]
          Component/s Ontology Cell [ 10054 ]
          Fix Version/s 1.7.11 [ 10900 ]
          Fix Version/s 1.7.11 [ 10703 ]
          Key CORE-318 WEBCLIENT-261
          Affects Version/s 1.7.11 [ 10900 ]
          Affects Version/s 1.7.11 [ 10703 ]
          Workflow i2b2 Issues Workflow [ 11915 ] Web Client Issues Workflow [ 11964 ]
          Project i2b2 Core Software [ 10034 ] i2b2 Web Client [ 10033 ]

          People

            rm302 Reeta Metta
            rm302 Reeta Metta
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: