Received the message in one of the following views:

• Query Tool
• Previous Queries

The CRC cell may be having a problem connecting to the i2b2 database due to one of the following reasons:

• The data in CRC_DB_LOOKUP table may be incorrect.
• The datasources may not be configured correctly in the CRC configuration files.

• In the CRC_DB_LOOKUP table, verify the correct information for your datasource is entered in the C_DB_DATASOURCE column.
• Revisit the following CRC configuration files to verify your datasources are defined correctly:
  • CRCLoaderApplicationContext.xml
  • edu.harvard.i2b2.crc.loader.properties
  • crc.properties (Data Source Lookup)
  • crc-ds.xml

Received the message in one of the following views:

• Navigation Terms
• Find Terms
• Edit Terms

The Ontology cell may be having a problem connecting to the i2b2 database due to one of the following reasons:

• The data in one of the following tables may be incorrect:
  • ONT_DB_LOOKUP
  • TABLE_ACCESS
• The datasources may not be configured correctly in the Ontology configuration files.

• In the ONT_DB_LOOKUP table, verify the correct information for your datasource is entered in the C_DB_DATASOURCE column.
• In the TABLE_ACCESS table, verify the correct information is entered in the C_TABLE_NAME and C_FULLNAME columns.
  • The C_TABLE_NAME is the name of your metadata table that contains your ontology. In i2b2demo this is I2B2.
  • The data in C_FULLNAME should match the C_FULLNAME column in the corresponding metadata table.
• Revisit the following Ontology configuration files to verify your datasources are defined correctly.
  • ontology.properties (Bootstrap METADATA schema name)
  • ont-ds.xml

Received the message in one of the following views:

• Workplace

The Workplace cell may be having a problem connecting to the i2b2 database due to one of the following reasons:

• The data in WORK_DB_LOOKUP table may be incorrect.
• The datasources may not be configured correctly in the Workplace configuration files.

• In the WORK_DB_LOOKUP table, verify the correct information for your datasource is entered in the C_DB_DATASOURCE column.
• Revisit the following Workplace configuration files to verify your datasources are defined correctly.
  • workplace.properties (METADATA schema name)
  • work-ds.xml