Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-3038

Designer is not aware of the system schema "SYSADMIN"

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • None
    • 10.0.2
    • None
    • None
    • Hide

      create a view referencing sysadmin.Usage
      Reconcile.

      Show
      create a view referencing sysadmin.Usage Reconcile.

    Description

      SELECT
      a.*, b.TablesUsed, b.isPhysical
      FROM
      (SELECT DISTINCT ((x.SchemaName || '.') || x.Name) AS FQN_Object, ((x.Uses_schemaName || '.') || x.Uses_Name) AS tablesUsed, y.isPhysical FROM SYSADMIN.Usage AS x, SYS.Schemas AS y WHERE (y.name = x.SchemaName) AND (x.schemaName NOT IN ('SYS', 'SYSADMIN')) ORDER BY ((x.SchemaName || '.') || x.Name)) AS a LEFT OUTER JOIN (SELECT DISTINCT ((x.SchemaName || '.') || x.Name) AS FQN_Object, ((x.Uses_schemaName || '.') || x.Uses_Name) AS tablesUsed, y.isPhysical FROM SYSADMIN.Usage AS x, SYS.Schemas AS y WHERE (y.Name = x.SchemaName) AND (x.schemaName NOT IN ('SYS', 'SYSADMIN')) ORDER BY ((x.SchemaName || '.') || x.Name)) AS B ON a.TablesUsed = b.FQN_Object

      Results in

      ERROR: Group does not exist: SYSADMIN.Usage AS x

      Attachments

        Activity

          People

            blafond Barry LaFond
            tljohnst@gmail.com thomas johnston (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: