Known Issue Oracle Database

Overview

The use of an Oracle Database as the database for the FMR is permitted. There is an article here about setting up the database and installing the appropriate JDBC Driver. However in all versions of FMR before version 11.19.5 there is a potential issue with using an Oracle database. Database tables are automatically created by FMR but in versions before 11.19.4 these tables may be created with particular columns too short to

The Issue

TODO

Methods to Address

Using the database tool of your choice, access the database and locate the following tables. Note they may already contain content so it is important not to lose any data. Modify the following tables

 ALTER TABLE t1 MODIFY col1 VARCHAR2(1000);
 ALTER TABLE t1 MODIFY col1 VARCHAR2(1000);
 ALTER TABLE t1 MODIFY col1 VARCHAR2(1000);
 ALTER TABLE t1 MODIFY col1 VARCHAR2(1000);