Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
1.7.07
-
Linux
-
Rank:0|hzzzzg:s6
-
v1710.2
-
Patient Breakdowns
-
PostgreSQL
-
Firefox, Internet Explorer, Safari
-
Tested in the QA environment and it appears to be working correctly. Tested against Oracle, PostgreSQL and SQL Server. Verified the standard breakdowns will now run without an error.
Description
Steps to reproduce issue:
1. Log into i2b2 webclient with access to at least project.
2. Create a new query and choose one of the breakdown output options for query result type: Age patient breakdown, Vital status breakdown, Gender patient breakdown, Race patient breakdown.
3. Run the query.
Expected result: The query should run successfully, generating the breakdown results and displaying them in the UI.
Observed result: The query fails with message "ERROR:ERROR" in the UI. Server log shows the following error (see detailed log in attachment):
{code}
Aug 1 15:16:00 jbspnnm1.cbmi.wucon.wustl.edu jboss-as7[29575]: ERR 15:16:00,434 ERROR [stderr] (http--0.0.0.0-8080-43) org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [update i2b2demodata.qt_query_master set delete_flag =?,delete_date=? where query_master_id = ? and delete_flag = ?]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying
Aug 1 15:16:00 jbspnnm1.cbmi.wucon.wustl.edu jboss-as7[29575]: ERR 15:16:00,436 ERROR [stderr] (http--0.0.0.0-8080-43) Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Aug 1 15:16:00 jbspnnm1.cbmi.wucon.wustl.edu jboss-as7[29575]: ERR 15:16:00,437 ERROR [stderr] (http--0.0.0.0-8080-43) Position: 94
{code}
This looks like a type casting issue with the application code specifically affecting PostgreSQL environment.
Similar error with other operations in I2B2 have been encountered, seeWEBCLIENT-202.
1. Log into i2b2 webclient with access to at least project.
2. Create a new query and choose one of the breakdown output options for query result type: Age patient breakdown, Vital status breakdown, Gender patient breakdown, Race patient breakdown.
3. Run the query.
Expected result: The query should run successfully, generating the breakdown results and displaying them in the UI.
Observed result: The query fails with message "ERROR:ERROR" in the UI. Server log shows the following error (see detailed log in attachment):
{code}
Aug 1 15:16:00 jbspnnm1.cbmi.wucon.wustl.edu jboss-as7[29575]: ERR 15:16:00,434 ERROR [stderr] (http--0.0.0.0-8080-43) org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [update i2b2demodata.qt_query_master set delete_flag =?,delete_date=? where query_master_id = ? and delete_flag = ?]; nested exception is org.postgresql.util.PSQLException: ERROR: operator does not exist: integer = character varying
Aug 1 15:16:00 jbspnnm1.cbmi.wucon.wustl.edu jboss-as7[29575]: ERR 15:16:00,436 ERROR [stderr] (http--0.0.0.0-8080-43) Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Aug 1 15:16:00 jbspnnm1.cbmi.wucon.wustl.edu jboss-as7[29575]: ERR 15:16:00,437 ERROR [stderr] (http--0.0.0.0-8080-43) Position: 94
{code}
This looks like a type casting issue with the application code specifically affecting PostgreSQL environment.
Similar error with other operations in I2B2 have been encountered, see