Hide Forgot
Help Desk Ticket Reference: https://c.na7.visual.force.com/apex/Case_View?id=500A0000007Ccyz Workaround: Workaround Exists Workaround Description: Multiple workarounds: 1. Generate the web service models individually (table level) instead of at the model level. This will allow you to make the output view and schemas unique in the "create web service" wizard. 2. Change all the table names in the second schema. This may not be a viable solution though if the models contain numerous tables with the same name. project_key: SOA 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.
Link: Added: This issue Cloned to SOA-3130
Workaround Description: Removed: 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. Added: Multiple workarounds: 1. Generate the web service models individually (table level) 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. Change all the table names in the second schema. This may not be a viable solution though if the models contain numerous tables with the same name.
TeiidDesigner has targeted this fix for 7.5, but not sure when that branch will get release.
Workaround Description: Removed: Multiple workarounds: 1. Generate the web service models individually (table level) 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. Change all the table names in the second schema. This may not be a viable solution though if the models contain numerous tables with the same name. Added: Multiple workarounds: 1. Generate the web service models individually (table level) instead of at the model level. This will allow you to make the output view and schemas unique in the "create web service" wizard. 2. Change all the table names in the second schema. This may not be a viable solution though if the models contain numerous tables with the same name.
Link: Added: This issue depends TEIIDDES-968
TEIIDDES-968 will allow the user to import tables with fully qualified names (including schema) which will allow the user to create web services for models that have schemas with duplicate table names.
Release Notes Text: Added: This is resolved with the changes made by TEIIDDES-968