i2b2 Gotchas RDBMS Not Transparent

Tags: i2b2 Gotchas

See the above problem (NameNotFoundException) regarding the c_db_servertype column in table CRC_DB_LOOKUP. The implication is that this value is used somewhere to determine which RDBMS a project exists within.

The situation must be a little convoluted because the CRC_DB_LOOKUP table itself exists within a similar context, so I'm unsure of why it is there. Perhaps the system caters for having projects across a spectrum of RDBMS's (well 2: Oracle and SqlServer), so one project could be Oracle and another project SqlServer. This could have implications for going the MySql or PostgreSql route.

Error: Macro BackLinks(None) failed

'Environment' object has no attribute 'get_db_cnx'