]
Barry LaFond commented on TEIIDDES-2868:
----------------------------------------
Tom... I just tested (UBUNTU) the same scenario...
1) Are you on Windows?
2) Can you maybe delete the last few characters after paste, then re-type them? Wondering
if it's a special windows char that's getting in the way.
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
Attachments: marketdata-price.txt, QuickStartSource.xmi, QuickStartViewModel.xmi,
screenshot-1.png, screenshot-2.png
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.