Try these possible fixes:
User lockout information is stored in pm_project_user_params. To unlock, just execute this:
DELETE FROM pm_project_user_params WHERE user_id=[your user] AND param_name_cd='LOCKEDOUT'
Obfuscated users are automatically locked out if they ever perform the same query more than a certain number of times. This defaults to 7 and can be configured by the edu.harvard.i2b2.crc.lockout.setfinderquery.count parameter in the hive_cell_params table. To allow a user to repeat the same query after the lockout number of attempts, you must delete the previous queries from the qt_query_master table.
Check that your QT_Patient_enc_collection has less than two billion rows. If it grows too large over time, generating new encounter sets will fail. Delete unneeded encounter sets.
Example query: SELECT max(PATIENT_ENC_COLL_ID) FROM [dbo].[QT_PATIENT_ENC_COLLECTION]
You will want to enable Inter-cell SSL. See the 1.7.11 Release Notes.
If you are using SQL Server, it is possible to use Active Directory accounts for the database users (i.e., Integrated Login) in the db.properties files. To enable this, replace
<connection-url>jdbc:sqlserver:
//localhost:1433</connection-url>
with
<connection-url>jdbc:sqlserver://localhost:1433;IntegratedSecurity=true;Trusted_Connection=Yes</connection-url>
Then the password field in the <security> section will be ignored and the SQLServer integrated security will be used.
Additionally, your contribution: