Request to change encounter_num from int to bigint

We recently changed the data type for the encounter num from int to a bigint. Now i2b2 is giving us an “Error Error“ message after selecting the Timing Query “Occurs in the same financial encounter”. I’m wondering if this is because the temp tables that i2b2 creates is assigning the encounter_num as an int.

We suspect it could be resolved by changing encounter_num to a bigint in this file in the Java code: https://github.com/i2b2/i2b2-core-server/blob/master/edu.harvard.i2b2.crc/src/server/edu/harvard/i2b2/crc/dao/setfinder/QueryExecutorHelperDao.java

Not sure how it was released/patched. But once it's ready and tested on your side, please email me (yxia2@ufl.edu) steps we need to follow to refresh our version.