[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1554) Unable to validate transformation in project set in Designer 8 where the project was built in Designer 7.x

[ https://issues.jboss.org/browse/TEIIDDES-1554?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-1554 at 1/24/13 5:12 PM: ----------------------------------------------------------------- The portfolio.zip project set which contains a 3.8 MB MarketDataView.xmi file which has only one table in it. Somehow overe 17,000 extra/redundant/bogus SqlTransformationMappingRoot (EMF) objects were created in this model. Only the first one is valid, and the rest don't have enough info attached to them to validate any more than: "Re-validate in the transformation editor.... blah, blah.." I recreated/replaced the MarketDataView model and it's StockPrices table containing the same SQL statement and it validated fine. I also cleared out 2 transformations in the Stocks view model, so it would find the new MarketDataView.StockPrices table. There was one remaining validation error on the StockValidation virtual procedure: ===>>> ERROR: TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists. So the procedure below needs to be tweaked based on the new Teiid TEMPORARY TABLE syntax/rules and described in the next Teiid Release Documenation CREATE VIRTUAL PROCEDURE BEGIN DECLARE String VARIABLES.msg; CREATE LOCAL TEMPORARY TABLE TEMP (companyname string, symbol string, price bigdecimal, message string); LOOP ON (SELECT Stock.Stock.symbol, Stock.Stock.price, Stock.Stock.COMPANY_NAME FROM Stock) AS txncursor BEGIN VARIABLES.msg = RulesUDF.ValidateMarket(txncursor.COMPANY_NAME, txncursor.symbol, txncursor.price); IF(VARIABLES.msg <> 'NoMsg') BEGIN INSERT INTO TEMP (TEMP.companyname, TEMP.symbol, TEMP.price, TEMP.message) VALUES (txncursor.COMPANY_NAME, txncursor.symbol, txncursor.price, VARIABLES.msg); END END SELECT TEMP.companyname, TEMP.symbol, TEMP.price, TEMP.message FROM TEMP; END was (Author: blafond): The portfolio.zip project set which contains a 3.8 MB MarketDataView.xmi file which has only one table in it. Somehow overe 17,000 extra/redundant/bogus SqlTransformationMappingRoot (EMF) objects were created in this model. Only the first one is valid, and the rest don't have enough info attached to them to validate any more than: "Re-validate in the transformation editor.... blah, blah.." I recreated/replaced the MarketDataView model and it's StockPrices table containing the same SQL statement and it validated fine. I also cleared out 2 transformations in the Stocks view model, so it would find the new MarketDataView.StockPrices table. There was one remaining validation error on the StockValidation virtual procedure: ===>>> ERROR: TEIID30118 Cannot create temporary table "TEMP". An object with the same name already exists. So the procedure below needs to be tweaked based on the new Teiid TEMPORARY TABLE syntax/rules CREATE VIRTUAL PROCEDURE BEGIN DECLARE String VARIABLES.msg; CREATE LOCAL TEMPORARY TABLE TEMP (companyname string, symbol string, price bigdecimal, message string); LOOP ON (SELECT Stock.Stock.symbol, Stock.Stock.price, Stock.Stock.COMPANY_NAME FROM Stock) AS txncursor BEGIN VARIABLES.msg = RulesUDF.ValidateMarket(txncursor.COMPANY_NAME, txncursor.symbol, txncursor.price); IF(VARIABLES.msg <> 'NoMsg') BEGIN INSERT INTO TEMP (TEMP.companyname, TEMP.symbol, TEMP.price, TEMP.message) VALUES (txncursor.COMPANY_NAME, txncursor.symbol, txncursor.price, VARIABLES.msg); END END SELECT TEMP.companyname, TEMP.symbol, TEMP.price, TEMP.message FROM TEMP; END -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira