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

MED for JDG7 set wrong NAMESPACE and properties prefix

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: 11.1.1
    • Fix Version/s: 11.1.2
    • Component/s: None
    • Labels:
    • Workaround Description:
      1. Rename namespace and properties prefix from teiid_infinispan-hotrod to teiid_ispn

      Description

      For workaround in this issue 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:

      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.
      

      I also noticed that name of properties are teiid_infinispan-hotrod but should be teiid_ispn.

      Generated model in xml vdb:

      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');
      

      Right model (in my opinion):

      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');
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                mkralik Matej Kralik
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: