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

using data warehouse function in windows

Hello,
Has anyone been able to set up the data warehouse function in a windows environment?
We followed the set up instructions in the windows manual and it isn't working. When we try to run it manually we keep getting the error: no class def found.
Are there any tips about how to get this working?
Sandra Allison

Comments

  • jaronjaron Posts: 30
    Hi. The data warehouse function is a java class that uses jdbc to populate a datamart called test_table_three. The scheduled command is:

    java -cp C:\OpenClinica\OpenClinica-1.1\conf;C:\OpenClinica\OpenClinica-1.1\conf\postgresql-8.1-405.jdbc3.jar UpdateWarehouseJDBC C:\OpenClinica\OpenClinica-1.1\conf\update_warehouse_jdbc.properties

    these file paths should all be checked for correctness:

    These are used as the classpath
    C:\OpenClinica\OpenClinica-1.1\conf;
    C:\OpenClinica\OpenClinica-1.1\conf\postgresql-8.1-405.jdbc3.jar

    This is the class that is used
    UpdateWarehouseJDBC

    This is the properties file used to find the database and login info, and the script to execute it
    C:\OpenClinica\OpenClinica-1.1\conf\update_warehouse_jdbc.properties

    If you are getting a class not defined error the classpaths are probably not pointing to the right place. Can you verify that there is a postgresql-8.1-405.jdbc3.jar in C:\OpenClinica\OpenClinica-1.1\conf, or change the classpath values to point to the right location?

    - Jaron

    >
    >Hello,
    >Has anyone been able to set up the data warehouse function in a windows
    >environment?
    >
    >We followed the set up instructions in the windows manual and it isn't
    >working. When we try to run it manually we keep getting the error: no
    >class def found.
    >
    >Are there any tips about how to get this working?
    >
    >Sandra Allison
    >
    >
    >
This discussion has been closed.