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

i2b2 Query Tool - Handling Concepts with Apostrophes causes ERROR

    XMLWordPrintable

Details

    • Bug
    • Status: New
    • Critical
    • Resolution: Unresolved
    • 1.7.11
    • None
    • None
    • None
    • Query Tool
    • Queries
    • SQL Server
    • All Web Browsers

    Description

      We are currently experiencing an issue with the i2b2 query tool (version 1.7). Specifically, the tool is encountering errors when processing concepts that include apostrophes. Below is the error log...

      LOG:
        Error while executing sql
      with t as (
      select f.patient_num
      from dbo.diag_icd9_fact f
      where f.concept_cd IN (
           select concept_cd
            from dbo.concept_dimension
            where concept_path LIKE '\PCORI\DIAGNOSIS\ICD-9-CM\320-389.99 DISEASES OF THE NERVOUS SYSTEM AND SENSE ORGANS\330-337.99 HEREDITARY AND DEGENERATIVE DISEASES OF THE CENTRAL NERVOUS SYSTEM\331 Other cerebral degenerations\331.0 Alzheimer's disease\%')
            group by f.patient_num )
      insert into #global_temp_table (patient_num, panel_count)
      select t.patient_num, 0 as panel_count from t

      com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 's'.
       ERROR edu.harvard.i2b2.common.exception.I2B2DAOException: Error while executing sql

      ERROR edu.harvard.i2b2.crc.dao.setfinder.QueryExecutorHelperDao.executeQuery(QueryExecutorHelperDao.java:472)

      ERROR edu.harvard.i2b2.crc.dao.setfinder.QueryExecutorDao.executeSQL(QueryExecutorDao.java:564)

       Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 's'.
       com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)

      Attachments

        Activity

          People

            Unassigned Unassigned
            twanishapresley Twanisha Presley
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: