-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
10.0
-
None
-
None
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.
- is related to
-
TEIIDDES-2916 Create temporary table results in "Error in parsing of sql - null"
- Closed