7 Replies Latest reply on May 7, 2015 2:26 AM by John Khoury

    Duplicate a view

    John Khoury Newbie

      Hi there,

       

      i am wondering if it's logical to deploy a view in 2 virtual ModelMetaData. I was able to deploy it but the Materialization fails with the below exceptions.

       

      org.teiid.jdbc.TeiidSQLException: TEIID30328 Unable to evaluate (SELECT UID FROM Sys.Tables WHERE (VDBName = VARIABLES.vdbName) AND (SchemaName IS NOT NULL) AND (Name = viewName) LIMIT 2): TEIID30345 The command of this scalar subquery returned more than one value: SELECT UID FROM Sys.Tables WHERE (VDBName = VARIABLES.vdbName) AND (SchemaName IS NOT NULL) AND (Name = viewName) LIMIT 2

       

      The purpose is to read the view from different Materialization locations deepening on a criteria.

       

      Regards

       

      Message was edited by: John Khoury Wrong Expcetion