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

live reporting sqldatamart



  • lindsay.stevenslindsay.stevens Posts: 404 ✭✭✭
    via Email
    @huamanzhu, the 20 views in DM schema is correct.

    I'm guessing the 22 refers to the example output screenshot. That is of a
    study schema, and is actually out of date so I've replaced it. Study
    schemas will have 17 matviews + 1 matview and 1 view for each item group in
    the study. So if you have 4 item groups you'll have 17 + 4 + 4 = 25 objects.

    The default_study and xxx schemas would be study schemas. Do you have
    studies with these names in OpenClinica?

    The public schema is the default schema created by postgres when a new
    database is made.

    I've added a section to the Introduction page of the wiki which describes
    in more detail what the expected output is.
  • huamanzhuhuamanzhu Posts: 51
    yes,I have two studies in openclinica,xiexie(thanks) @lindsay.stevens
  • ebsebs Posts: 137 ✭✭
    FYI, if you see "FATAL: role "oc" does not exist" in the log file try simplifying the password for the ocdm_fdw role. My original contained ^% characters which seemed to cause the issue.

    Thanks for the extension @lindsay.stevens
This discussion has been closed.