---
title: Database Error
description: "**ERROR MESSAGE** ***Database Error*** # Possible Problems and Solutions: The following table is designed to assist you with troubleshooting this error. | When The Error Message Was Received | Possible Problem(s) | Possible Solution(s) | | --- | --- |…"
url: "https://i2b2.org/docs/database-error/"
updated: "2026-09-15"
category: i2b2 Installation Guide / Chapter 7. Troubleshooting Installation Errors
---

# Database Error

**ERROR MESSAGE**

***Database Error***

# Possible Problems and Solutions:

The following table is designed to assist you with troubleshooting this error.

| When The Error Message Was Received | Possible Problem(s) | Possible Solution(s) |
| --- | --- | --- |
| 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 |

# Installation Guide Resources:

The following resources address configuring the i2b2Workbench.properties file and how to access it on either a Macintosh or Windows machine.

| Resource For... | Chapter | Section |
| --- | --- | --- |
| Configuring the datasources for the CRC Loader *(CRCLoaderApplicationContext.xml and edu.harvard.i2b2.crc.loader.properties)* | [Data Repository (CRC) Cell Install](https://i2b2.org/docs/chapter-10-data-repository-crc-cell-install/) | [Data Source Properties for the CRC Loader](https://i2b2.org/docs/10-4-3-3-data-source-properties-for-the-crc-loader/) |
| Setting the location of the CRC_DB_LOOKUP table | [Data Repository (CRC) Cell Install](https://i2b2.org/docs/chapter-10-data-repository-crc-cell-install/) | [Data Source Lookup Properties](https://i2b2.org/docs/10-4-4-1-2-data-source-lookup-properties/) |
| CRC Datasource Configuration | [Data Repository (CRC) Cell Install](https://i2b2.org/docs/chapter-10-data-repository-crc-cell-install/) | [Data Source Configuration](https://i2b2.org/docs/10-4-5-data-source-configuration/) |
| Setting the location of the ONT_DB_LOOKUP table | [Ontology Management (ONT) Cell Install](https://i2b2.org/docs/chapter-9-ontology-management-ont-cell-install/) | [Set Metadata Schema Name](https://i2b2.org/docs/9-4-3-1-set-metadata-schema-name/) |
| Ontology Datasource Configuration | [Ontology Management (ONT) Cell Install](https://i2b2.org/docs/chapter-9-ontology-management-ont-cell-install/) | [Data Source Configuration](https://i2b2.org/docs/9-4-4-data-source-configuration/) |
| Setting the location of the WORK_DB_LOOKUP table | [Workplace (WORK) Cell Install](https://i2b2.org/docs/chapter-11-workplace-work-cell-install/) | [Set Metadata Schema Name](https://i2b2.org/docs/11-4-3-1-set-metadata-schema-name/) |
| Workplace Datasource Configuration | [Workplace (WORK) Cell Install](https://i2b2.org/docs/chapter-11-workplace-work-cell-install/) | [Data Source Configuration](https://i2b2.org/docs/11-4-4-data-source-configuration/) |