First off my apologies if this is a bit repetitive. I had upgraded OpenClinica to version 3.3 runing on Postgres 9.3, Tomcat 7 and JDK 1.8. I have added the postgres jdbc4 driver to the Tomcat lib directory as zwets from KCRI mentions at a forum thread available here
My issue now come when I extract data from the databases. I have set the study as a multi-site study. Whenever I extract values, some sites', say siteA's, data is totally missing. This is also not very consistent as some values for some participants as available on the extract. The mostly affected values are integer and real values. Has anyone who has performed an upgrade to either version 3.3 or 3.4 from 3.1.3 realised a simillar problem?
I cannot pick any helpful answers from my Tomcat logs, even as I have lowered the log level to INFO. An error that seems common from the logs is as shown in the attached log file. Maybe someone might be able to get get helpful info from it.
Thanks in advance for your suggestions and advice.