Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-383

Search by Code does not respect c_protected_access in table_access

    XMLWordPrintable

Details

    • Bug
    • Status: New
    • Major
    • Resolution: Unresolved
    • 1.7.11
    • None
    • Ontology Cell
    • None
    • linux
    • Rank:
      0|s000c0:
    • PostgreSQL
    • All Web Browsers

    Description

      Search by code returns no results if c_table_cd contains a table name that does not exist, even if c_protected_access is set to 'Y'.

      Produced error: org.postgresql.util.PSQLException: ERROR: relation "i2b2metadata.i2b2_diag_act" does not exist

      Case: in i2b2metadata.schemes c_table_name='i2b2_diag_act' and c_protected_access='Y'.

      Solution: removed rows from table_access containing c_table_cd values pointing to non-existent tables.

      Attachments

        Activity

          People

            Unassigned Unassigned
            akvallejos Andrew Vallejos
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: