]
Matus Makovy commented on TEIIDDES-2868:
----------------------------------------
[~virtualdatabase] I think, we will need some additional info in order to by able to fully
understand and reproduce this. Could you provide the models you created and text files
also if possible?
texttable parsing error
-----------------------
Key: TEIIDDES-2868
URL:
https://issues.jboss.org/browse/TEIIDDES-2868
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 10.0
Environment: Teiid
Designer 10.0.0.Final-v20160413-1817-B4094 org.teiid.designer.feature.feature.group JBoss
by Red Hat
Reporter: Tom Johnston
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.
ALSO if I deploy the 1st physical and view models to a vdb I can execute the view
transformation that fails in designer fine from squirrel getting data returned.