Developers Getting Started With i2b2
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin


Panel
borderColor#ccc
titleColorwhite
bgColor#F3F6FF
titleBGColor#D6E0FF
titleERROR MESSAGE
borderStylesolid
indent
Level3

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

Data Source Properties for the CRC Loader

Setting the location of the CRC_DB_LOOKUP table

Data Repository (CRC) Cell Install

Data Source Lookup Properties

CRC Datasource Configuration

Data Repository (CRC) Cell Install

Data Source Configuration

Setting the location of the ONT_DB_LOOKUP table

Ontology Management (ONT) Cell Install

Set Metadata Schema Name

Ontology Datasource Configuration

Ontology Management (ONT) Cell Install

Data Source Configuration

Setting the location of the WORK_DB_LOOKUP table

Workplace (WORK) Cell Install

Set Metadata Schema Name

Workplace Datasource Configuration

Workplace (WORK) Cell Install

Data Source Configuration