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)
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)