[ https://issues.jboss.org/browse/TEIIDDES-2868?page=com.atlassian.jira.plu... ] Tom Johnston updated TEIIDDES-2868: ----------------------------------- Description: I successfully created a physical table and view using texttable. I can query it. I then manually created another view to a different file and it kept failing with a very ambiguous error when I tried validating. ERROR: Error in parsing of sql - null I then created another view with a diff name of the 1st view using the same copy/pasted transformation.. it too resulting with the same error: The auto-generated view verbiage that was created and that I re-used was: SELECT A.OldWAC, A.NewWAC FROM (EXEC SourceModel.getTextFiles('wac.txt')) AS f, TEXTTABLE(f.file COLUMNS OldWAC string, NewWAC string DELIMITER '|') AS A You can also clone the automatically created object, copy the transformation, clear the transformation, paste back the transformation and it too fails with the same error. was: I successfully created a physical table and view using texttable. I can query it. I then manually created another view to a different file and it kept failing with a very ambiguous error when I tried validating. ERROR: Error in parsing of sql - null I then created another view with a diff name of the 1st view using the same copy/pasted transformation.. it too resulting with the same error: The auto-generated view verbiage that was created and that I re-used was: SELECT A.OldWAC, A.NewWAC FROM (EXEC SourceModel.getTextFiles('wac.txt')) AS f, TEXTTABLE(f.file COLUMNS OldWAC string, NewWAC string DELIMITER '|') AS A -- This message was sent by Atlassian JIRA (v6.4.11#64026)