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

Openclinica database

Hi Everyone,
I have recently downloaded openclinica3.0.3 and cannot seem to find the script for creating all the database tables. The only scripts I could find were 2 that created the database, created a user/role. The script that creates the actual database with tables is not there.
I downloaded 3.0.2, 3.0.1 - neither of them had the script. I finally found a script on 2.5.10 but when I execute the script I run into an error
-----------
ERROR: relation "archived_dataset_file" already exists
-----------
Could someone please direct me to the proper database script? I searched through the documentation/forums quite exhaustively and I couldn't find any information related to the database for openclinica3.0.3.
Thank you,
Vinnie

Comments

  • haenselhaensel Posts: 602 ✭✭✭
    Hi Vinnie
    The tables are create automatically during the first startup.
    Regards,
    Christian
    Am 26.8.2010 14:20, schrieb Vin:
    > Hi Everyone,
    >
    > I have recently downloaded openclinica3.0.3 and cannot seem to find the script for creating all the database tables. The only scripts I could find were 2 that created the database, created a user/role. The script that creates the actual database with tables is not there.
    >
    > I downloaded 3.0.2, 3.0.1 - neither of them had the script. I finally found a script on 2.5.10 but when I execute the script I run into an error
    >
    > -----------
    > ERROR: relation "archived_dataset_file" already exists
    > -----------
    >
    > Could someone please direct me to the proper database script? I searched through the documentation/forums quite exhaustively and I couldn't find any information related to the database for openclinica3.0.3.
    >
    > Thank you,
    > Vinnie
    >
    >
  • JanusJanus Posts: 260
    Hi Vin,
    In 3.0.3 the database is create automatically upon first run of the OC
    webapp. No need for the old scripts anymore.
    Best regards,
    Janus

    Vin
    To
    Sent by: [email protected]
    developers-bounce cc
    [email protected]
    Subject
    [Developers] Openclinica database
    26-08-2010 14:25


    Please respond to
    [email protected]
    inica.org


    Hi Everyone,
    I have recently downloaded openclinica3.0.3 and cannot seem to find the
    script for creating all the database tables. The only scripts I could find
    were 2 that created the database, created a user/role. The script that
    creates the actual database with tables is not there.
    I downloaded 3.0.2, 3.0.1 - neither of them had the script. I finally found
    a script on 2.5.10 but when I execute the script I run into an error
    -----------
    ERROR: relation "archived_dataset_file" already exists
    -----------
    Could someone please direct me to the proper database script? I searched
    through the documentation/forums quite exhaustively and I couldn't find any
    information related to the database for openclinica3.0.3.
    Thank you,
    Vinnie
  • Thank you for all those replied.
    I have checked the database and did find the tables. But, I am getting a blank page after I login.
    What do you think the problem might be?
    Here's my environment
    OpenClinica 3.0.3
    Tomcat 7.0
    PostgreSQL 8.4
    I appreciate all your help.
    Best
    On Thu, Aug 26, 2010 at 8:42 AM, wrote:
    Hi Vin,
    In 3.0.3 the database is create automatically upon first run of the OC
    webapp. No need for the old scripts anymore.
    Best regards,
    Janus
    Vin
    To
    Sent by: [email protected]
    developers-bounce cc
    [email protected]
    Subject
    [Developers] Openclinica database
    26-08-2010 14:25
    Please respond to
    [email protected]
    inica.org
    Hi Everyone,
    I have recently downloaded openclinica3.0.3 and cannot seem to find the
    script for creating all the database tables. The only scripts I could find
    were 2 that created the database, created a user/role. The script that
    creates the actual database with tables is not there.
    I downloaded 3.0.2, 3.0.1 - neither of them had the script. I finally found
    a script on 2.5.10 but when I execute the script I run into an error
    -----------
    ERROR: relation "archived_dataset_file" already exists
    -----------
    Could someone please direct me to the proper database script? I searched
    through the documentation/forums quite exhaustively and I couldn't find any
    information related to the database for openclinica3.0.3.
    Thank you,
    Vinnie
  • Hi Vin,

    One issue may be that you're on Tomcat 7 - OpenClinica is developed and tested with Tomcat 6.

    If you follow the step-by-step instructions in the install guide, it has very specific instructions and details on software dependancies and other configurations that are necessary.

    Best,
    Alicia

    . . . . . . . . . . . . . . . . . . . . . . . . . . .
    Alicia Goodwin
    Client Services Representative
    Akaza Research, LLC
    460 Totten Pond Rd. Suite 200
    Waltham, MA 02451
    Sent: Thursday, August 26, 2010 2:57 PM
    To: [email protected]
    Subject: Re: [Developers] Openclinica database
    Thank you for all those replied.
    I have checked the database and did find the tables. But, I am getting a blank page after I login.
    What do you think the problem might be?
    Here's my environment
    OpenClinica 3.0.3
    Tomcat 7.0
    PostgreSQL 8.4
    I appreciate all your help.
    Best
    On Thu, Aug 26, 2010 at 8:42 AM, wrote:
    Hi Vin,
    In 3.0.3 the database is create automatically upon first run of the OC
    webapp. No need for the old scripts anymore.
    Best regards,
    Janus
    Vin
    To
    Sent by: [email protected]
    developers-bounce cc
    [email protected]
    Subject
    [Developers] Openclinica database
    26-08-2010 14:25
    Please respond to
    [email protected]
    inica.org
    Hi Everyone,
    I have recently downloaded openclinica3.0.3 and cannot seem to find the
    script for creating all the database tables. The only scripts I could find
    were 2 that created the database, created a user/role. The script that
    creates the actual database with tables is not there.
    I downloaded 3.0.2, 3.0.1 - neither of them had the script. I finally found
    a script on 2.5.10 but when I execute the script I run into an error
    -----------
    ERROR: relation "archived_dataset_file" already exists
    -----------
    Could someone please direct me to the proper database script? I searched
    through the documentation/forums quite exhaustively and I couldn't find any
    information related to the database for openclinica3.0.3.
    Thank you,
    Vinnie
This discussion has been closed.