live reporting sqldatamart

124»

Comments

  • lindsay.stevenslindsay.stevens Posts: 402 ✭✭✭
    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: 50
    yes,I have two studies in openclinica,xiexie(thanks) @lindsay.stevens
  • ebsebs Posts: 112 ✭✭
    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.