In i2b2 1.7.12, the cell properties have been moved to the database, in a table called hive_cell_params installed as part of the Hivedata. These must be manually modified in the database by a SQL editor. Most installations require only a few changes. The most commonly modified parameters are documented below and a list of all configurable parameters is at the end of this page.

Agg Service Account Password (important!)

The AGG_SERVICE_ACCOUNT is an i2b2 user account used to run aggregate-counting queries in i2b2. These parameters should reflect the account name and password. We recommend changing the password. 

It is also possible to change this password manually:

1. Login using the AGG_SERVICE_ACCOUNT account on the webclient and in the top right select change password
2. Update the hive_cell_param on using the following, where {password} is the password from step 1

update hive_cell_params set value='{password}' where param_name_cd='edu.harvard.i2b2.crc.pm.serviceaccount.password';

3. Restart i2b2

Cell URLs

Each cell must communicate with other cells. To facilitate this, the cell URL properties allow each cell to know the URL of the other cells. Generally these do not need to be configured, because the hostname and port are automatically determined by the server and the rest of the URL is required to remain as written. If you do want to manually specify the hostname and port, change the data type to a T and append this to the text value. (Data type U is automatically resolved into a URL.)

For example,

could become

File Repository Cell Properties

13.4.3.3 Patient in Project Property

When a get request is sent to the IM cell it has the capability to verify whether or not a patient is part of the project requesting the patient data. By default the property is set to true, if you do not wish to check the project then you can set it to false.

13.4.3.4 Other EMPI Service Properties

The Identity Management (IM) Cell can be configured to work with a third party EMPI service such as OpenEMPI. To do this you will need to create the service to the other system and then update the im.properties file with the appropriate information.

Ontology Cell Properties (uncommon)

This uncommon change allows backward compatibility with i2b2 release 1.3.

Appendix: All parameters

Below is a table of all configurable cell parameters and their default values. Data Type is T for text values, and U for URL values. URL values will automatically have protocol://hostname:port/ appended to the value, which is detected by the server. (For example, http://localhost:9090/)