February 2017 - teiid-designer-issues

[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 commented on TEIIDDES-3042: ---------------------------------------- This is a one line fix .. a null check and the use case is importing a procedure that doesn't have a Result Set in it... like with a UDF > 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 > 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, 2 months

1
0
0 / 0

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

by Matej Kralik (JIRA)

Matej Kralik created TEIIDDES-3042: -------------------------------------- Summary: 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 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, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2589) The model extension definition "relational" found in model is a different version than the one in the registry.

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2589?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2589. ---------------------------------- Ok, I am closing this JIRA and the last issue from this bug report will be solved in TEIIDDES-3041. > The model extension definition "relational" found in model is a different version than the one in the registry. > --------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2589 > URL: https://issues.jboss.org/browse/TEIIDDES-2589 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 9.0, 9.0.1, 9.1, 9.0.2 > Reporter: Lukas Mro > Assignee: Barry LaFond > Fix For: 10.0, 9.2.1, 11.0.1 > > > After importing model from TD 8.1.0 to 9.X.X two types of errors occures > 3 types of errors occures: > 1. The model extension definition "rest" found in model is not registered in workspace -> this one can be autofix > 2. The model extension definition "relational" found in model is a different version than the one in the registry -> This one do not have fix > 3. java.lang.StringIndexOutOfBoundsException: String index out of range: 1 > -> this one do not have fix > I`m not sure what should i send you, AMA :) -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2621) Support for array datatype

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2621?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-2621: ------------------------------------------ For index metadata we'll need the column runtime type to include the array glyph - integer[][] Support for this was added to the runtime with TEIID-4776 > Support for array datatype > -------------------------- > > Key: TEIIDDES-2621 > URL: https://issues.jboss.org/browse/TEIIDDES-2621 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling > Affects Versions: 9.1, 9.0.3 > Reporter: Andrej Šmigala > Fix For: 11.1 > > > Teiid [supports array as a column datatype|https://docs.jboss.org/author/display/teiid87final/BNF+for+SQL+G...]. Add the ability to create models with array datatypes. > This should also include correct parsing of teiid ddl with array constructs. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2185) Update the States Web Service Example

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2185?page=com.atlassian.jira.plu... ] Ted Jones commented on TEIIDDES-2185: ------------------------------------- Thanks [~mmakovy] > Update the States Web Service Example > ------------------------------------- > > Key: TEIIDDES-2185 > URL: https://issues.jboss.org/browse/TEIIDDES-2185 > Project: Teiid Designer > Issue Type: Task > Components: Patch Release, Web Services Support > Affects Versions: 8.3.2 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 11.0.1 > > Attachments: StateServiceExampleFull.zip > > > The States Web Service example is missing the "stream" parameter in the invoke() procedure. Need to recreate to include this parameter. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2880) New preview not working with table that calls UDF function

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2880?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2880: ---------------------------------------- There may be a way to deploy the UDF jar to the server by Designer. We do auto-deploy JDBC drivers if required for creating data sources, so maybe the process would be the same. > New preview not working with table that calls UDF function > ----------------------------------------------------------- > > Key: TEIIDDES-2880 > URL: https://issues.jboss.org/browse/TEIIDDES-2880 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.1 > Environment: MAC > Reporter: Matus Makovy > Fix For: 11.0.2 > > Attachments: view.xmi > > > I have a view model with UDF function defined as procedure and a table that uses this UDF procedure. Transformation SQL looks like this: > {code:SQL} > SELECT > udfConcatNull(hsqldbParts.PARTS.PART_NAME, hsqldbParts.PARTS.PART_WEIGHT) AS NAME_WEIGHT > FROM > hsqldbParts.PARTS > {code} > When I hit Preview Data on that table, the dynamic VDB that is generated looks like this: > {code:xml} > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <vdb name="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7" version="1"> > <description>Importer VDB</description> > <property name="UseConnectorMetadata" value="true" /> > <property name="deployment-name" value="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7-vdb.xml" /> > <model name="view" type="VIRTUAL" visible="true"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW tab ( > NAME_WEIGHT string > ) > AS > select udfConcatNull(hsqldbParts.PARTS.PART_NAME,hsqldbParts.PARTS.PART_WEIGHT) as NAME_WEIGHT from hsqldbParts.PARTS; > ]]></metadata> > </model> > <model name="hsqldbParts" type="PHYSICAL" visible="true"> > <source name="hsqldbParts" translator-name="oracle" connection-jndi-name="null" /> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE PARTS ( > PART_ID string(4) NOT NULL OPTIONS(NAMEINSOURCE '"PART_ID"', NATIVE_TYPE 'CHAR', FIXED_LENGTH 'TRUE'), > PART_NAME string(255) OPTIONS(NAMEINSOURCE '"PART_NAME"', NATIVE_TYPE 'VARCHAR2'), > PART_COLOR string(30) OPTIONS(NAMEINSOURCE '"PART_COLOR"', NATIVE_TYPE 'VARCHAR2'), > PART_WEIGHT string(255) OPTIONS(NAMEINSOURCE '"PART_WEIGHT"', NATIVE_TYPE 'VARCHAR2'), > CONSTRAINT PK_PARTS PRIMARY KEY(PART_ID) > ) OPTIONS(NAMEINSOURCE '"PARTSSUPPLIER"."PARTS"') > ]]></metadata> > </model> > </vdb> > {code} > If I see correctly, the UDF procedure is not in the dynamic VDB. > I know that the situation about dynamic VDBs and UDF functions in JAR files is complicated and I am not sure right now how this should be resolved. > But in my opinion the udf procedure should be in the dynamic VDB and there should be a warning that TD won't deploy the JAR to the server and if user wants to make a preview, the JAR should be deployed to the server manually. (If I remember correctly there is one when user is trying to generate dynamic VDB from static VDB with UDF function) > View model attached -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2880) New preview not working with table that calls UDF function

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2880?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2880: ----------------------------------- Fix Version/s: 11.0.2 > New preview not working with table that calls UDF function > ----------------------------------------------------------- > > Key: TEIIDDES-2880 > URL: https://issues.jboss.org/browse/TEIIDDES-2880 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.1 > Environment: MAC > Reporter: Matus Makovy > Fix For: 11.0.2 > > Attachments: view.xmi > > > I have a view model with UDF function defined as procedure and a table that uses this UDF procedure. Transformation SQL looks like this: > {code:SQL} > SELECT > udfConcatNull(hsqldbParts.PARTS.PART_NAME, hsqldbParts.PARTS.PART_WEIGHT) AS NAME_WEIGHT > FROM > hsqldbParts.PARTS > {code} > When I hit Preview Data on that table, the dynamic VDB that is generated looks like this: > {code:xml} > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <vdb name="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7" version="1"> > <description>Importer VDB</description> > <property name="UseConnectorMetadata" value="true" /> > <property name="deployment-name" value="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7-vdb.xml" /> > <model name="view" type="VIRTUAL" visible="true"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW tab ( > NAME_WEIGHT string > ) > AS > select udfConcatNull(hsqldbParts.PARTS.PART_NAME,hsqldbParts.PARTS.PART_WEIGHT) as NAME_WEIGHT from hsqldbParts.PARTS; > ]]></metadata> > </model> > <model name="hsqldbParts" type="PHYSICAL" visible="true"> > <source name="hsqldbParts" translator-name="oracle" connection-jndi-name="null" /> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE PARTS ( > PART_ID string(4) NOT NULL OPTIONS(NAMEINSOURCE '"PART_ID"', NATIVE_TYPE 'CHAR', FIXED_LENGTH 'TRUE'), > PART_NAME string(255) OPTIONS(NAMEINSOURCE '"PART_NAME"', NATIVE_TYPE 'VARCHAR2'), > PART_COLOR string(30) OPTIONS(NAMEINSOURCE '"PART_COLOR"', NATIVE_TYPE 'VARCHAR2'), > PART_WEIGHT string(255) OPTIONS(NAMEINSOURCE '"PART_WEIGHT"', NATIVE_TYPE 'VARCHAR2'), > CONSTRAINT PK_PARTS PRIMARY KEY(PART_ID) > ) OPTIONS(NAMEINSOURCE '"PARTSSUPPLIER"."PARTS"') > ]]></metadata> > </model> > </vdb> > {code} > If I see correctly, the UDF procedure is not in the dynamic VDB. > I know that the situation about dynamic VDBs and UDF functions in JAR files is complicated and I am not sure right now how this should be resolved. > But in my opinion the udf procedure should be in the dynamic VDB and there should be a warning that TD won't deploy the JAR to the server and if user wants to make a preview, the JAR should be deployed to the server manually. (If I remember correctly there is one when user is trying to generate dynamic VDB from static VDB with UDF function) > View model attached -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2940) Moving model out of folder breaks imports

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2940?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2940: ----------------------------------- Fix Version/s: 11.0.2 > Moving model out of folder breaks imports > ----------------------------------------- > > Key: TEIIDDES-2940 > URL: https://issues.jboss.org/browse/TEIIDDES-2940 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.2 > Environment: Windows 7, Windows 8 > Reporter: Matus Makovy > Fix For: 11.0.2 > > Attachments: Screen Shot 2016-10-18 at 14.45.03.png > > > After I move (for example) from folder directly into project folder the imports on view model (that depends on this model) break. > This happens only on win 7 and 8. > See attached screenshot -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2185) Update the States Web Service Example

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2185?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-2185: ---------------------------------------- Sorry I didn't notice that I can update the example by myself. I replaced the archive at jboss.org. Marking this as closed. > Update the States Web Service Example > ------------------------------------- > > Key: TEIIDDES-2185 > URL: https://issues.jboss.org/browse/TEIIDDES-2185 > Project: Teiid Designer > Issue Type: Task > Components: Patch Release, Web Services Support > Affects Versions: 8.3.2 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 11.0.1 > > Attachments: StateServiceExampleFull.zip > > > The States Web Service example is missing the "stream" parameter in the invoke() procedure. Need to recreate to include this parameter. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2185) Update the States Web Service Example

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2185?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2185. ---------------------------------- > Update the States Web Service Example > ------------------------------------- > > Key: TEIIDDES-2185 > URL: https://issues.jboss.org/browse/TEIIDDES-2185 > Project: Teiid Designer > Issue Type: Task > Components: Patch Release, Web Services Support > Affects Versions: 8.3.2 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 11.0.1 > > Attachments: StateServiceExampleFull.zip > > > The States Web Service example is missing the "stream" parameter in the invoke() procedure. Need to recreate to include this parameter. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues February 2017