March 2017 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2660) Add support in Designer for foreign keys cross models

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2660?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2660: ---------------------------------------- [~mmakovy] Unfortunately, the use of EMF to represent relational FK/PK references requires a 2 way reference, so the FK in one model holds a reference to the external PK and visa-versa. These references end up adding a "Model Import" which, of course becomes circular when we do the model dependency validation. argh.... > Add support in Designer for foreign keys cross models > ----------------------------------------------------- > > Key: TEIIDDES-2660 > URL: https://issues.jboss.org/browse/TEIIDDES-2660 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling > Reporter: Van Halbert > Assignee: Barry LaFond > Fix For: 11.0.2 > > Attachments: foreignKey.zip > > > Add support in Designer for foreign keys cross models. > In Designer you cannot have a FK cross models. That is not a limitation with DDL metadata in Teiid. It's a misstatement to relate that to optimization. If the PK/FK is present we'll use that information just as we would in a single source - we do not however enforce the FK. That can be done through the use of an update procedure though. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3050) Non working checkboxes in Index after Export/Import

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3050?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-3050: ------------------------------------------ The index is a constraint. It can also support an expression list, not just columns, but that is mainly for function based indexes with materialized views. We treat unique as a different constraint type: https://teiid.gitbooks.io/documents/content/reference/BNF_for_SQL_Grammar... > Non working checkboxes in Index after Export/Import > ---------------------------------------------------- > > Key: TEIIDDES-3050 > URL: https://issues.jboss.org/browse/TEIIDDES-3050 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 11.0.1 > Reporter: Mario Majernik > Assignee: Barry LaFond > Fix For: 11.0.2 > > Attachments: IndexCheckboxes.zip > > > Checkboxes "Unique" , "Nullable" and "Auto Update" is false. All should be true. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3050) Non working checkboxes in Index after Export/Import

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3050?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3050: ---------------------------------------- [~shawkins] TEIIDDES-3050 and TEIIDDES-3024 are related to INDEX properties and DDL import/export. .Are there any OPTIONS used/supported by Teiid runtime for INDEX constraints? > Non working checkboxes in Index after Export/Import > ---------------------------------------------------- > > Key: TEIIDDES-3050 > URL: https://issues.jboss.org/browse/TEIIDDES-3050 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 11.0.1 > Reporter: Mario Majernik > Assignee: Barry LaFond > Fix For: 11.0.2 > > Attachments: IndexCheckboxes.zip > > > Checkboxes "Unique" , "Nullable" and "Auto Update" is false. All should be true. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3037) Allow VDB user defined properties to have underscore(_) or period in the name

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3037?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-3037. ------------------------------------ Resolution: Done 11.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/d32f982f3512fe216... added '.' and '_' as valid chars > Allow VDB user defined properties to have underscore(_) or period in the name > ----------------------------------------------------------------------------- > > Key: TEIIDDES-3037 > URL: https://issues.jboss.org/browse/TEIIDDES-3037 > Project: Teiid Designer > Issue Type: Bug > Reporter: Chandra Akkinepalli > Assignee: Barry LaFond > Fix For: 11.0.2 > > > VDB's userdefined properties doesn't allow Names containing underscore in them. > Our naming standards are defined to have _ in them. This is preventing us from doing a update via designer. As a work around we are udpating vdb.xml file within .vdb in an offline manner. > It would would be great if this restriction can be removed -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3037) Allow VDB user defined properties to have underscore(_) or period in the name

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3037?page=com.atlassian.jira.plu... ] Van Halbert updated TEIIDDES-3037: ---------------------------------- Summary: Allow VDB user defined properties to have underscore(_) or period in the name (was: Allow VDB user defined properties to have underscore(_) in the name) > Allow VDB user defined properties to have underscore(_) or period in the name > ----------------------------------------------------------------------------- > > Key: TEIIDDES-3037 > URL: https://issues.jboss.org/browse/TEIIDDES-3037 > Project: Teiid Designer > Issue Type: Bug > Reporter: Chandra Akkinepalli > Assignee: Barry LaFond > Fix For: 11.0.2 > > > VDB's userdefined properties doesn't allow Names containing underscore in them. > Our naming standards are defined to have _ in them. This is preventing us from doing a update via designer. As a work around we are udpating vdb.xml file within .vdb in an offline manner. > It would would be great if this restriction can be removed -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3037) Allow VDB user defined properties to have underscore(_) in the name

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3037?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-3037: --------------------------------------- Also need to enable using a period in the names. An example is: {code} <property name="connection.partialResultsMode" value="true" /> {code} which are the Teiid VDB properties found here: https://teiid.gitbooks.io/documents/content/reference/vdb_properties.html > Allow VDB user defined properties to have underscore(_) in the name > ------------------------------------------------------------------- > > Key: TEIIDDES-3037 > URL: https://issues.jboss.org/browse/TEIIDDES-3037 > Project: Teiid Designer > Issue Type: Bug > Reporter: Chandra Akkinepalli > Assignee: Barry LaFond > Priority: Minor > Fix For: 11.0.2 > > > VDB's userdefined properties doesn't allow Names containing underscore in them. > Our naming standards are defined to have _ in them. This is preventing us from doing a update via designer. As a work around we are udpating vdb.xml file within .vdb in an offline manner. > It would would be great if this restriction can be removed -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3037) Allow VDB user defined properties to have underscore(_) in the name

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3037?page=com.atlassian.jira.plu... ] Van Halbert updated TEIIDDES-3037: ---------------------------------- Priority: Major (was: Minor) > Allow VDB user defined properties to have underscore(_) in the name > ------------------------------------------------------------------- > > Key: TEIIDDES-3037 > URL: https://issues.jboss.org/browse/TEIIDDES-3037 > Project: Teiid Designer > Issue Type: Bug > Reporter: Chandra Akkinepalli > Assignee: Barry LaFond > Fix For: 11.0.2 > > > VDB's userdefined properties doesn't allow Names containing underscore in them. > Our naming standards are defined to have _ in them. This is preventing us from doing a update via designer. As a work around we are udpating vdb.xml file within .vdb in an offline manner. > It would would be great if this restriction can be removed -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3015) Importing Flat File with "-" character in one column of the header

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3015?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3015: ---------------------------------------- So the problem is in the missing double-quotes for the column. This needs to get checked on import and then wrap the name in d-quotes. The resulting generated SQL should be: {code} SELECT "a-a" AS """a-a""", b FROM (EXEC SourceModel.getTextFiles('test.csv')) AS f, TEXTTABLE(file COLUMNS "a-a" string, b string HEADER) AS A {code} > Importing Flat File with "-" character in one column of the header > ------------------------------------------------------------------- > > Key: TEIIDDES-3015 > URL: https://issues.jboss.org/browse/TEIIDDES-3015 > Project: Teiid Designer > Issue Type: Bug > Environment: CentOs 7 + Teiid 9.1.2 with Wildfly 10.0.0.Final + Eclipse Neon with Designer 11. > Reporter: Pedro Inácio > Fix For: 11.0.2 > > > Trying to create a simple Flat File View Model from aCSV file with the following content: > {code:java} > "a-a","b" > 1,2 > 3,4 > {code} > Teiid server gives the following exception > {noformat} > [org.teiid.RUNTIME] (Worker6_async-teiid-threads6) TEIID50036 VDB PREVIEW-80ce0d21-f22d-431f-bd12-89ac57ac9418.1 model "ViewModel" metadata failed to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a[*]-[*]a string" at line 3, column 10. > Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...: org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a[*]-[*]a string" at line 3, column 10. > Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ... > at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:472) > at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:798) > at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:40) > at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:84) > at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) > at org.teiid.jboss.VDBService$6.run(VDBService.java:360) > at org.teiid.jboss.VDBService$7.run(VDBService.java:411) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "new_table ( a[*]-[*]a string" at line 3, column 10. > Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ... > at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:214) > ... 13 more > {noformat} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3042) Error during import DDL which contains udf function

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3042?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-3042. ------------------------------------ Resolution: Done 11.0.x: https://github.com/Teiid-Designer/teiid-designer/compare/cbbbbedf2a1d...d... > Error during import DDL which contains udf function > ---------------------------------------------------- > > Key: TEIIDDES-3042 > URL: https://issues.jboss.org/browse/TEIIDDES-3042 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Import/Export > Affects Versions: 10.0.2 > Reporter: Matej Kralik > Assignee: Barry LaFond > Fix For: 11.0.2 > > Attachments: screenshot1.png, udfProject.zip > > > I have DDL file with models which contains udf function. I want to import it but the designer shows me this error: > "Expected argument to be non-null but got null" > Error log doesn't contain any error. > The same issue is when I want to generate "models and VDB" from dynamic VDB. > It works correctly on the last version of the Teiid Designer. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3065) VDB Export to Import problem

by Steve Tran (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3065?page=com.atlassian.jira.plu... ] Steve Tran updated TEIIDDES-3065: --------------------------------- Attachment: (was: HostSettlement-vdb.xml) > VDB Export to Import problem > ---------------------------- > > Key: TEIIDDES-3065 > URL: https://issues.jboss.org/browse/TEIIDDES-3065 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 10.1 > Environment: Windows 7 > JBoss Developer Studio 10.3.0.GA > Teiid Designer 10.1.0.GA > Reporter: Steve Tran > Attachments: Screenshot from 2017-03-21 13-29-38.png > > > I exported my VDB as a dynamic VDB file, then I attempted to re-import it but got an error message. > {code} > The message says "Unparsable table body". > !ENTRY org.teiid.designer.vdb 4 4 2017-03-21 13:28:40.629 > !MESSAGE An exception occurred while performing a VDB operation > !SUBENTRY 1 org.teiid.designer.vdb 4 0 2017-03-21 13:28:40.629 > !MESSAGE * Error Message: Unparsable table body > Error Line Number: 323 > Error Column Number: 42 > Error Index: 29455 > !ENTRY org.teiid.designer.vdb 4 4 2017-03-21 13:28:48.784 > !MESSAGE An exception occurred while performing a VDB operation > !SUBENTRY 1 org.teiid.designer.vdb 4 0 2017-03-21 13:28:48.784 > !MESSAGE * Error Message: Unparsable table body > Error Line Number: 323 > Error Column Number: 42 > Error Index: 29455 > !ENTRY org.teiid.designer.vdb 4 4 2017-03-21 13:35:15.660 > !MESSAGE An exception occurred while performing a VDB operation > !SUBENTRY 1 org.teiid.designer.vdb 4 0 2017-03-21 13:35:15.660 > !MESSAGE * Error Message: Unparsable table body > Error Line Number: 323 > Error Column Number: 42 > Error Index: 29455 > {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 11 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues March 2017