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

Create Web Service fails if the model contains 2 schemas with the same tablenames underneath

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 7.5
    • 7.4
    • Import/Export
    • Workaround Exists
    • Hide

      Multiple workarounds:
      1. Generate the web service models individually instead of at the model level. This will allow you to make the output view and schemas unigue in the "create web service" wizard.
      2. In order to keep both schemas underneath the same model all the tablenames in the second schema would need to be changed. This isn't a viable solution though if the models contain numerous tables with the same name.

      Show
      Multiple workarounds: 1. Generate the web service models individually instead of at the model level. This will allow you to make the output view and schemas unigue in the "create web service" wizard. 2. In order to keep both schemas underneath the same model all the tablenames in the second schema would need to be changed. This isn't a viable solution though if the models contain numerous tables with the same name.

      In Teiid Designer, if you import a Source Model that contains 2 schemas, each schema contains tables with the same name. Right-click > Modeling > Create Web Service fails:
      "The name table_a_OutputView is the same (ignoring case) as 1 other object(s) under the same parent."

      The default names for the table Output Views should also contain the schema/folder names, i.e. schemaA_tableA_OutputView.

        1. MySQL_Books.xmi
          8 kB

              rhn-engineering-tejones Edwin Jones
              rhn-support-dsteigner Deborah Steigner (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: