[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 commented on TEIIDDES-2868:
----------------------------------------
This is becoming a real hassle!
I've attached a simple project wherein I created a view Model (ViewModel1)
I created a simple view (Test1) which has the transformation "Select now() as CurDateTime"
I copied the transformation form Test1 to my clipboard. (Control A, control C)
I created another view "Test2" and pasted the contents into the transformation.
AGAIN.. I get the error:
"ERROR: Error in parsing of sql - null"
I am attaching the project.
!screenshot-3.png!
> 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
>
>
> 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:
---------------------------------------
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. ...
# 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. ...
# 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, 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: screenshot-3.png
> 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
>
>
> 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:
---------------------------------------
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. ...
# A
# B
was:
(in progress)
1. ...
# A
# B
2. ...
# 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, 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 Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2889?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2889:
----------------------------------------
[~skaleta] The transformation editor utilizes a query parser/resolving framework that's shared with Designer's artifact "Builders" framework. When using the "validation" button in the T-Editor the error/validation messages are processed separately. The Builders framework is triggered by saving resources, so saving the MODEL will end up affecting problem markers. These differences are currently by design.
If there are T-editor errors and problem markers that are not the same after the model is SAVED.. then that is an issue.
> 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, 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-2684) SalesForce importer issue
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2684?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-2684:
------------------------------------------
> in the importer in Designer, am I right?
Yes
> SalesForce importer issue
> -------------------------
>
> Key: TEIIDDES-2684
> URL: https://issues.jboss.org/browse/TEIIDDES-2684
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, Patch Release
> Affects Versions: 9.0.4
> Environment: MAC OS
> Reporter: Matus Makovy
> Assignee: Mark Drilling
> Fix For: 10.0.1, 9.2.1
>
> Attachments: salesdynamic-vdb.xml, TEIIDDES_2684.log
>
>
> According to conversation in TEIID-3112 this is a Designer issue. If I understood correctly, it has been fixed in Teiid and now the changes have to be made in TD SF importer.
> I have a VDB with Source model that is created via SalesForce importer and I am getting this error:
> {quote}
> Didn't understand relationship 'Opportunitys' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names
> {quote}
> when trying to submit this query:
> {quote}
> select distinct YEAR("Opportunity"."CloseDate") as "Opportunity_CloseDate1" from "SalesForceSource".Campaign AS "Campaign" LEFT OUTER JOIN "SalesForceSource".Opportunity AS "Opportunity" ON Campaign."Id" = Opportunity."CampaignId" order by YEAR("Opportunity"."CloseDate") ASC LIMIT 0 , 32
> {quote}
> It works without problems with dynamic VDB.
--
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:
1. ...
# A
# B
2. ...
# A
# B
was:
1. ...
# #
#
#
> 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, 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. ...
# A
# B
2. ...
# A
# B
was:
1. ...
# A
# B
2. ...
# 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, 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:
1. ...
# A
# B
2. ...
# A
# B
was:
1. ...
# A
# B
2. ...
# 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, 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:
1. ...
#
#
#
was:
1. ...
# 1
# 2
# 3
> 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, 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