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

RE: OpenClinica 3.1-Alpha

Paul,

I am getting the following error in the logs after I start Tomcat, could you please help?

SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
2 change sets check sum
migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

Thanks,

Mihai
Sent: Friday, June 25, 2010 3:38 PM
To: [email protected]; [email protected]
Subject: [Developers] OpenClinica 3.1-Alpha

Hi Everyone,

The OpenClinica 3.1-alpha is ready to be downloaded. You can find the alpha at http://svn.akazaresearch.com/OpenClinica-3.1-distros/. Since OpenClinica has been modularized, there are two separate downloads. One is for the web application, and the other is for web services.

Please see http://clinicalresearch.wordpress.com/2010/06/09/openclinica-3-1-project-“amethyst”-preview/ for information on the new features of 3.1. Also, you can view the features in this alpha release here, http://clinicalresearch.wordpress.com/2010/06/16/openclinica-3-1-release-timelines-call-for-pilot-program-participants/

Please go to https://www.openclinica.org/dokuwiki/doku.php?id=developerwiki:oc31alpha, where you can find example CRFs and Rules to demonstrate the new Dynamic Logic functionality with the OpenClinica web application.

In the file that can be downloaded from the Wiki page, I’ve also included a backup of a sample database that can be restored on PostgreSQL and information about the new Rules functionality. There is one event definition in the sample study with two CRFs that utilize Dynamic Logic. You may login with the following information:

User name: root
Password: password

In the Demographics-Dynamics CRF, you can choose the Sex to see additional questions related to either Male or Female. Please see the README.txt for explicit instructions on how to experience Dynamics.

As this is an Alpha release, there will be bugs and it is NOT advisable to use this release in a production setting.

However, you may point this to a database that you have already been using for 3.0.x in a test environment and the application will automatically upgrade the database schema to 3.1. There are no SQL scripts to be run on existing 3.0.x databases in order to upgrade.

Please feel free to post questions and feedback on the features to the Users or Developers list.

Thanks, and have a great weekend.
Paul

-----------------------------------------------------------------------
Paul J. Galvin
Project Manager
Akaza Research
781-547-8425
www.openclinica.org
~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***

Comments

  • Paul GalvinPaul Galvin Posts: 886
    Hi Mihai,

    When I upgraded a 3.0.x database, I received some errors about the Quartz scheduler not finding a particular class since I had created some Jobs in the previous version of OpenClinica. This can be resolved by updating the following values in the column job_class_name of the oc_qrtz_job_details table.

    org.akaza.openclinica.service.job.ExampleStatefulJob should be changed to org.akaza.openclinica.web.job.ExampleStatefulJob

    org.akaza.openclinica.service.job.ImportStatefulJob should be changed to org.akaza.openclinica.web.job.ImportStatefulJob


    When we have the beta and production releases, this manual step will not need to be taken as the system will update the values automatically.

    I do not receive any errors about Liquibase. Are you upgrading from 2.5.x to the Alpha before going to 3.0.x?

    Thanks,
    Paul
    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Monday, June 28, 2010 1:28 PM
    To: [email protected]
    Subject: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am getting the following error in the logs after I start Tomcat, could you please help?

    SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    Thanks,

    Mihai
    Sent: Friday, June 25, 2010 3:38 PM
    To: [email protected]; [email protected]
    Subject: [Developers] OpenClinica 3.1-Alpha

    Hi Everyone,

    The OpenClinica 3.1-alpha is ready to be downloaded. You can find the alpha at http://svn.akazaresearch.com/OpenClinica-3.1-distros/. Since OpenClinica has been modularized, there are two separate downloads. One is for the web application, and the other is for web services.

    Please see http://clinicalresearch.wordpress.com/2010/06/09/openclinica-3-1-project-“amethyst”-preview/ for information on the new features of 3.1. Also, you can view the features in this alpha release here, http://clinicalresearch.wordpress.com/2010/06/16/openclinica-3-1-release-timelines-call-for-pilot-program-participants/

    Please go to https://www.openclinica.org/dokuwiki/doku.php?id=developerwiki:oc31alpha, where you can find example CRFs and Rules to demonstrate the new Dynamic Logic functionality with the OpenClinica web application.

    In the file that can be downloaded from the Wiki page, I’ve also included a backup of a sample database that can be restored on PostgreSQL and information about the new Rules functionality. There is one event definition in the sample study with two CRFs that utilize Dynamic Logic. You may login with the following information:

    User name: root
    Password: password

    In the Demographics-Dynamics CRF, you can choose the Sex to see additional questions related to either Male or Female. Please see the README.txt for explicit instructions on how to experience Dynamics.

    As this is an Alpha release, there will be bugs and it is NOT advisable to use this release in a production setting.

    However, you may point this to a database that you have already been using for 3.0.x in a test environment and the application will automatically upgrade the database schema to 3.1. There are no SQL scripts to be run on existing 3.0.x databases in order to upgrade.

    Please feel free to post questions and feedback on the features to the Users or Developers list.

    Thanks, and have a great weekend.
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
  • mvirtosumvirtosu Posts: 276 ✭✭
    Paul,

    I am sorry I neglected to mention that I did not upgrade. I started a new database from the backup provided in the wiki and a new Tomcat web app.

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 7:52 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    When I upgraded a 3.0.x database, I received some errors about the Quartz scheduler not finding a particular class since I had created some Jobs in the previous version of OpenClinica. This can be resolved by updating the following values in the column job_class_name of the oc_qrtz_job_details table.

    org.akaza.openclinica.service.job.ExampleStatefulJob should be changed to org.akaza.openclinica.web.job.ExampleStatefulJob

    org.akaza.openclinica.service.job.ImportStatefulJob should be changed to org.akaza.openclinica.web.job.ImportStatefulJob


    When we have the beta and production releases, this manual step will not need to be taken as the system will update the values automatically.

    I do not receive any errors about Liquibase. Are you upgrading from 2.5.x to the Alpha before going to 3.0.x?

    Thanks,
    Paul
    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Monday, June 28, 2010 1:28 PM
    To: [email protected]
    Subject: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am getting the following error in the logs after I start Tomcat, could you please help?

    SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    Thanks,

    Mihai
    Sent: Friday, June 25, 2010 3:38 PM
    To: [email protected]; [email protected]
    Subject: [Developers] OpenClinica 3.1-Alpha

    Hi Everyone,

    The OpenClinica 3.1-alpha is ready to be downloaded. You can find the alpha at http://svn.akazaresearch.com/OpenClinica-3.1-distros/. Since OpenClinica has been modularized, there are two separate downloads. One is for the web application, and the other is for web services.

    Please see http://clinicalresearch.wordpress.com/2010/06/09/openclinica-3-1-project-“amethyst”-preview/ for information on the new features of 3.1. Also, you can view the features in this alpha release here, http://clinicalresearch.wordpress.com/2010/06/16/openclinica-3-1-release-timelines-call-for-pilot-program-participants/

    Please go to https://www.openclinica.org/dokuwiki/doku.php?id=developerwiki:oc31alpha, where you can find example CRFs and Rules to demonstrate the new Dynamic Logic functionality with the OpenClinica web application.

    In the file that can be downloaded from the Wiki page, I’ve also included a backup of a sample database that can be restored on PostgreSQL and information about the new Rules functionality. There is one event definition in the sample study with two CRFs that utilize Dynamic Logic. You may login with the following information:

    User name: root
    Password: password

    In the Demographics-Dynamics CRF, you can choose the Sex to see additional questions related to either Male or Female. Please see the README.txt for explicit instructions on how to experience Dynamics.

    As this is an Alpha release, there will be bugs and it is NOT advisable to use this release in a production setting.

    However, you may point this to a database that you have already been using for 3.0.x in a test environment and the application will automatically upgrade the database schema to 3.1. There are no SQL scripts to be run on existing 3.0.x databases in order to upgrade.

    Please feel free to post questions and feedback on the features to the Users or Developers list.

    Thanks, and have a great weekend.
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
  • Paul GalvinPaul Galvin Posts: 886
    Hi Mihai,

    I just restored the backup from the wiki on a blank database and the 3.1-alpha started with no problems. I would recommend dropping the database and stopping Tomcat before you create the new one and restore it using the backup file from the wiki. The only thing I can think of is the application had already created the tables in your database before you tried to perform the restore and before you restarted Tomcat.

    Also, make sure no other OpenClinica instances are pointing to the same database.

    Thanks,
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Tuesday, June 29, 2010 10:33 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am sorry I neglected to mention that I did not upgrade. I started a new database from the backup provided in the wiki and a new Tomcat web app.

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 7:52 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    When I upgraded a 3.0.x database, I received some errors about the Quartz scheduler not finding a particular class since I had created some Jobs in the previous version of OpenClinica. This can be resolved by updating the following values in the column job_class_name of the oc_qrtz_job_details table.

    org.akaza.openclinica.service.job.ExampleStatefulJob should be changed to org.akaza.openclinica.web.job.ExampleStatefulJob

    org.akaza.openclinica.service.job.ImportStatefulJob should be changed to org.akaza.openclinica.web.job.ImportStatefulJob


    When we have the beta and production releases, this manual step will not need to be taken as the system will update the values automatically.

    I do not receive any errors about Liquibase. Are you upgrading from 2.5.x to the Alpha before going to 3.0.x?

    Thanks,
    Paul
    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Monday, June 28, 2010 1:28 PM
    To: [email protected]
    Subject: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am getting the following error in the logs after I start Tomcat, could you please help?

    SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    Thanks,

    Mihai
    Sent: Friday, June 25, 2010 3:38 PM
    To: [email protected]; [email protected]
    Subject: [Developers] OpenClinica 3.1-Alpha

    Hi Everyone,

    The OpenClinica 3.1-alpha is ready to be downloaded. You can find the alpha at http://svn.akazaresearch.com/OpenClinica-3.1-distros/. Since OpenClinica has been modularized, there are two separate downloads. One is for the web application, and the other is for web services.

    Please see http://clinicalresearch.wordpress.com/2010/06/09/openclinica-3-1-project-“amethyst”-preview/ for information on the new features of 3.1. Also, you can view the features in this alpha release here, http://clinicalresearch.wordpress.com/2010/06/16/openclinica-3-1-release-timelines-call-for-pilot-program-participants/

    Please go to https://www.openclinica.org/dokuwiki/doku.php?id=developerwiki:oc31alpha, where you can find example CRFs and Rules to demonstrate the new Dynamic Logic functionality with the OpenClinica web application.

    In the file that can be downloaded from the Wiki page, I’ve also included a backup of a sample database that can be restored on PostgreSQL and information about the new Rules functionality. There is one event definition in the sample study with two CRFs that utilize Dynamic Logic. You may login with the following information:

    User name: root
    Password: password

    In the Demographics-Dynamics CRF, you can choose the Sex to see additional questions related to either Male or Female. Please see the README.txt for explicit instructions on how to experience Dynamics.

    As this is an Alpha release, there will be bugs and it is NOT advisable to use this release in a production setting.

    However, you may point this to a database that you have already been using for 3.0.x in a test environment and the application will automatically upgrade the database schema to 3.1. There are no SQL scripts to be run on existing 3.0.x databases in order to upgrade.

    Please feel free to post questions and feedback on the features to the Users or Developers list.

    Thanks, and have a great weekend.
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
  • mvirtosumvirtosu Posts: 276 ✭✭
    Hi Paul,

    Thank you for your response.

    I have deleted my previously created Postgres database, stopped Tomcat, created a new blank database, restored the backup provided in the wiki, re-started Tomcat, however I still get the same error about the check sum:

    Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    I am trying this on Windows Server 2003 with Postgres 8.4 and Tomcat 6.0.

    I should also say that I am only attempting to install the web portion without the web services yet. I hope this is not a problem.

    Do you have any other ideas?

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 8:43 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    I just restored the backup from the wiki on a blank database and the 3.1-alpha started with no problems. I would recommend dropping the database and stopping Tomcat before you create the new one and restore it using the backup file from the wiki. The only thing I can think of is the application had already created the tables in your database before you tried to perform the restore and before you restarted Tomcat.

    Also, make sure no other OpenClinica instances are pointing to the same database.

    Thanks,
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Tuesday, June 29, 2010 10:33 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am sorry I neglected to mention that I did not upgrade. I started a new database from the backup provided in the wiki and a new Tomcat web app.

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 7:52 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    When I upgraded a 3.0.x database, I received some errors about the Quartz scheduler not finding a particular class since I had created some Jobs in the previous version of OpenClinica. This can be resolved by updating the following values in the column job_class_name of the oc_qrtz_job_details table.

    org.akaza.openclinica.service.job.ExampleStatefulJob should be changed to org.akaza.openclinica.web.job.ExampleStatefulJob

    org.akaza.openclinica.service.job.ImportStatefulJob should be changed to org.akaza.openclinica.web.job.ImportStatefulJob


    When we have the beta and production releases, this manual step will not need to be taken as the system will update the values automatically.

    I do not receive any errors about Liquibase. Are you upgrading from 2.5.x to the Alpha before going to 3.0.x?

    Thanks,
    Paul
    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Monday, June 28, 2010 1:28 PM
    To: [email protected]
    Subject: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am getting the following error in the logs after I start Tomcat, could you please help?

    SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    Thanks,

    Mihai
    Sent: Friday, June 25, 2010 3:38 PM
    To: [email protected]; [email protected]
    Subject: [Developers] OpenClinica 3.1-Alpha

    Hi Everyone,

    The OpenClinica 3.1-alpha is ready to be downloaded. You can find the alpha at http://svn.akazaresearch.com/OpenClinica-3.1-distros/. Since OpenClinica has been modularized, there are two separate downloads. One is for the web application, and the other is for web services.

    Please see http://clinicalresearch.wordpress.com/2010/06/09/openclinica-3-1-project-“amethyst”-preview/ for information on the new features of 3.1. Also, you can view the features in this alpha release here, http://clinicalresearch.wordpress.com/2010/06/16/openclinica-3-1-release-timelines-call-for-pilot-program-participants/

    Please go to https://www.openclinica.org/dokuwiki/doku.php?id=developerwiki:oc31alpha, where you can find example CRFs and Rules to demonstrate the new Dynamic Logic functionality with the OpenClinica web application.

    In the file that can be downloaded from the Wiki page, I’ve also included a backup of a sample database that can be restored on PostgreSQL and information about the new Rules functionality. There is one event definition in the sample study with two CRFs that utilize Dynamic Logic. You may login with the following information:

    User name: root
    Password: password

    In the Demographics-Dynamics CRF, you can choose the Sex to see additional questions related to either Male or Female. Please see the README.txt for explicit instructions on how to experience Dynamics.

    As this is an Alpha release, there will be bugs and it is NOT advisable to use this release in a production setting.

    However, you may point this to a database that you have already been using for 3.0.x in a test environment and the application will automatically upgrade the database schema to 3.1. There are no SQL scripts to be run on existing 3.0.x databases in order to upgrade.

    Please feel free to post questions and feedback on the features to the Users or Developers list.

    Thanks, and have a great weekend.
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
  • kristiakkristiak Posts: 1,334 ✭✭✭
    Hi Paul and Mihai,

    I have noticed similar problems and will try to follow these instructions. I’m really confused when and how WEB-services should be installed. The instructions seem to point to 3.0 and not 3.1!? But maybe I missed something!?

    Regards

    Krister
    Sent: 29 June 2010 17:14
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Paul,

    Thank you for your response.

    I have deleted my previously created Postgres database, stopped Tomcat, created a new blank database, restored the backup provided in the wiki, re-started Tomcat, however I still get the same error about the check sum:

    Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    I am trying this on Windows Server 2003 with Postgres 8.4 and Tomcat 6.0.

    I should also say that I am only attempting to install the web portion without the web services yet. I hope this is not a problem.

    Do you have any other ideas?

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 8:43 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    I just restored the backup from the wiki on a blank database and the 3.1-alpha started with no problems. I would recommend dropping the database and stopping Tomcat before you create the new one and restore it using the backup file from the wiki. The only thing I can think of is the application had already created the tables in your database before you tried to perform the restore and before you restarted Tomcat.

    Also, make sure no other OpenClinica instances are pointing to the same database.

    Thanks,
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Tuesday, June 29, 2010 10:33 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am sorry I neglected to mention that I did not upgrade. I started a new database from the backup provided in the wiki and a new Tomcat web app.

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 7:52 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    When I upgraded a 3.0.x database, I received some errors about the Quartz scheduler not finding a particular class since I had created some Jobs in the previous version of OpenClinica. This can be resolved by updating the following values in the column job_class_name of the oc_qrtz_job_details table.

    org.akaza.openclinica.service.job.ExampleStatefulJob should be changed to org.akaza.openclinica.web.job.ExampleStatefulJob

    org.akaza.openclinica.service.job.ImportStatefulJob should be changed to org.akaza.openclinica.web.job.ImportStatefulJob


    When we have the beta and production releases, this manual step will not need to be taken as the system will update the values automatically.

    I do not receive any errors about Liquibase. Are you upgrading from 2.5.x to the Alpha before going to 3.0.x?

    Thanks,
    Paul
    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Monday, June 28, 2010 1:28 PM
    To: [email protected]
    Subject: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am getting the following error in the logs after I start Tomcat, could you please help?

    SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    Thanks,

    Mihai
    Sent: Friday, June 25, 2010 3:38 PM
    To: [email protected]; [email protected]
    Subject: [Developers] OpenClinica 3.1-Alpha

    Hi Everyone,

    The OpenClinica 3.1-alpha is ready to be downloaded. You can find the alpha at http://svn.akazaresearch.com/OpenClinica-3.1-distros/. Since OpenClinica has been modularized, there are two separate downloads. One is for the web application, and the other is for web services.

    Please see http://clinicalresearch.wordpress.com/2010/06/09/openclinica-3-1-project-“amethyst”-preview/ for information on the new features of 3.1. Also, you can view the features in this alpha release here, http://clinicalresearch.wordpress.com/2010/06/16/openclinica-3-1-release-timelines-call-for-pilot-program-participants/

    Please go to https://www.openclinica.org/dokuwiki/doku.php?id=developerwiki:oc31alpha, where you can find example CRFs and Rules to demonstrate the new Dynamic Logic functionality with the OpenClinica web application.

    In the file that can be downloaded from the Wiki page, I’ve also included a backup of a sample database that can be restored on PostgreSQL and information about the new Rules functionality. There is one event definition in the sample study with two CRFs that utilize Dynamic Logic. You may login with the following information:

    User name: root
    Password: password

    In the Demographics-Dynamics CRF, you can choose the Sex to see additional questions related to either Male or Female. Please see the README.txt for explicit instructions on how to experience Dynamics.

    As this is an Alpha release, there will be bugs and it is NOT advisable to use this release in a production setting.

    However, you may point this to a database that you have already been using for 3.0.x in a test environment and the application will automatically upgrade the database schema to 3.1. There are no SQL scripts to be run on existing 3.0.x databases in order to upgrade.

    Please feel free to post questions and feedback on the features to the Users or Developers list.

    Thanks, and have a great weekend.
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
  • Paul GalvinPaul Galvin Posts: 886
    Hi Mihai and Krister,

    You do not have to install the web services in order to use the web application. They are two separate entities now. The installation instructions were updated for OpenClinica-web not OpenClinica-ws since they are not the same thing.

    Mihai,

    I am using the same stack as you, Windows Server 2003, Java 6, Tomcat 6 and Postgres 8.4 so I don’t know what the troubles could be. Your errors are pointing to something that was used to migrate a 2.5 database to 3.0.x rather than something to do with 3.1-alpha in particular. Do you have any other OpenClinica instances running on this server that could be pointing to the same database?

    Krister,

    Did your 3.1-alpha instance of the web application work with the backup file, or did you have trouble too? Or, was the trouble in deploying the web services for OpenClinica?

    Thanks,
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Wednesday, June 30, 2010 3:40 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Paul and Mihai,

    I have noticed similar problems and will try to follow these instructions. I’m really confused when and how WEB-services should be installed. The instructions seem to point to 3.0 and not 3.1!? But maybe I missed something!?

    Regards

    Krister
    Sent: 29 June 2010 17:14
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Paul,

    Thank you for your response.

    I have deleted my previously created Postgres database, stopped Tomcat, created a new blank database, restored the backup provided in the wiki, re-started Tomcat, however I still get the same error about the check sum:

    Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    I am trying this on Windows Server 2003 with Postgres 8.4 and Tomcat 6.0.

    I should also say that I am only attempting to install the web portion without the web services yet. I hope this is not a problem.

    Do you have any other ideas?

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 8:43 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    I just restored the backup from the wiki on a blank database and the 3.1-alpha started with no problems. I would recommend dropping the database and stopping Tomcat before you create the new one and restore it using the backup file from the wiki. The only thing I can think of is the application had already created the tables in your database before you tried to perform the restore and before you restarted Tomcat.

    Also, make sure no other OpenClinica instances are pointing to the same database.

    Thanks,
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Tuesday, June 29, 2010 10:33 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am sorry I neglected to mention that I did not upgrade. I started a new database from the backup provided in the wiki and a new Tomcat web app.

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 7:52 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    When I upgraded a 3.0.x database, I received some errors about the Quartz scheduler not finding a particular class since I had created some Jobs in the previous version of OpenClinica. This can be resolved by updating the following values in the column job_class_name of the oc_qrtz_job_details table.

    org.akaza.openclinica.service.job.ExampleStatefulJob should be changed to org.akaza.openclinica.web.job.ExampleStatefulJob

    org.akaza.openclinica.service.job.ImportStatefulJob should be changed to org.akaza.openclinica.web.job.ImportStatefulJob


    When we have the beta and production releases, this manual step will not need to be taken as the system will update the values automatically.

    I do not receive any errors about Liquibase. Are you upgrading from 2.5.x to the Alpha before going to 3.0.x?

    Thanks,
    Paul
    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Monday, June 28, 2010 1:28 PM
    To: [email protected]
    Subject: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am getting the following error in the logs after I start Tomcat, could you please help?

    SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    Thanks,

    Mihai
    Sent: Friday, June 25, 2010 3:38 PM
    To: [email protected]; [email protected]
    Subject: [Developers] OpenClinica 3.1-Alpha

    Hi Everyone,

    The OpenClinica 3.1-alpha is ready to be downloaded. You can find the alpha at http://svn.akazaresearch.com/OpenClinica-3.1-distros/. Since OpenClinica has been modularized, there are two separate downloads. One is for the web application, and the other is for web services.

    Please see http://clinicalresearch.wordpress.com/2010/06/09/openclinica-3-1-project-“amethyst”-preview/ for information on the new features of 3.1. Also, you can view the features in this alpha release here, http://clinicalresearch.wordpress.com/2010/06/16/openclinica-3-1-release-timelines-call-for-pilot-program-participants/

    Please go to https://www.openclinica.org/dokuwiki/doku.php?id=developerwiki:oc31alpha, where you can find example CRFs and Rules to demonstrate the new Dynamic Logic functionality with the OpenClinica web application.

    In the file that can be downloaded from the Wiki page, I’ve also included a backup of a sample database that can be restored on PostgreSQL and information about the new Rules functionality. There is one event definition in the sample study with two CRFs that utilize Dynamic Logic. You may login with the following information:

    User name: root
    Password: password

    In the Demographics-Dynamics CRF, you can choose the Sex to see additional questions related to either Male or Female. Please see the README.txt for explicit instructions on how to experience Dynamics.

    As this is an Alpha release, there will be bugs and it is NOT advisable to use this release in a production setting.

    However, you may point this to a database that you have already been using for 3.0.x in a test environment and the application will automatically upgrade the database schema to 3.1. There are no SQL scripts to be run on existing 3.0.x databases in order to upgrade.

    Please feel free to post questions and feedback on the features to the Users or Developers list.

    Thanks, and have a great weekend.
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
  • kristiakkristiak Posts: 1,334 ✭✭✭
    Hi Paul,

    I have so far only tested the application on a blank database. I used the dynamic form and build a small study on it. I must have done something wrong, though. The form came up fine and the study as usual but during data entry I could not se any of the fields that were supposed to be dynamic based on gender.

    I will now set up a new blank database and restore your dynamic demo to it. So far I liked what I observed. I testing on a VAIO Laptop running WIN 7 64 bit version.

    Regards

    Krister
    Sent: 30 June 2010 16:26
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai and Krister,

    You do not have to install the web services in order to use the web application. They are two separate entities now. The installation instructions were updated for OpenClinica-web not OpenClinica-ws since they are not the same thing.

    Mihai,

    I am using the same stack as you, Windows Server 2003, Java 6, Tomcat 6 and Postgres 8.4 so I don’t know what the troubles could be. Your errors are pointing to something that was used to migrate a 2.5 database to 3.0.x rather than something to do with 3.1-alpha in particular. Do you have any other OpenClinica instances running on this server that could be pointing to the same database?

    Krister,

    Did your 3.1-alpha instance of the web application work with the backup file, or did you have trouble too? Or, was the trouble in deploying the web services for OpenClinica?

    Thanks,
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Wednesday, June 30, 2010 3:40 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Paul and Mihai,

    I have noticed similar problems and will try to follow these instructions. I’m really confused when and how WEB-services should be installed. The instructions seem to point to 3.0 and not 3.1!? But maybe I missed something!?

    Regards

    Krister
    Sent: 29 June 2010 17:14
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Paul,

    Thank you for your response.

    I have deleted my previously created Postgres database, stopped Tomcat, created a new blank database, restored the backup provided in the wiki, re-started Tomcat, however I still get the same error about the check sum:

    Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    I am trying this on Windows Server 2003 with Postgres 8.4 and Tomcat 6.0.

    I should also say that I am only attempting to install the web portion without the web services yet. I hope this is not a problem.

    Do you have any other ideas?

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 8:43 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    I just restored the backup from the wiki on a blank database and the 3.1-alpha started with no problems. I would recommend dropping the database and stopping Tomcat before you create the new one and restore it using the backup file from the wiki. The only thing I can think of is the application had already created the tables in your database before you tried to perform the restore and before you restarted Tomcat.

    Also, make sure no other OpenClinica instances are pointing to the same database.

    Thanks,
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Tuesday, June 29, 2010 10:33 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am sorry I neglected to mention that I did not upgrade. I started a new database from the backup provided in the wiki and a new Tomcat web app.

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 7:52 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    When I upgraded a 3.0.x database, I received some errors about the Quartz scheduler not finding a particular class since I had created some Jobs in the previous version of OpenClinica. This can be resolved by updating the following values in the column job_class_name of the oc_qrtz_job_details table.

    org.akaza.openclinica.service.job.ExampleStatefulJob should be changed to org.akaza.openclinica.web.job.ExampleStatefulJob

    org.akaza.openclinica.service.job.ImportStatefulJob should be changed to org.akaza.openclinica.web.job.ImportStatefulJob


    When we have the beta and production releases, this manual step will not need to be taken as the system will update the values automatically.

    I do not receive any errors about Liquibase. Are you upgrading from 2.5.x to the Alpha before going to 3.0.x?

    Thanks,
    Paul
    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Monday, June 28, 2010 1:28 PM
    To: [email protected]
    Subject: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am getting the following error in the logs after I start Tomcat, could you please help?

    SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    Thanks,

    Mihai
    Sent: Friday, June 25, 2010 3:38 PM
    To: [email protected]; [email protected]
    Subject: [Developers] OpenClinica 3.1-Alpha

    Hi Everyone,

    The OpenClinica 3.1-alpha is ready to be downloaded. You can find the alpha at http://svn.akazaresearch.com/OpenClinica-3.1-distros/. Since OpenClinica has been modularized, there are two separate downloads. One is for the web application, and the other is for web services.

    Please see http://clinicalresearch.wordpress.com/2010/06/09/openclinica-3-1-project-“amethyst”-preview/ for information on the new features of 3.1. Also, you can view the features in this alpha release here, http://clinicalresearch.wordpress.com/2010/06/16/openclinica-3-1-release-timelines-call-for-pilot-program-participants/

    Please go to https://www.openclinica.org/dokuwiki/doku.php?id=developerwiki:oc31alpha, where you can find example CRFs and Rules to demonstrate the new Dynamic Logic functionality with the OpenClinica web application.

    In the file that can be downloaded from the Wiki page, I’ve also included a backup of a sample database that can be restored on PostgreSQL and information about the new Rules functionality. There is one event definition in the sample study with two CRFs that utilize Dynamic Logic. You may login with the following information:

    User name: root
    Password: password

    In the Demographics-Dynamics CRF, you can choose the Sex to see additional questions related to either Male or Female. Please see the README.txt for explicit instructions on how to experience Dynamics.

    As this is an Alpha release, there will be bugs and it is NOT advisable to use this release in a production setting.

    However, you may point this to a database that you have already been using for 3.0.x in a test environment and the application will automatically upgrade the database schema to 3.1. There are no SQL scripts to be run on existing 3.0.x databases in order to upgrade.

    Please feel free to post questions and feedback on the features to the Users or Developers list.

    Thanks, and have a great weekend.
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
  • mvirtosumvirtosu Posts: 276 ✭✭
    Paul,

    I do have other OpenClinica instances on that server, but I have double checked that none other points to the 3.1 alpha database. I will defer this to Su, our Java/Tomcat specialist, when he gets back.

    Krister,

    You said you were going to use the provided database backup. Have you been able to set up OC with that database successfully?

    Thanks Paul for your help.

    Mihai
    Sent: Wednesday, June 30, 2010 8:45 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Paul,

    I have so far only tested the application on a blank database. I used the dynamic form and build a small study on it. I must have done something wrong, though. The form came up fine and the study as usual but during data entry I could not se any of the fields that were supposed to be dynamic based on gender.

    I will now set up a new blank database and restore your dynamic demo to it. So far I liked what I observed. I testing on a VAIO Laptop running WIN 7 64 bit version.

    Regards

    Krister
    Sent: 30 June 2010 16:26
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai and Krister,

    You do not have to install the web services in order to use the web application. They are two separate entities now. The installation instructions were updated for OpenClinica-web not OpenClinica-ws since they are not the same thing.

    Mihai,

    I am using the same stack as you, Windows Server 2003, Java 6, Tomcat 6 and Postgres 8.4 so I don’t know what the troubles could be. Your errors are pointing to something that was used to migrate a 2.5 database to 3.0.x rather than something to do with 3.1-alpha in particular. Do you have any other OpenClinica instances running on this server that could be pointing to the same database?

    Krister,

    Did your 3.1-alpha instance of the web application work with the backup file, or did you have trouble too? Or, was the trouble in deploying the web services for OpenClinica?

    Thanks,
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Wednesday, June 30, 2010 3:40 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Paul and Mihai,

    I have noticed similar problems and will try to follow these instructions. I’m really confused when and how WEB-services should be installed. The instructions seem to point to 3.0 and not 3.1!? But maybe I missed something!?

    Regards

    Krister
    Sent: 29 June 2010 17:14
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Paul,

    Thank you for your response.

    I have deleted my previously created Postgres database, stopped Tomcat, created a new blank database, restored the backup provided in the wiki, re-started Tomcat, however I still get the same error about the check sum:

    Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    I am trying this on Windows Server 2003 with Postgres 8.4 and Tomcat 6.0.

    I should also say that I am only attempting to install the web portion without the web services yet. I hope this is not a problem.

    Do you have any other ideas?

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 8:43 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    I just restored the backup from the wiki on a blank database and the 3.1-alpha started with no problems. I would recommend dropping the database and stopping Tomcat before you create the new one and restore it using the backup file from the wiki. The only thing I can think of is the application had already created the tables in your database before you tried to perform the restore and before you restarted Tomcat.

    Also, make sure no other OpenClinica instances are pointing to the same database.

    Thanks,
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Tuesday, June 29, 2010 10:33 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am sorry I neglected to mention that I did not upgrade. I started a new database from the backup provided in the wiki and a new Tomcat web app.

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 7:52 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    When I upgraded a 3.0.x database, I received some errors about the Quartz scheduler not finding a particular class since I had created some Jobs in the previous version of OpenClinica. This can be resolved by updating the following values in the column job_class_name of the oc_qrtz_job_details table.

    org.akaza.openclinica.service.job.ExampleStatefulJob should be changed to org.akaza.openclinica.web.job.ExampleStatefulJob

    org.akaza.openclinica.service.job.ImportStatefulJob should be changed to org.akaza.openclinica.web.job.ImportStatefulJob


    When we have the beta and production releases, this manual step will not need to be taken as the system will update the values automatically.

    I do not receive any errors about Liquibase. Are you upgrading from 2.5.x to the Alpha before going to 3.0.x?

    Thanks,
    Paul
    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Monday, June 28, 2010 1:28 PM
    To: [email protected]
    Subject: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am getting the following error in the logs after I start Tomcat, could you please help?

    SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    Thanks,

    Mihai
    Sent: Friday, June 25, 2010 3:38 PM
    To: [email protected]; [email protected]
    Subject: [Developers] OpenClinica 3.1-Alpha

    Hi Everyone,

    The OpenClinica 3.1-alpha is ready to be downloaded. You can find the alpha at http://svn.akazaresearch.com/OpenClinica-3.1-distros/. Since OpenClinica has been modularized, there are two separate downloads. One is for the web application, and the other is for web services.

    Please see http://clinicalresearch.wordpress.com/2010/06/09/openclinica-3-1-project-“amethyst”-preview/ for information on the new features of 3.1. Also, you can view the features in this alpha release here, http://clinicalresearch.wordpress.com/2010/06/16/openclinica-3-1-release-timelines-call-for-pilot-program-participants/

    Please go to https://www.openclinica.org/dokuwiki/doku.php?id=developerwiki:oc31alpha, where you can find example CRFs and Rules to demonstrate the new Dynamic Logic functionality with the OpenClinica web application.

    In the file that can be downloaded from the Wiki page, I’ve also included a backup of a sample database that can be restored on PostgreSQL and information about the new Rules functionality. There is one event definition in the sample study with two CRFs that utilize Dynamic Logic. You may login with the following information:

    User name: root
    Password: password

    In the Demographics-Dynamics CRF, you can choose the Sex to see additional questions related to either Male or Female. Please see the README.txt for explicit instructions on how to experience Dynamics.

    As this is an Alpha release, there will be bugs and it is NOT advisable to use this release in a production setting.

    However, you may point this to a database that you have already been using for 3.0.x in a test environment and the application will automatically upgrade the database schema to 3.1. There are no SQL scripts to be run on existing 3.0.x databases in order to upgrade.

    Please feel free to post questions and feedback on the features to the Users or Developers list.

    Thanks, and have a great weekend.
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
  • kristiakkristiak Posts: 1,334 ✭✭✭
    I’m just in the process of setting up the provided database from the backup. I will let you know within the hour how it goes.

    Regards

    Krister
    Sent: 30 June 2010 17:14
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I do have other OpenClinica instances on that server, but I have double checked that none other points to the 3.1 alpha database. I will defer this to Su, our Java/Tomcat specialist, when he gets back.

    Krister,

    You said you were going to use the provided database backup. Have you been able to set up OC with that database successfully?

    Thanks Paul for your help.

    Mihai
    Sent: Wednesday, June 30, 2010 8:45 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Paul,

    I have so far only tested the application on a blank database. I used the dynamic form and build a small study on it. I must have done something wrong, though. The form came up fine and the study as usual but during data entry I could not se any of the fields that were supposed to be dynamic based on gender.

    I will now set up a new blank database and restore your dynamic demo to it. So far I liked what I observed. I testing on a VAIO Laptop running WIN 7 64 bit version.

    Regards

    Krister
    Sent: 30 June 2010 16:26
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai and Krister,

    You do not have to install the web services in order to use the web application. They are two separate entities now. The installation instructions were updated for OpenClinica-web not OpenClinica-ws since they are not the same thing.

    Mihai,

    I am using the same stack as you, Windows Server 2003, Java 6, Tomcat 6 and Postgres 8.4 so I don’t know what the troubles could be. Your errors are pointing to something that was used to migrate a 2.5 database to 3.0.x rather than something to do with 3.1-alpha in particular. Do you have any other OpenClinica instances running on this server that could be pointing to the same database?

    Krister,

    Did your 3.1-alpha instance of the web application work with the backup file, or did you have trouble too? Or, was the trouble in deploying the web services for OpenClinica?

    Thanks,
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Wednesday, June 30, 2010 3:40 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Paul and Mihai,

    I have noticed similar problems and will try to follow these instructions. I’m really confused when and how WEB-services should be installed. The instructions seem to point to 3.0 and not 3.1!? But maybe I missed something!?

    Regards

    Krister
    Sent: 29 June 2010 17:14
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Paul,

    Thank you for your response.

    I have deleted my previously created Postgres database, stopped Tomcat, created a new blank database, restored the backup provided in the wiki, re-started Tomcat, however I still get the same error about the check sum:

    Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    I am trying this on Windows Server 2003 with Postgres 8.4 and Tomcat 6.0.

    I should also say that I am only attempting to install the web portion without the web services yet. I hope this is not a problem.

    Do you have any other ideas?

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 8:43 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    I just restored the backup from the wiki on a blank database and the 3.1-alpha started with no problems. I would recommend dropping the database and stopping Tomcat before you create the new one and restore it using the backup file from the wiki. The only thing I can think of is the application had already created the tables in your database before you tried to perform the restore and before you restarted Tomcat.

    Also, make sure no other OpenClinica instances are pointing to the same database.

    Thanks,
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Tuesday, June 29, 2010 10:33 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am sorry I neglected to mention that I did not upgrade. I started a new database from the backup provided in the wiki and a new Tomcat web app.

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 7:52 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    When I upgraded a 3.0.x database, I received some errors about the Quartz scheduler not finding a particular class since I had created some Jobs in the previous version of OpenClinica. This can be resolved by updating the following values in the column job_class_name of the oc_qrtz_job_details table.

    org.akaza.openclinica.service.job.ExampleStatefulJob should be changed to org.akaza.openclinica.web.job.ExampleStatefulJob

    org.akaza.openclinica.service.job.ImportStatefulJob should be changed to org.akaza.openclinica.web.job.ImportStatefulJob


    When we have the beta and production releases, this manual step will not need to be taken as the system will update the values automatically.

    I do not receive any errors about Liquibase. Are you upgrading from 2.5.x to the Alpha before going to 3.0.x?

    Thanks,
    Paul
    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Monday, June 28, 2010 1:28 PM
    To: [email protected]
    Subject: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am getting the following error in the logs after I start Tomcat, could you please help?

    SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    Thanks,

    Mihai
    Sent: Friday, June 25, 2010 3:38 PM
    To: [email protected]; [email protected]
    Subject: [Developers] OpenClinica 3.1-Alpha

    Hi Everyone,

    The OpenClinica 3.1-alpha is ready to be downloaded. You can find the alpha at http://svn.akazaresearch.com/OpenClinica-3.1-distros/. Since OpenClinica has been modularized, there are two separate downloads. One is for the web application, and the other is for web services.

    Please see http://clinicalresearch.wordpress.com/2010/06/09/openclinica-3-1-project-“amethyst”-preview/ for information on the new features of 3.1. Also, you can view the features in this alpha release here, http://clinicalresearch.wordpress.com/2010/06/16/openclinica-3-1-release-timelines-call-for-pilot-program-participants/

    Please go to https://www.openclinica.org/dokuwiki/doku.php?id=developerwiki:oc31alpha, where you can find example CRFs and Rules to demonstrate the new Dynamic Logic functionality with the OpenClinica web application.

    In the file that can be downloaded from the Wiki page, I’ve also included a backup of a sample database that can be restored on PostgreSQL and information about the new Rules functionality. There is one event definition in the sample study with two CRFs that utilize Dynamic Logic. You may login with the following information:

    User name: root
    Password: password

    In the Demographics-Dynamics CRF, you can choose the Sex to see additional questions related to either Male or Female. Please see the README.txt for explicit instructions on how to experience Dynamics.

    As this is an Alpha release, there will be bugs and it is NOT advisable to use this release in a production setting.

    However, you may point this to a database that you have already been using for 3.0.x in a test environment and the application will automatically upgrade the database schema to 3.1. There are no SQL scripts to be run on existing 3.0.x databases in order to upgrade.

    Please feel free to post questions and feedback on the features to the Users or Developers list.

    Thanks, and have a great weekend.
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
  • kristiakkristiak Posts: 1,334 ✭✭✭
    Hi Paul and Mihai,

    I have now successfully loaded the backup database and started testing, I did the loading as follows: I installed a clean database on PostgreSQL version 8.4.4-1. Used the scripts to generate the roles and database. Then I restored the provided dynamic demo database, started Tomcat, checked if OpenClinica was running. It started with no problems (except on the first login I got a blank screen. This I alsos observed when I used a blank database, i.e. I had to log on twice to get in)

    I will now start the real testing,

    I’ll keep you posted, but do not expect too much feed back until after soccer is over in South Africa. But there are mornings and late evenings.

    Regards

    Krister

    .
    Sent: 30 June 2010 17:33
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    I’m just in the process of setting up the provided database from the backup. I will let you know within the hour how it goes.

    Regards

    Krister
    Sent: 30 June 2010 17:14
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I do have other OpenClinica instances on that server, but I have double checked that none other points to the 3.1 alpha database. I will defer this to Su, our Java/Tomcat specialist, when he gets back.

    Krister,

    You said you were going to use the provided database backup. Have you been able to set up OC with that database successfully?

    Thanks Paul for your help.

    Mihai
    Sent: Wednesday, June 30, 2010 8:45 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Paul,

    I have so far only tested the application on a blank database. I used the dynamic form and build a small study on it. I must have done something wrong, though. The form came up fine and the study as usual but during data entry I could not se any of the fields that were supposed to be dynamic based on gender.

    I will now set up a new blank database and restore your dynamic demo to it. So far I liked what I observed. I testing on a VAIO Laptop running WIN 7 64 bit version.

    Regards

    Krister
    Sent: 30 June 2010 16:26
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai and Krister,

    You do not have to install the web services in order to use the web application. They are two separate entities now. The installation instructions were updated for OpenClinica-web not OpenClinica-ws since they are not the same thing.

    Mihai,

    I am using the same stack as you, Windows Server 2003, Java 6, Tomcat 6 and Postgres 8.4 so I don’t know what the troubles could be. Your errors are pointing to something that was used to migrate a 2.5 database to 3.0.x rather than something to do with 3.1-alpha in particular. Do you have any other OpenClinica instances running on this server that could be pointing to the same database?

    Krister,

    Did your 3.1-alpha instance of the web application work with the backup file, or did you have trouble too? Or, was the trouble in deploying the web services for OpenClinica?

    Thanks,
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Wednesday, June 30, 2010 3:40 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Paul and Mihai,

    I have noticed similar problems and will try to follow these instructions. I’m really confused when and how WEB-services should be installed. The instructions seem to point to 3.0 and not 3.1!? But maybe I missed something!?

    Regards

    Krister
    Sent: 29 June 2010 17:14
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Paul,

    Thank you for your response.

    I have deleted my previously created Postgres database, stopped Tomcat, created a new blank database, restored the backup provided in the wiki, re-started Tomcat, however I still get the same error about the check sum:

    Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    I am trying this on Windows Server 2003 with Postgres 8.4 and Tomcat 6.0.

    I should also say that I am only attempting to install the web portion without the web services yet. I hope this is not a problem.

    Do you have any other ideas?

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 8:43 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    I just restored the backup from the wiki on a blank database and the 3.1-alpha started with no problems. I would recommend dropping the database and stopping Tomcat before you create the new one and restore it using the backup file from the wiki. The only thing I can think of is the application had already created the tables in your database before you tried to perform the restore and before you restarted Tomcat.

    Also, make sure no other OpenClinica instances are pointing to the same database.

    Thanks,
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Tuesday, June 29, 2010 10:33 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am sorry I neglected to mention that I did not upgrade. I started a new database from the backup provided in the wiki and a new Tomcat web app.

    Thanks,

    Mihai
    Sent: Tuesday, June 29, 2010 7:52 AM
    To: [email protected]
    Subject: RE: [Developers] RE: OpenClinica 3.1-Alpha

    Hi Mihai,

    When I upgraded a 3.0.x database, I received some errors about the Quartz scheduler not finding a particular class since I had created some Jobs in the previous version of OpenClinica. This can be resolved by updating the following values in the column job_class_name of the oc_qrtz_job_details table.

    org.akaza.openclinica.service.job.ExampleStatefulJob should be changed to org.akaza.openclinica.web.job.ExampleStatefulJob

    org.akaza.openclinica.service.job.ImportStatefulJob should be changed to org.akaza.openclinica.web.job.ImportStatefulJob


    When we have the beta and production releases, this manual step will not need to be taken as the system will update the values automatically.

    I do not receive any errors about Liquibase. Are you upgrading from 2.5.x to the Alpha before going to 3.0.x?

    Thanks,
    Paul
    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
    Sent: Monday, June 28, 2010 1:28 PM
    To: [email protected]
    Subject: [Developers] RE: OpenClinica 3.1-Alpha

    Paul,

    I am getting the following error in the logs after I start Tomcat, could you please help?

    SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in file [C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\OpenClinica_3.1-alpha\WEB-INF\classes\org\akaza\openclinica\applicationContext-core-db.xml]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:
    2 change sets check sum
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-360::pgawade (generated)::(MD5Sum: f342176615859c2ea399bc1c3640bf57)
    migration/2.5/changeLogCreateFunctions.xml::1235684743487-374::pgawade (generated)::(MD5Sum: 8fdf672bcc8ce31478438925dcb4674)

    Thanks,

    Mihai
    Sent: Friday, June 25, 2010 3:38 PM
    To: [email protected]; [email protected]
    Subject: [Developers] OpenClinica 3.1-Alpha

    Hi Everyone,

    The OpenClinica 3.1-alpha is ready to be downloaded. You can find the alpha at http://svn.akazaresearch.com/OpenClinica-3.1-distros/. Since OpenClinica has been modularized, there are two separate downloads. One is for the web application, and the other is for web services.

    Please see http://clinicalresearch.wordpress.com/2010/06/09/openclinica-3-1-project-“amethyst”-preview/ for information on the new features of 3.1. Also, you can view the features in this alpha release here, http://clinicalresearch.wordpress.com/2010/06/16/openclinica-3-1-release-timelines-call-for-pilot-program-participants/

    Please go to https://www.openclinica.org/dokuwiki/doku.php?id=developerwiki:oc31alpha, where you can find example CRFs and Rules to demonstrate the new Dynamic Logic functionality with the OpenClinica web application.

    In the file that can be downloaded from the Wiki page, I’ve also included a backup of a sample database that can be restored on PostgreSQL and information about the new Rules functionality. There is one event definition in the sample study with two CRFs that utilize Dynamic Logic. You may login with the following information:

    User name: root
    Password: password

    In the Demographics-Dynamics CRF, you can choose the Sex to see additional questions related to either Male or Female. Please see the README.txt for explicit instructions on how to experience Dynamics.

    As this is an Alpha release, there will be bugs and it is NOT advisable to use this release in a production setting.

    However, you may point this to a database that you have already been using for 3.0.x in a test environment and the application will automatically upgrade the database schema to 3.1. There are no SQL scripts to be run on existing 3.0.x databases in order to upgrade.

    Please feel free to post questions and feedback on the features to the Users or Developers list.

    Thanks, and have a great weekend.
    Paul

    -----------------------------------------------------------------------
    Paul J. Galvin
    Project Manager
    Akaza Research
    781-547-8425
    www.openclinica.org
    ~ OpenClinica Enterprise ~ Ask me about professional training, support, and services for OpenClinica
    ***To search the archives of the User and Developer Forums, please go to http://www.openclinica.org/page.php?pid=107***
This discussion has been closed.