[JBoss JIRA] (TEIIDDES-2868) texttable parsing error
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2868?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2868:
----------------------------------------
[~virtualdatabase] Since you can type in the SQL by hand and make it work... I'm assuming it's a weird Windows character that's getting in the way.
>>>> can you paste the SQL (from clipboard) into a txt file and attach it? I can then try load/debug the file to look for chars not on linux and add those during debug to replicate it then provide a fix
> 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, screenshot-3.png, TeiiDDes2868.zip
>
>
> 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)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2889) Inconsistent errors in Problems View
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2889?page=com.atlassian.jira.plu... ]
Matej Kralik edited comment on TEIIDDES-2889 at 8/2/16 11:52 AM:
-----------------------------------------------------------------
I have the similar problem. When I wanted to reproduce this bug TEIIDDES-2414, the error appears just after I rename the project. I think this is confusing because the user thinks that he doesn't have any problems but the problems are there. I will add my step to reproduce to point 2.
was (Author: mkralik):
I have the similar problem. When I wanted to reproduce this bug [TEIIDDES-2414|https://issues.jboss.org/browse/TEIIDDES-2414], the error appears just after I rename the project. I think this is confusing because the user thinks that he doesn't have any problems but the problems are there. I will add my step to reproduce to point 2.
> Inconsistent errors in Problems View
> ------------------------------------
>
> Key: TEIIDDES-2889
> URL: https://issues.jboss.org/browse/TEIIDDES-2889
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations, Views
> Affects Versions: 10.0.1
> Reporter: stanislav kaleta
> Attachments: screenshot1.png, screenshot2.png
>
>
> Errors which occur in Designer (e.g. Transformation Editor) are not showed in Problems View immediately. Some of them appears after another action (e.g. rename project) or after VDB creation. On the other hand, some errors which were resolved in Designer remain present in Problems View.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2889) Inconsistent errors in Problems View
by stanislav kaleta (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2889?page=com.atlassian.jira.plu... ]
stanislav kaleta updated TEIIDDES-2889:
---------------------------------------
Steps to Reproduce:
(in progress)
1. ...
# generate Web Service Model from table of Relational View Model (right-click, modeling, Create Web Service, fill names, Finish)
# rename Interface of generated Web Service Model (or related XML document)
# open Operation Editor, select operation and click Save/Validate SQL, Save All (close editor)
# Error below procedure editor appears, concurrently no errors in Problems View are present (thus it seems that there are no errors in project)
# Create VDB with Web Service Model (right-click model, New->Teiid VDB, set name and click OK)
# Errors in Problems View appear.
2. ...
# Import csv from TEIIDDES-2414
# After importing problems view doesn't show any error (screenshot1)
# Rename project
# The error is appeared in the problems view (screenshot2)
3. ...
# A
# B
was:
(in progress)
1. ...
# generate Web Service Model from table of Relational View Model (right-click, modeling, Create Web Service, fill names, Finish)
# rename Interface of generated Web Service Model (or related XML document)
# open Operation Editor, select operation and click Save/Validate SQL (Save All and close all editors)
# Error below procedure editor appears, concurrently no errors in Problems View are present (thus it seems that there are no errors in project)
# Create VDB with Web Service Model (right-click model, New->Teiid VDB, set name and click OK)
# Errors in Problems View appear.
2. ...
# Import csv from TEIIDDES-2414
# After importing problems view doesn't show any error (screenshot1)
# Rename project
# The error is appeared in the problems view (screenshot2)
3. ...
# A
# B
> Inconsistent errors in Problems View
> ------------------------------------
>
> Key: TEIIDDES-2889
> URL: https://issues.jboss.org/browse/TEIIDDES-2889
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations, Views
> Affects Versions: 10.0.1
> Reporter: stanislav kaleta
> Attachments: screenshot1.png, screenshot2.png
>
>
> Errors which occur in Designer (e.g. Transformation Editor) are not showed in Problems View immediately. Some of them appears after another action (e.g. rename project) or after VDB creation. On the other hand, some errors which were resolved in Designer remain present in Problems View.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2889) Inconsistent errors in Problems View
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2889?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2889:
-----------------------------------
Attachment: screenshot2.png
screenshot1.png
> Inconsistent errors in Problems View
> ------------------------------------
>
> Key: TEIIDDES-2889
> URL: https://issues.jboss.org/browse/TEIIDDES-2889
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations, Views
> Affects Versions: 10.0.1
> Reporter: stanislav kaleta
> Attachments: screenshot1.png, screenshot2.png
>
>
> Errors which occur in Designer (e.g. Transformation Editor) are not showed in Problems View immediately. Some of them appears after another action (e.g. rename project) or after VDB creation. On the other hand, some errors which were resolved in Designer remain present in Problems View.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2889) Inconsistent errors in Problems View
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2889?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2889:
-----------------------------------
Steps to Reproduce:
(in progress)
1. ...
# generate Web Service Model from table of Relational View Model (right-click, modeling, Create Web Service, fill names, Finish)
# rename Interface of generated Web Service Model (or related XML document)
# open Operation Editor, select operation and click Save/Validate SQL (Save All and close all editors)
# Error below procedure editor appears, concurrently no errors in Problems View are present (thus it seems that there are no errors in project)
# Create VDB with Web Service Model (right-click model, New->Teiid VDB, set name and click OK)
# Errors in Problems View appear.
2. ...
# Import csv from TEIIDDES-2414
# After importing problems view doesn't show any error (screenshot1)
# Rename project
# The error is appeared in the problems view (screenshot2)
3. ...
# A
# B
was:
(in progress)
1. ...
# generate Web Service Model from table of Relational View Model (right-click, modeling, Create Web Service, fill names, Finish)
# rename Interface of generated Web Service Model (or related XML document)
# open Operation Editor, select operation and click Save/Validate SQL, Save All (close editor)
# Error below procedure editor appears, concurrently no errors in Problems View are present (thus it seems that there are no errors in project)
# Create VDB with Web Service Model (right-click model, New->Teiid VDB, set name and click OK)
# Errors in Problems View appear.
2. ...
# A
# B
3. ...
# A
# B
> Inconsistent errors in Problems View
> ------------------------------------
>
> Key: TEIIDDES-2889
> URL: https://issues.jboss.org/browse/TEIIDDES-2889
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations, Views
> Affects Versions: 10.0.1
> Reporter: stanislav kaleta
>
> Errors which occur in Designer (e.g. Transformation Editor) are not showed in Problems View immediately. Some of them appears after another action (e.g. rename project) or after VDB creation. On the other hand, some errors which were resolved in Designer remain present in Problems View.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2889) Inconsistent errors in Problems View
by stanislav kaleta (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2889?page=com.atlassian.jira.plu... ]
stanislav kaleta updated TEIIDDES-2889:
---------------------------------------
Steps to Reproduce:
(in progress)
1. ...
# generate Web Service Model from table of Relational View Model (right-click, modeling, Create Web Service, fill names, Finish)
# rename Interface of generated Web Service Model (or related XML document)
# open Operation Editor, select operation and click Save/Validate SQL, Save All (close editor)
# Error below procedure editor appears, concurrently no errors in Problems View are present (thus it seems that there are no errors in project)
# Create VDB with Web Service Model (right-click model, New->Teiid VDB, set name and click OK)
# Errors in Problems View appear.
2. ...
# A
# B
3. ...
# A
# B
was:
(in progress)
1. ...
# generate Web Service Model from table of Relational View Model (right-click, modeling, Create Web Service, fill names, Finish)
# rename Interface of generated Web Service Model (or related XML document)
# open Operation Editor, select operation and click Save/Validate SQL (Save All and close all editors)
# Error below procedure editor appears, concurrently no errors in Problems View are present (thus it seems that there are no errors in project)
# Create VDB with Web Service Model (right-click model, New->Teiid VDB, set name and click OK)
# Errors in Problems View appear.
2. ...
# Import csv from TEIIDDES-2414
# B
3. ...
# A
# B
> Inconsistent errors in Problems View
> ------------------------------------
>
> Key: TEIIDDES-2889
> URL: https://issues.jboss.org/browse/TEIIDDES-2889
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations, Views
> Affects Versions: 10.0.1
> Reporter: stanislav kaleta
>
> Errors which occur in Designer (e.g. Transformation Editor) are not showed in Problems View immediately. Some of them appears after another action (e.g. rename project) or after VDB creation. On the other hand, some errors which were resolved in Designer remain present in Problems View.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2889) Inconsistent errors in Problems View
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2889?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2889:
-----------------------------------
Steps to Reproduce:
(in progress)
1. ...
# generate Web Service Model from table of Relational View Model (right-click, modeling, Create Web Service, fill names, Finish)
# rename Interface of generated Web Service Model (or related XML document)
# open Operation Editor, select operation and click Save/Validate SQL (Save All and close all editors)
# Error below procedure editor appears, concurrently no errors in Problems View are present (thus it seems that there are no errors in project)
# Create VDB with Web Service Model (right-click model, New->Teiid VDB, set name and click OK)
# Errors in Problems View appear.
2. ...
# Import csv from TEIIDDES-2414
# B
3. ...
# A
# B
was:
(in progress)
1. ...
# generate Web Service Model from table of Relational View Model (right-click, modeling, Create Web Service, fill names, Finish)
# rename Interface of generated Web Service Model (or related XML document)
# open Operation Editor, select operation and click Save/Validate SQL (Save All and close all editors)
# Error below procedure editor appears, concurrently no errors in Problems View are present (thus it seems that there are no errors in project)
# Create VDB with Web Service Model (right-click model, New->Teiid VDB, set name and click OK)
# Errors in Problems View appear.
2. ...
# A
# B
3. ...
# A
# B
> Inconsistent errors in Problems View
> ------------------------------------
>
> Key: TEIIDDES-2889
> URL: https://issues.jboss.org/browse/TEIIDDES-2889
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations, Views
> Affects Versions: 10.0.1
> Reporter: stanislav kaleta
>
> Errors which occur in Designer (e.g. Transformation Editor) are not showed in Problems View immediately. Some of them appears after another action (e.g. rename project) or after VDB creation. On the other hand, some errors which were resolved in Designer remain present in Problems View.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2889) Inconsistent errors in Problems View
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2889?page=com.atlassian.jira.plu... ]
Matej Kralik commented on TEIIDDES-2889:
----------------------------------------
I have the similar problem. When I wanted to reproduce this bug [TEIIDDES-2414|https://issues.jboss.org/browse/TEIIDDES-2414], the error appears just after I rename the project. I think this is confusing because the user thinks that he doesn't have any problems but the problems are there. I will add my step to reproduce to point 2.
> Inconsistent errors in Problems View
> ------------------------------------
>
> Key: TEIIDDES-2889
> URL: https://issues.jboss.org/browse/TEIIDDES-2889
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations, Views
> Affects Versions: 10.0.1
> Reporter: stanislav kaleta
>
> Errors which occur in Designer (e.g. Transformation Editor) are not showed in Problems View immediately. Some of them appears after another action (e.g. rename project) or after VDB creation. On the other hand, some errors which were resolved in Designer remain present in Problems View.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2868) texttable parsing error
by Tom Johnston (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2868?page=com.atlassian.jira.plu... ]
Tom Johnston updated TEIIDDES-2868:
-----------------------------------
Attachment: TeiiDDes2868.zip
> 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, screenshot-3.png, TeiiDDes2868.zip
>
>
> 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)
9 years, 2 months
[JBoss JIRA] (TEIIDDES-2889) Inconsistent errors in Problems View
by stanislav kaleta (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2889?page=com.atlassian.jira.plu... ]
stanislav kaleta updated TEIIDDES-2889:
---------------------------------------
Description: Errors which occur in Designer (e.g. Transformation Editor) are not showed in Problems View immediately. Some of them appears after another action (e.g. rename project) or after VDB creation. On the other hand, some errors which were resolved in Designer remain present in Problems View. (was: Errors which occur in Designer (e.g. Transformation Editor) are not showed in Problems View immediately. Some of them appears after another action (e.g. rename project) or after VDB creation. On the other hand, errors which were resolved in Designer remain present in Problems View. )
> Inconsistent errors in Problems View
> ------------------------------------
>
> Key: TEIIDDES-2889
> URL: https://issues.jboss.org/browse/TEIIDDES-2889
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations, Views
> Affects Versions: 10.0.1
> Reporter: stanislav kaleta
>
> Errors which occur in Designer (e.g. Transformation Editor) are not showed in Problems View immediately. Some of them appears after another action (e.g. rename project) or after VDB creation. On the other hand, some errors which were resolved in Designer remain present in Problems View.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 2 months