November 2015 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2521) Usability: Model unresolved reference errors upon import of previously working project

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2521?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2521: ---------------------------------------- [~jpmat] you referred to: *model set from a previous version* ... what was the previous Designer version where the models and transformations were created and exported from? was it 9.0.1, or 8.x Designer? > Usability: Model unresolved reference errors upon import of previously working project > -------------------------------------------------------------------------------------- > > Key: TEIIDDES-2521 > URL: https://issues.jboss.org/browse/TEIIDDES-2521 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0 > Environment: JBDS Version: 8.0.0.GA > Build id: GA-v20141020-1042-B317 > Teiid Designer version: 9.0.1.Final-v20150211-1407-B643 > Reporter: Marc Shirley > Assignee: Barry LaFond > > Importing a model set from a previous version results in large number of errors like example [1] due to broken references. In one example set there were 900+ of these errors related to 3 model files. To correct, the model files need to have Edit -> Modeling -> Validate Transformations action run on each model individually. > [1] Sql transformation in the model mymodel1 contains the unresolved reference file:/C:/jbdevstudio/8.1.0.GA/workspaces/mymodel2.xmi -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2521) Usability: Model unresolved reference errors upon import of previously working project

by Jean-Pierre Matsumoto (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2521?page=com.atlassian.jira.plu... ] Jean-Pierre Matsumoto commented on TEIIDDES-2521: ------------------------------------------------- Yes I'm on Windows 7. Here are more info: jdk1.8.0_60 jboss-devstudio-8.1.0 JBoss Developer Studio (Branded Product) 8.1.0.GA-v20150327-1349-B467 ModeShape Client 3.7.0.Final-v20150112-2153-B202 Subclipse (Required) 1.10.4 Subversion Client Adapter (Required) 1.10.1 Subversion Revision Graph 1.1.1 SVNKit Client Adapter (Not required) 1.8.3 SVNKit Library 1.8.4.r10218_v20140302_1242 Teiid DataTools Connectivity 9.0.3.Final-v20150810-1438-B1157 Teiid Designer 9.0.3.Final-v20150810-1438-B1157 Teiid Designer Runtime 9.0.3.Final-v20150810-1438-B1157 Teiid Runtime Clients 9.0.3.Final-v20150810-1438-B1157 TestNG 6.8.6.20130914_0724 WTP Patches for org.eclipse.wst.jsdt.feature 3.6.3.v201503191608 We use 4 levels of models. L0 is datasource level. I think issue happens only on levels 1-3 when we change something at L0 level or we do a Project > Clean. I cannot easily attach artifacts. Hope this helps > Usability: Model unresolved reference errors upon import of previously working project > -------------------------------------------------------------------------------------- > > Key: TEIIDDES-2521 > URL: https://issues.jboss.org/browse/TEIIDDES-2521 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0 > Environment: JBDS Version: 8.0.0.GA > Build id: GA-v20141020-1042-B317 > Teiid Designer version: 9.0.1.Final-v20150211-1407-B643 > Reporter: Marc Shirley > Assignee: Barry LaFond > > Importing a model set from a previous version results in large number of errors like example [1] due to broken references. In one example set there were 900+ of these errors related to 3 model files. To correct, the model files need to have Edit -> Modeling -> Validate Transformations action run on each model individually. > [1] Sql transformation in the model mymodel1 contains the unresolved reference file:/C:/jbdevstudio/8.1.0.GA/workspaces/mymodel2.xmi -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2521) Usability: Model unresolved reference errors upon import of previously working project

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2521?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2521: ---------------------------------------- [~jpmat] Assuming you are on Windows? What was your original Designer version? And if you could attach artifacts that replicate this issue it would help tracking it down. > Usability: Model unresolved reference errors upon import of previously working project > -------------------------------------------------------------------------------------- > > Key: TEIIDDES-2521 > URL: https://issues.jboss.org/browse/TEIIDDES-2521 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0 > Environment: JBDS Version: 8.0.0.GA > Build id: GA-v20141020-1042-B317 > Teiid Designer version: 9.0.1.Final-v20150211-1407-B643 > Reporter: Marc Shirley > Assignee: Barry LaFond > > Importing a model set from a previous version results in large number of errors like example [1] due to broken references. In one example set there were 900+ of these errors related to 3 model files. To correct, the model files need to have Edit -> Modeling -> Validate Transformations action run on each model individually. > [1] Sql transformation in the model mymodel1 contains the unresolved reference file:/C:/jbdevstudio/8.1.0.GA/workspaces/mymodel2.xmi -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2708) Add support for importing JSON from a file

by Van Halbert (JIRA)

Van Halbert created TEIIDDES-2708: ------------------------------------- Summary: Add support for importing JSON from a file Key: TEIIDDES-2708 URL: https://issues.jboss.org/browse/TEIIDDES-2708 Project: Teiid Designer Issue Type: Feature Request Components: Import/Export Affects Versions: 9.0.3 Reporter: Van Halbert Add the ability to import from a JSON file. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2521) Usability: Model unresolved reference errors upon import of previously working project

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2521?page=com.atlassian.jira.plu... ] Van Halbert updated TEIIDDES-2521: ---------------------------------- Comment: was deleted (was: Jean-Pierre, Can you attach an example project set, it might help move this along?) > Usability: Model unresolved reference errors upon import of previously working project > -------------------------------------------------------------------------------------- > > Key: TEIIDDES-2521 > URL: https://issues.jboss.org/browse/TEIIDDES-2521 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0 > Environment: JBDS Version: 8.0.0.GA > Build id: GA-v20141020-1042-B317 > Teiid Designer version: 9.0.1.Final-v20150211-1407-B643 > Reporter: Marc Shirley > Assignee: Barry LaFond > > Importing a model set from a previous version results in large number of errors like example [1] due to broken references. In one example set there were 900+ of these errors related to 3 model files. To correct, the model files need to have Edit -> Modeling -> Validate Transformations action run on each model individually. > [1] Sql transformation in the model mymodel1 contains the unresolved reference file:/C:/jbdevstudio/8.1.0.GA/workspaces/mymodel2.xmi -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2521) Usability: Model unresolved reference errors upon import of previously working project

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2521?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-2521: --------------------------------------- Jean-Pierre, Can you attach an example project set, it might help move this along? > Usability: Model unresolved reference errors upon import of previously working project > -------------------------------------------------------------------------------------- > > Key: TEIIDDES-2521 > URL: https://issues.jboss.org/browse/TEIIDDES-2521 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0 > Environment: JBDS Version: 8.0.0.GA > Build id: GA-v20141020-1042-B317 > Teiid Designer version: 9.0.1.Final-v20150211-1407-B643 > Reporter: Marc Shirley > Assignee: Barry LaFond > > Importing a model set from a previous version results in large number of errors like example [1] due to broken references. In one example set there were 900+ of these errors related to 3 model files. To correct, the model files need to have Edit -> Modeling -> Validate Transformations action run on each model individually. > [1] Sql transformation in the model mymodel1 contains the unresolved reference file:/C:/jbdevstudio/8.1.0.GA/workspaces/mymodel2.xmi -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2521) Usability: Model unresolved reference errors upon import of previously working project

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2521?page=com.atlassian.jira.plu... ] Van Halbert updated TEIIDDES-2521: ---------------------------------- Summary: Usability: Model unresolved reference errors upon import of previously working project (was: Model unresolved reference errors upon import of previously working project) > Usability: Model unresolved reference errors upon import of previously working project > -------------------------------------------------------------------------------------- > > Key: TEIIDDES-2521 > URL: https://issues.jboss.org/browse/TEIIDDES-2521 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0 > Environment: JBDS Version: 8.0.0.GA > Build id: GA-v20141020-1042-B317 > Teiid Designer version: 9.0.1.Final-v20150211-1407-B643 > Reporter: Marc Shirley > Assignee: Barry LaFond > > Importing a model set from a previous version results in large number of errors like example [1] due to broken references. In one example set there were 900+ of these errors related to 3 model files. To correct, the model files need to have Edit -> Modeling -> Validate Transformations action run on each model individually. > [1] Sql transformation in the model mymodel1 contains the unresolved reference file:/C:/jbdevstudio/8.1.0.GA/workspaces/mymodel2.xmi -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2521) Model unresolved reference errors upon import of previously working project

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2521?page=com.atlassian.jira.plu... ] Van Halbert reassigned TEIIDDES-2521: ------------------------------------- Assignee: Barry LaFond > Model unresolved reference errors upon import of previously working project > --------------------------------------------------------------------------- > > Key: TEIIDDES-2521 > URL: https://issues.jboss.org/browse/TEIIDDES-2521 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0 > Environment: JBDS Version: 8.0.0.GA > Build id: GA-v20141020-1042-B317 > Teiid Designer version: 9.0.1.Final-v20150211-1407-B643 > Reporter: Marc Shirley > Assignee: Barry LaFond > > Importing a model set from a previous version results in large number of errors like example [1] due to broken references. In one example set there were 900+ of these errors related to 3 model files. To correct, the model files need to have Edit -> Modeling -> Validate Transformations action run on each model individually. > [1] Sql transformation in the model mymodel1 contains the unresolved reference file:/C:/jbdevstudio/8.1.0.GA/workspaces/mymodel2.xmi -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2521) Model unresolved reference errors upon import of previously working project

by Jean-Pierre Matsumoto (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2521?page=com.atlassian.jira.plu... ] Jean-Pierre Matsumoto commented on TEIIDDES-2521: ------------------------------------------------- Sorry to push but is there any plan to fix this issue soon ? I repeat the workaround 10 times a day. Thanks in advance. > Model unresolved reference errors upon import of previously working project > --------------------------------------------------------------------------- > > Key: TEIIDDES-2521 > URL: https://issues.jboss.org/browse/TEIIDDES-2521 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0 > Environment: JBDS Version: 8.0.0.GA > Build id: GA-v20141020-1042-B317 > Teiid Designer version: 9.0.1.Final-v20150211-1407-B643 > Reporter: Marc Shirley > > Importing a model set from a previous version results in large number of errors like example [1] due to broken references. In one example set there were 900+ of these errors related to 3 model files. To correct, the model files need to have Edit -> Modeling -> Validate Transformations action run on each model individually. > [1] Sql transformation in the model mymodel1 contains the unresolved reference file:/C:/jbdevstudio/8.1.0.GA/workspaces/mymodel2.xmi -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2684) SalesForce importer issue

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2684?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2684: ----------------------------------- Attachment: salesdynamic-vdb.xml It works for me with this dynamic VDB. > SalesForce importer issue > ------------------------- > > Key: TEIIDDES-2684 > URL: https://issues.jboss.org/browse/TEIIDDES-2684 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0.4 > Environment: MAC OS > Reporter: Matus Makovy > Assignee: Mark Drilling > Fix For: 9.3 > > Attachments: salesdynamic-vdb.xml > > > 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)

8 years, 6 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues November 2015