January 2016 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2731) VDB exported to Dynamic VDB XML, the foreign key relations have erroneous references in the resulting SQL.

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2731?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-2731 at 1/11/16 4:05 PM: ----------------------------------------------------------------- master: https://github.com/Teiid-Designer/teiid-designer/commit/e03f7c21f69397830... 9.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/73f2b6f8d50a5e931... was (Author: blafond): master: https://github.com/Teiid-Designer/teiid-designer/commit/e03f7c21f69397830... > VDB exported to Dynamic VDB XML, the foreign key relations have erroneous references in the resulting SQL. > ------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2731 > URL: https://issues.jboss.org/browse/TEIIDDES-2731 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Import/Export, Patch Release > Affects Versions: 9.2 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 9.0.5, 9.2.1 > > Attachments: TestcaseforExport.zip > > > Model: > • Catalog (ID, SecondID, ThirdID). Primary key: (ID). Unique constraint: (SecondID, ThirdID) > • CatalogItem(ID,CatalogID, CatalogSecondID, CatalogThirdID) > Foreign key relation on Unique constraints, spanning two columns: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > Expected in metadata DLL for CatalogItem: > CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(SecondID, ThirdID) > Actual: > CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(ID) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2731) VDB exported to Dynamic VDB XML, the foreign key relations have erroneous references in the resulting SQL.

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2731?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-2731 at 1/11/16 4:05 PM: ----------------------------------------------------------------- master: https://github.com/Teiid-Designer/teiid-designer/commit/e03f7c21f69397830... 9.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/73f2b6f8d50a5e931... was (Author: blafond): master: https://github.com/Teiid-Designer/teiid-designer/commit/e03f7c21f69397830... 9.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/73f2b6f8d50a5e931... > VDB exported to Dynamic VDB XML, the foreign key relations have erroneous references in the resulting SQL. > ------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2731 > URL: https://issues.jboss.org/browse/TEIIDDES-2731 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Import/Export, Patch Release > Affects Versions: 9.2 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 9.0.5, 9.2.1 > > Attachments: TestcaseforExport.zip > > > Model: > • Catalog (ID, SecondID, ThirdID). Primary key: (ID). Unique constraint: (SecondID, ThirdID) > • CatalogItem(ID,CatalogID, CatalogSecondID, CatalogThirdID) > Foreign key relation on Unique constraints, spanning two columns: CatalogItem(CatalogSecondID, CatalogThirdID)  Catalog(SecondID, ThirdID) > Expected in metadata DLL for CatalogItem: > CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(SecondID, ThirdID) > Actual: > CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(ID) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2746) Dynamic VDB export and import set bigdecimal precision to 20 if not defined and should be 0

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2746?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2746. ------------------------------------ Resolution: Done master: https://github.com/Teiid-Designer/teiid-designer/commit/8d37e5cb4726edc31... > Dynamic VDB export and import set bigdecimal precision to 20 if not defined and should be 0 > ------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2746 > URL: https://issues.jboss.org/browse/TEIIDDES-2746 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 9.2 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 9.0.5, 9.2.1 > > > Import vdb-xml into Teiid vdb: attribute with bigdecimal type (without precision) gets converted into bigdecimal(20) type (with precision=20), expected bigdecimal type > and > Export teiid-vdb to vdb-xml: attribute with bigdecimal type (without precision) gets converted into bigdecimal(20) type (with precision=20), expected bigdecimal type > If no precision is specified default to 0. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2617) "Teiid Connection>>Source Model" fails for HBase Datasource

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2617?page=com.atlassian.jira.plu... ] Johnathon Lee closed TEIIDDES-2617. ----------------------------------- Resolution: Rejected see https://issues.jboss.org/browse/TEIID-3678 > "Teiid Connection>>Source Model" fails for HBase Datasource > ----------------------------------------------------------- > > Key: TEIIDDES-2617 > URL: https://issues.jboss.org/browse/TEIIDDES-2617 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0.2 > Reporter: Debbie Steigner > Fix For: 9.0.5, 9.2.1 > > > "Teiid Connection>>Source Model" fails for HBase Datasource. The JDBC importer works. Error in the server log: > When trying to import into the Designer with Teiid Connection, it errors on the Importvdb metadata load with "ERROR 1101 (XCL01): ResultSet is closed.": > 14:46:33,771 INFO [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015876: Starting deployment of "importVDB-vdb.xml" (runtime-name: "importVDB-vdb.xml") > 14:46:33,825 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB importVDB.1 model "importVDBSrcModel" metadata is currently being loaded. Start Time: 8/4/15 2:46 PM > 14:46:33,825 INFO [org.teiid.CONNECTOR] (teiid-async-threads - 1) HBaseExecutionFactory Commit=true;DatabaseProductName=Phoenix;DatabaseProductVersion=4.3;DriverMajorVersion=4;DriverMajorVersion=3;DriverName=PhoenixEmbeddedDriver;DriverVersion=4.3;IsolationLevel=2 > 14:46:33,951 INFO [org.jboss.as.server] (management-handler-thread - 8) JBAS015859: Deployed "importVDB-vdb.xml" (runtime-name : "importVDB-vdb.xml") > 14:46:34,210 WARN [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB importVDB.1 model "importVDBSrcModel" metadata failed to load. Reason:TEIID11010 java.sql.SQLException: ERROR 1101 (XCL01): ResultSet is closed. > 14:46:35,736 INFO [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50026 VDB "importVDB.1[importVDBSrcModel{importVDBSrcModel=importVDBSrcModel, hbase, java:/PhoenixDS}]" undeployed. > Saw this https://developer.jboss.org/thread/260099, customer is getting the same winutils error and they state: This error usually comes when the hadoop server is accessed from windows machine. > we get this error in other windows environment but this does not affect the application. > Not sure if this should be logged in Teiid Designer or Teiid -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2704) Changing models results in unmodified models being marked changed by Eclipse

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2704?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2704. ------------------------------------ Resolution: Done master : https://github.com/Teiid-Designer/teiid-designer/commit/423511120e6f02a22... > Changing models results in unmodified models being marked changed by Eclipse > ---------------------------------------------------------------------------- > > Key: TEIIDDES-2704 > URL: https://issues.jboss.org/browse/TEIIDDES-2704 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling > Affects Versions: 9.0.2 > Reporter: Marc Shirley > Assignee: Barry LaFond > Fix For: 9.0.5, 9.2.1 > > > Making changes in one model can result in other models being marked as changed even though they are unmodified by the user. In the reproduction steps, making a change to a transformation in one model results in changes to a related model that is unmodified by the user. When closing and discarding changes in the related model, additional changes (not initiated by the user) are made to the original model. These Eclipse-initiated changes seem to result in reference errors when building the model if they are saved. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2753) Upgrade Modeshape core and ddl jars

by Barry LaFond (JIRA)

Barry LaFond created TEIIDDES-2753: -------------------------------------- Summary: Upgrade Modeshape core and ddl jars Key: TEIIDDES-2753 URL: https://issues.jboss.org/browse/TEIIDDES-2753 Project: Teiid Designer Issue Type: Task Components: ModeShape Integration Reporter: Barry LaFond Assignee: Paul Richardson Priority: Blocker Fix For: 9.2.1 Upgrade MS jars for fixes/enhancements to Teiid dialect sequencer classes -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2617) "Teiid Connection>>Source Model" fails for HBase Datasource

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2617?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-2617: ---------------------------------------- [~blafond] I've reproduced this on MAC, Fedora and Win 7. Actually, this seems to be a Phoenix issue. There is already a bug reported for Teiid (TEIID-3678) and also in PHOENIX JIRA (https://issues.apache.org/jira/browse/PHOENIX-2232) > "Teiid Connection>>Source Model" fails for HBase Datasource > ----------------------------------------------------------- > > Key: TEIIDDES-2617 > URL: https://issues.jboss.org/browse/TEIIDDES-2617 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0.2 > Reporter: Debbie Steigner > Fix For: 9.0.5, 9.2.1 > > > "Teiid Connection>>Source Model" fails for HBase Datasource. The JDBC importer works. Error in the server log: > When trying to import into the Designer with Teiid Connection, it errors on the Importvdb metadata load with "ERROR 1101 (XCL01): ResultSet is closed.": > 14:46:33,771 INFO [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015876: Starting deployment of "importVDB-vdb.xml" (runtime-name: "importVDB-vdb.xml") > 14:46:33,825 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB importVDB.1 model "importVDBSrcModel" metadata is currently being loaded. Start Time: 8/4/15 2:46 PM > 14:46:33,825 INFO [org.teiid.CONNECTOR] (teiid-async-threads - 1) HBaseExecutionFactory Commit=true;DatabaseProductName=Phoenix;DatabaseProductVersion=4.3;DriverMajorVersion=4;DriverMajorVersion=3;DriverName=PhoenixEmbeddedDriver;DriverVersion=4.3;IsolationLevel=2 > 14:46:33,951 INFO [org.jboss.as.server] (management-handler-thread - 8) JBAS015859: Deployed "importVDB-vdb.xml" (runtime-name : "importVDB-vdb.xml") > 14:46:34,210 WARN [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB importVDB.1 model "importVDBSrcModel" metadata failed to load. Reason:TEIID11010 java.sql.SQLException: ERROR 1101 (XCL01): ResultSet is closed. > 14:46:35,736 INFO [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50026 VDB "importVDB.1[importVDBSrcModel{importVDBSrcModel=importVDBSrcModel, hbase, java:/PhoenixDS}]" undeployed. > Saw this https://developer.jboss.org/thread/260099, customer is getting the same winutils error and they state: This error usually comes when the hadoop server is accessed from windows machine. > we get this error in other windows environment but this does not affect the application. > Not sure if this should be logged in Teiid Designer or Teiid -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2469) [Usability] Problem importing SOAP web service via URL

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2469?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2469. ------------------------------------ Resolution: Done master : https://github.com/Teiid-Designer/teiid-designer/commit/bc5105bc01689b3ee... > [Usability] Problem importing SOAP web service via URL > ------------------------------------------------------ > > Key: TEIIDDES-2469 > URL: https://issues.jboss.org/browse/TEIIDDES-2469 > Project: Teiid Designer > Issue Type: Quality Risk > Components: Import/Export, Patch Release > Affects Versions: 9.0 > Reporter: Van Halbert > Assignee: Barry LaFond > Fix For: 9.2.1 > > Attachments: bug.mov, define-rest-procedure-tags-dialog.png > > > Conversation: > [09:44] <jmarley> vhalbert: do you have a document for import soap web service via url > [09:45] <jmarley> we are getting hung up on creating relational model > [09:45] <jmarley> vhalbert: nevermind, > [09:46] <jmarley> vhalbert: there was an error saying we didn't have a column defined, but it was for a different procedure than the one that was selected, which and we didn't know we needed to select the other procedure and assumed it was issue with current procedure we were working with > [09:47] <vhalbert> jmarley, hm > [09:47] <vhalbert> jmarley, so designer was processing something that wasn't selected > [09:48] <jmarley> vhalbert: yes, and didn't give an indication as to which procedure it was referring to -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2617) "Teiid Connection>>Source Model" fails for HBase Datasource

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2617?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-2617: ---------------------------------------- [~blafond] We have a HBase instance I will try to reproduce this and let you know. > "Teiid Connection>>Source Model" fails for HBase Datasource > ----------------------------------------------------------- > > Key: TEIIDDES-2617 > URL: https://issues.jboss.org/browse/TEIIDDES-2617 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0.2 > Reporter: Debbie Steigner > Fix For: 9.0.5, 9.2.1 > > > "Teiid Connection>>Source Model" fails for HBase Datasource. The JDBC importer works. Error in the server log: > When trying to import into the Designer with Teiid Connection, it errors on the Importvdb metadata load with "ERROR 1101 (XCL01): ResultSet is closed.": > 14:46:33,771 INFO [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015876: Starting deployment of "importVDB-vdb.xml" (runtime-name: "importVDB-vdb.xml") > 14:46:33,825 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB importVDB.1 model "importVDBSrcModel" metadata is currently being loaded. Start Time: 8/4/15 2:46 PM > 14:46:33,825 INFO [org.teiid.CONNECTOR] (teiid-async-threads - 1) HBaseExecutionFactory Commit=true;DatabaseProductName=Phoenix;DatabaseProductVersion=4.3;DriverMajorVersion=4;DriverMajorVersion=3;DriverName=PhoenixEmbeddedDriver;DriverVersion=4.3;IsolationLevel=2 > 14:46:33,951 INFO [org.jboss.as.server] (management-handler-thread - 8) JBAS015859: Deployed "importVDB-vdb.xml" (runtime-name : "importVDB-vdb.xml") > 14:46:34,210 WARN [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB importVDB.1 model "importVDBSrcModel" metadata failed to load. Reason:TEIID11010 java.sql.SQLException: ERROR 1101 (XCL01): ResultSet is closed. > 14:46:35,736 INFO [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50026 VDB "importVDB.1[importVDBSrcModel{importVDBSrcModel=importVDBSrcModel, hbase, java:/PhoenixDS}]" undeployed. > Saw this https://developer.jboss.org/thread/260099, customer is getting the same winutils error and they state: This error usually comes when the hadoop server is accessed from windows machine. > we get this error in other windows environment but this does not affect the application. > Not sure if this should be logged in Teiid Designer or Teiid -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2469) [Usability] Problem importing SOAP web service via URL

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2469?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-2469: ---------------------------------------- [~blafond] Video is attached here in JIRA. Here is the link: https://issues.jboss.org/secure/attachment/12394036/bug.mov I tried to download the video and play it and it works for me. > [Usability] Problem importing SOAP web service via URL > ------------------------------------------------------ > > Key: TEIIDDES-2469 > URL: https://issues.jboss.org/browse/TEIIDDES-2469 > Project: Teiid Designer > Issue Type: Quality Risk > Components: Import/Export, Patch Release > Affects Versions: 9.0 > Reporter: Van Halbert > Assignee: Barry LaFond > Fix For: 9.2.1 > > Attachments: bug.mov, define-rest-procedure-tags-dialog.png > > > Conversation: > [09:44] <jmarley> vhalbert: do you have a document for import soap web service via url > [09:45] <jmarley> we are getting hung up on creating relational model > [09:45] <jmarley> vhalbert: nevermind, > [09:46] <jmarley> vhalbert: there was an error saying we didn't have a column defined, but it was for a different procedure than the one that was selected, which and we didn't know we needed to select the other procedure and assumed it was issue with current procedure we were working with > [09:47] <vhalbert> jmarley, hm > [09:47] <vhalbert> jmarley, so designer was processing something that wasn't selected > [09:48] <jmarley> vhalbert: yes, and didn't give an indication as to which procedure it was referring to -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues January 2016