ORA-01722: invalid number PreparedStatementCallback error on an i2b2 install with high latency to the DB

[ch...@flatmapit.com]

Hi,

I'm getting this error in the i2b2 log when my webclient queries take longer than 30s to return:

[ERROR] org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [update rc_site.qt_query_master set delete_flag =?,delete_date=? where query_master_id = ? and delete_flag = ?]; ORA-01722: invalid number

This appears in the log after the webclient has put up the "QUERY CANCELLED" message, but some time after this the query results are available through the webclient query history.

I'm building an OpenShift deployment template for i2b2, and testing a fresh demo data install with an Oracle 11g data source. The environment I'm deploying into has a lot of network latency between the i2b2 cells and the Oracle DB. 

I wondered if this message is benign, or if it's a sign that something is not being cleaned up that will hurt me later. 

Many thanks,

Chris Gentle

[mmendis]

This is resolved in 1.7.09 and it was not a critical issue, the web client was sending a blank query_master_id to the server and the server displayed this error.  But as you can tell the query ran successfully.

-mike

[ch...@flatmapit.com]

Thank you Mike.