Matej Kralik created TEIIDDES-3175: -------------------------------------- Summary: MED for JDG7 set wrong NAMESPACE and properties prefix Key: TEIIDDES-3175 URL: https://issues.jboss.org/browse/TEIIDDES-3175 Project: Teiid Designer Issue Type: Bug Affects Versions: 11.1.1 Reporter: Matej Kralik Priority: Critical For workaround in this issue [TEIIDDES-3174|https://issues.jboss.org/browse/TEIIDDES-3174] I manually set MED (infinispan-hotrod) for JDG7 source model. When I create vdb as XML, xml file contains namespace _'http://www.teiid.org/translator/infinispan/2017' AS teiid_infinispan-hotrod_ but when I want to deploy it, on the server shows warning: {code:java} 13:07:54,108 WARN [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50036 VDB BookMat.1 model "BookJDGSource" metadata failed to load. Reason:TEIID60017 Invalid prefix teiid_infinispan, teiid_ is reserved for Teiid use.: org.teiid.metadata.MetadataException: TEIID60017 Invalid prefix teiid_infinispan, teiid_ is reserved for Teiid use. {code} I also noticed that name of properties are *teiid_infinispan-hotrod* but should be *teiid_ispn*. Generated model in xml vdb: {code:java} SET NAMESPACE 'http://www.teiid.org/translator/infinispan/2017' AS teiid_infinispan-hotrod CREATE FOREIGN TABLE viewBooks ( isbn string(255) NOT NULL, title string(255), publisher integer OPTIONS(FIXED_LENGTH 'TRUE'), publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'), edition integer OPTIONS(FIXED_LENGTH 'TRUE'), type string(255), CONSTRAINT pk_book PRIMARY KEY(isbn) OPTIONS(NAMEINSOURCE 'BOOKS') ) OPTIONS(UPDATABLE 'TRUE', "teiid_infinispan-hotrod:CACHE" 'books_indexed'); CREATE FOREIGN TABLE ST_viewBooks ( isbn string(255) NOT NULL, title string(255), publisher integer OPTIONS(FIXED_LENGTH 'TRUE'), publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'), edition integer OPTIONS(FIXED_LENGTH 'TRUE'), type string(255), CONSTRAINT pk_book PRIMARY KEY(isbn) OPTIONS(NAMEINSOURCE 'BOOKS') ) OPTIONS(UPDATABLE 'TRUE', "teiid_infinispan-hotrod:CACHE" 'books_indexed_st'); {code} Right model (in my opinion): {code:java} SET NAMESPACE 'http://www.teiid.org/translator/infinispan/2017' AS teiid_ispn CREATE FOREIGN TABLE viewBooks ( isbn string(255) NOT NULL, title string(255), publisher integer OPTIONS(FIXED_LENGTH 'TRUE'), publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'), edition integer OPTIONS(FIXED_LENGTH 'TRUE'), type string(255), CONSTRAINT pk_book PRIMARY KEY(isbn) OPTIONS(NAMEINSOURCE 'BOOKS') ) OPTIONS(UPDATABLE 'TRUE', "teiid_ispn:CACHE" 'books_indexed'); CREATE FOREIGN TABLE ST_viewBooks ( isbn string(255) NOT NULL, title string(255), publisher integer OPTIONS(FIXED_LENGTH 'TRUE'), publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'), edition integer OPTIONS(FIXED_LENGTH 'TRUE'), type string(255), CONSTRAINT pk_book PRIMARY KEY(isbn) OPTIONS(NAMEINSOURCE 'BOOKS') ) OPTIONS(UPDATABLE 'TRUE', "teiid_ispn:CACHE" 'books_indexed_st'); {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)