[
https://issues.jboss.org/browse/TEIIDDES-2868?page=com.atlassian.jira.plu...
]
Tom Johnston updated TEIIDDES-2868:
-----------------------------------
Attachment: QuickStartSource.xmi
QuickStartViewModel.xmi
marketdata-price.txt
I used the quickstart to reproduce and attach..
See the QuickStartViewModel.new_table2 view it the query is not parsable.
I made it by cloning the other view in the same model (new_table), copying the
transformation, clearing the transformation and then paste back the transformation, click
validate and the error appears:
The query is not parsable.
Error in parsing of sql - null
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
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.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)