June 2017 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2985) Missing Procedure settings in dynamic VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2985?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2985: ----------------------------------- Fix Version/s: 11.0.2 > Missing Procedure settings in dynamic VDB > ----------------------------------------- > > Key: TEIIDDES-2985 > URL: https://issues.jboss.org/browse/TEIIDDES-2985 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Import/Export > Affects Versions: 10.0.2 > Reporter: Mario Majernik > Fix For: 11.0.2 > > Attachments: DynamicVDBtesting.zip > > > Some setting in source model miss after generate source model from dynamic vdb: > * Value of Function is false for "Function"(should be true) > * Value of Update Count is always AUTO(should be ONE for procedure) > * Name is Source for parameters missing > * Value of Name was newParameter_2 for second parameter in Procedure. After generating from dynamic vdb name is result. I think that is caused direction for this parameter which was set on RETURN. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3040) Source function in a virtual view, it expects an Object type as the result

by Debbie Steigner (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3040?page=com.atlassian.jira.plu... ] Debbie Steigner commented on TEIIDDES-3040: ------------------------------------------- [~blafond] so this will be fixed in 11.0.2, is there an eta on that release? > Source function in a virtual view, it expects an Object type as the result > -------------------------------------------------------------------------- > > Key: TEIIDDES-3040 > URL: https://issues.jboss.org/browse/TEIIDDES-3040 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.2 > Reporter: Colin Mondesir > Assignee: Barry LaFond > Fix For: 11.0.2 > > Attachments: example.zip > > > On a physical model, I have created a Source Function INSTR with the following parameters: > IN char1 string > IN char2 string > RETURN result Integer > When I use this source function in a virtual view, it expects an Object type as the result of this function. No way to force with an Integer type. So I create an Object column to store this result. But then I create a VDB and I want to deploy it, it tells me that it expects a Integer result and not an Object. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3040) Source function in a virtual view, it expects an Object type as the result

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3040?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3040: ---------------------------------------- [~dsteigne] Because Designer's relational procedure definition and use of IN/OUT/INOUT/RESULT directions do not directly match up with Teiid DDL and SQL engine..... there were missing pieces in the data type resolving for element symbols that were defined by a Function. I've found and fixed both our SQL editing resolving and datatype resolving in our transformation validation. > Source function in a virtual view, it expects an Object type as the result > -------------------------------------------------------------------------- > > Key: TEIIDDES-3040 > URL: https://issues.jboss.org/browse/TEIIDDES-3040 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.2 > Reporter: Colin Mondesir > Assignee: Barry LaFond > Fix For: 11.0.2 > > Attachments: example.zip > > > On a physical model, I have created a Source Function INSTR with the following parameters: > IN char1 string > IN char2 string > RETURN result Integer > When I use this source function in a virtual view, it expects an Object type as the result of this function. No way to force with an Integer type. So I create an Object column to store this result. But then I create a VDB and I want to deploy it, it tells me that it expects a Integer result and not an Object. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3040) Source function in a virtual view, it expects an Object type as the result

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3040?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3040: ---------------------------------------- I tested a dynamic VDB generated in Designer and it logged this error: The function 'DV_QE_ORACLE11_DS.instr(DV_QE_ORACLE11_DS.SMALLA.STRINGKEY, '2')' is an unknown form. Check that the function name and number of arguments is correct. I think this is a current/related bug I can fix. I also deployed both the SampleVDB-vdb.xml and SampleVDB.vdb and both deployed without error. There have been a number of issues fixed around VDB.xml and some around our procedure definitions, so hopefully this will be fixed in next patch, 11.0.2 > Source function in a virtual view, it expects an Object type as the result > -------------------------------------------------------------------------- > > Key: TEIIDDES-3040 > URL: https://issues.jboss.org/browse/TEIIDDES-3040 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.2 > Reporter: Colin Mondesir > Assignee: Barry LaFond > Fix For: 11.0.2 > > Attachments: example.zip > > > On a physical model, I have created a Source Function INSTR with the following parameters: > IN char1 string > IN char2 string > RETURN result Integer > When I use this source function in a virtual view, it expects an Object type as the result of this function. No way to force with an Integer type. So I create an Object column to store this result. But then I create a VDB and I want to deploy it, it tells me that it expects a Integer result and not an Object. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3040) Source function in a virtual view, it expects an Object type as the result

by Debbie Steigner (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3040?page=com.atlassian.jira.plu... ] Debbie Steigner commented on TEIIDDES-3040: ------------------------------------------- [~blafond] any updates on this issue? > Source function in a virtual view, it expects an Object type as the result > -------------------------------------------------------------------------- > > Key: TEIIDDES-3040 > URL: https://issues.jboss.org/browse/TEIIDDES-3040 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.2 > Reporter: Colin Mondesir > Assignee: Barry LaFond > Fix For: 11.0.2 > > Attachments: example.zip > > > On a physical model, I have created a Source Function INSTR with the following parameters: > IN char1 string > IN char2 string > RETURN result Integer > When I use this source function in a virtual view, it expects an Object type as the result of this function. No way to force with an Integer type. So I create an Object column to store this result. But then I create a VDB and I want to deploy it, it tells me that it expects a Integer result and not an Object. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3084) Support modeling of a JDG 7.1 data source using new translator/connector

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3084?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-3084: ---------------------------------------- By default type is "NATIVE", but may be the combination of it with "DDL" and ordering of these types in the XML file is what may be causing issues. > Support modeling of a JDG 7.1 data source using new translator/connector > ------------------------------------------------------------------------ > > Key: TEIIDDES-3084 > URL: https://issues.jboss.org/browse/TEIIDDES-3084 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling > Reporter: Van Halbert > > Add the ability to model a JDG 7.1 data source using new Teiid connector/translator -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3085) Importer is not setting Name In Source for salesforce relationship name

by Debbie Steigner (JIRA)

Debbie Steigner created TEIIDDES-3085: ----------------------------------------- Summary: Importer is not setting Name In Source for salesforce relationship name Key: TEIIDDES-3085 URL: https://issues.jboss.org/browse/TEIIDDES-3085 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 11.0.1 Reporter: Debbie Steigner Assignee: Barry LaFond Salesforce importer doesn't set Name in Source for relationship name. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3084) Support modeling of a JDG 7.1 data source using new translator/connector

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3084?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-3084: --------------------------------------- It doesn't. I think part of the problem is the vdb that teiid designer creates in order to get the metadata doesn't contain the following NATIVE tag: {code} <metadata type = "NATIVE"/> {code} > Support modeling of a JDG 7.1 data source using new translator/connector > ------------------------------------------------------------------------ > > Key: TEIIDDES-3084 > URL: https://issues.jboss.org/browse/TEIIDDES-3084 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling > Reporter: Van Halbert > > Add the ability to model a JDG 7.1 data source using new Teiid connector/translator -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3084) Support modeling of a JDG 7.1 data source using new translator/connector

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3084?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-3084: ---------------------------------------- Teiid Connection Importer should work with this as designed. > Support modeling of a JDG 7.1 data source using new translator/connector > ------------------------------------------------------------------------ > > Key: TEIIDDES-3084 > URL: https://issues.jboss.org/browse/TEIIDDES-3084 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling > Reporter: Van Halbert > > Add the ability to model a JDG 7.1 data source using new Teiid connector/translator -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3084) Support modeling of a JDG 7.1 data source using new translator/connector

by Van Halbert (JIRA)

Van Halbert created TEIIDDES-3084: ------------------------------------- Summary: Support modeling of a JDG 7.1 data source using new translator/connector Key: TEIIDDES-3084 URL: https://issues.jboss.org/browse/TEIIDDES-3084 Project: Teiid Designer Issue Type: Enhancement Components: Modeling Reporter: Van Halbert Add the ability to model a JDG 7.1 data source using new Teiid connector/translator -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues June 2017