Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2868

texttable parsing error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major 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.

        1. marketdata-price.txt
          0.1 kB
        2. QuickStartSource.xmi
          57 kB
        3. QuickStartViewModel.xmi
          70 kB
        4. screenshot-1.png
          screenshot-1.png
          77 kB
        5. screenshot-2.png
          screenshot-2.png
          65 kB
        6. screenshot-3.png
          screenshot-3.png
          180 kB
        7. TeiiDDes2868.zip
          19 kB
        8. TeiiDDes2868.txt
          0.0 kB

              Unassigned Unassigned
              tljohnst@gmail.com thomas johnston (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: