We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Issue with Export Data functions in Open Clinica

The 1.1 Release of OpenClinica contains an error in the conf/pg_data_warehouse.sql file. This file is used by the data warehouse utility to generate a table (test_table_three), that is used by the Export Data features inside OpenClinica. If the utility is failing, or you can see data in test_table_three but can’t see the data in Exported Datasets inside OpenClinica, you will need to change the ownership of that table.

The owner of the table should be clinica. Here are two ways to fix this:

Execute the following sql on the database: ALTER TABLE test_table_three OWNER TO clinica;
Open pgAdminIII. Open the database, and locate test_table_three. Right click on the table, and select properties. Change the owner field to clinica

You will also need to update the pg_data_warehouse.sql. I have attached the updated file. Replace your existing file with this one, so that when the table is dropped it will be recreated with the proper permissions.

Replace clinica with whatever user you use to make the database connections, as specified in your OpenClinica.xml, datainfo.properties. Note that if you use a different username, and you are using Windows you will also need to change that value in update_warehouse_jdbc.properties to get the Windows utility to work correctly)

Thanks, and let me know if you have questions,

Jaron Sampson
Akaza Research, Inc.
One Kendall Square
Bldg. 400, 4th Fl
Cambridge, MA 02139
tel: 617.621.8585 x.15
fax: 617.621.0065
cell: 505-590-7553

pg_data_warehouse.sql 1.8 KB
This discussion has been closed.