July 2016 - teiid-designer-issues

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

by Matus Makovy (JIRA)

Matus Makovy created TEIIDDES-2880: -------------------------------------- Summary: 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 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. View model attached -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2832) Unable to preview imported SF model

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2832?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-2832. ---------------------------------- > Unable to preview imported SF model > ----------------------------------- > > Key: TEIIDDES-2832 > URL: https://issues.jboss.org/browse/TEIIDDES-2832 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 10.0 > Reporter: Mark Drilling > Assignee: Barry LaFond > Labels: verified_jbdsis-9.0.1 > Fix For: 10.0.1 > > Attachments: server.log > > > Import from salesforce using SF importer, then attempt to preview Account table, results in the attached server.log exception. > The dynamic VDB content: > <vdb name="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9" version="1"> > <description>Importer VDB</description> > <property name="UseConnectorMetadata" value="true" /> > <property name="deployment-name" value="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9-vdb.xml" /> > <model name="SFModel" type="PHYSICAL" visible="true"> > <source name="SFModel" translator-name="salesforce" connection-jndi-name="null" /> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE Account ( > Id string(18) NOT NULL OPTIONS(NAMEINSOURCE 'Id', NATIVE_TYPE 'id', "teiid_sf:Defaulted on Create" 'TRUE'), -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2832) Unable to preview imported SF model

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2832?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-2832: ----------------------------------- Labels: verified_jbdsis-9.0.1 (was: ) > Unable to preview imported SF model > ----------------------------------- > > Key: TEIIDDES-2832 > URL: https://issues.jboss.org/browse/TEIIDDES-2832 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 10.0 > Reporter: Mark Drilling > Assignee: Barry LaFond > Labels: verified_jbdsis-9.0.1 > Fix For: 10.0.1 > > Attachments: server.log > > > Import from salesforce using SF importer, then attempt to preview Account table, results in the attached server.log exception. > The dynamic VDB content: > <vdb name="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9" version="1"> > <description>Importer VDB</description> > <property name="UseConnectorMetadata" value="true" /> > <property name="deployment-name" value="PREVIEW-f118338c-1837-4973-ae81-61092ac55eb9-vdb.xml" /> > <model name="SFModel" type="PHYSICAL" visible="true"> > <source name="SFModel" translator-name="salesforce" connection-jndi-name="null" /> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE Account ( > Id string(18) NOT NULL OPTIONS(NAMEINSOURCE 'Id', NATIVE_TYPE 'id', "teiid_sf:Defaulted on Create" 'TRUE'), -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2729) Bad export of carriage return in SQL transformation

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2729?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-2729: ----------------------------------- Labels: release_notes verified_jbdsis-9.0.1 (was: ) > Bad export of carriage return in SQL transformation > --------------------------------------------------- > > Key: TEIIDDES-2729 > URL: https://issues.jboss.org/browse/TEIIDDES-2729 > Project: Teiid Designer > Issue Type: Bug > Components: Patch Release, Transformations > Affects Versions: 9.2 > Environment: Eclipse 4.4.2 > Teiid Designer 9.2.0.Final-v20151028-1427-B4011 > Windows 7 Enterprise 64-bit > Reporter: Jean-Pierre Matsumoto > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.1 > Fix For: 10.0 > > Attachments: error.png, SimpleOracle.zip, sql.txt, TEIIDDES-2729-fix.patch > > > Carriage returns characters makes errors with export + import SQL. > Can be related to TEIIDDES-735. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2729) Bad export of carriage return in SQL transformation

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2729?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-2729. ---------------------------------- When I pasted sql to the transformation editor (step 3.3), the editor still shows "ERROR:Error in parsing of sql - null". [(TEIIDDES-2782)|https://issues.jboss.org/browse/TEIIDDES-2782]. Anyway, I exported sql (exported file contains \r) and that imported it back, sql was same as before and the designer didn't show the error. Because of that, I close this bug. > Bad export of carriage return in SQL transformation > --------------------------------------------------- > > Key: TEIIDDES-2729 > URL: https://issues.jboss.org/browse/TEIIDDES-2729 > Project: Teiid Designer > Issue Type: Bug > Components: Patch Release, Transformations > Affects Versions: 9.2 > Environment: Eclipse 4.4.2 > Teiid Designer 9.2.0.Final-v20151028-1427-B4011 > Windows 7 Enterprise 64-bit > Reporter: Jean-Pierre Matsumoto > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.1 > Fix For: 10.0 > > Attachments: error.png, SimpleOracle.zip, sql.txt, TEIIDDES-2729-fix.patch > > > Carriage returns characters makes errors with export + import SQL. > Can be related to TEIIDDES-735. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2782) Copy paste sql to the transformation editor is not parsable

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2782?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-2782: ----------------------------------- Priority: Major (was: Minor) > Copy paste sql to the transformation editor is not parsable > ----------------------------------------------------------- > > Key: TEIIDDES-2782 > URL: https://issues.jboss.org/browse/TEIIDDES-2782 > Project: Teiid Designer > Issue Type: Bug > Components: Editors, Transformations > Affects Versions: 10.0.1 > Environment: Windows 10 Pro N > Reporter: Matej Kralik > Attachments: XmlStagingProject.zip > > > When I copy a sql query from any source (notepad, web browser ...) and paste it to the transformation editor show me that "The query is not parsable.Error in parsing of sql - null ." > When I deleted all newlines from sql query or I wrote it myself to the editor, sql query was validated. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2768) Transform from Source Model" doesn't copy Descriptions to new view model

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2768?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-2768: ----------------------------------- Labels: release_notes verified_jbdsis-9.0.1 (was: release_notes verified_jbdsis-8.0.6) > Transform from Source Model" doesn't copy Descriptions to new view model > ------------------------------------------------------------------------ > > Key: TEIIDDES-2768 > URL: https://issues.jboss.org/browse/TEIIDDES-2768 > Project: Teiid Designer > Issue Type: Bug > Components: Migration, Patch Release, Transformations > Affects Versions: 9.0.3 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.1 > Fix For: 10.0, 9.0.6, 9.0.7 > > > When generating the View Model with Transform from the Source Model, the information in the Description of the Source Model is not copied to Description in the View Model -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2768) Transform from Source Model" doesn't copy Descriptions to new view model

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2768?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-2768. ---------------------------------- > Transform from Source Model" doesn't copy Descriptions to new view model > ------------------------------------------------------------------------ > > Key: TEIIDDES-2768 > URL: https://issues.jboss.org/browse/TEIIDDES-2768 > Project: Teiid Designer > Issue Type: Bug > Components: Migration, Patch Release, Transformations > Affects Versions: 9.0.3 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.1 > Fix For: 10.0, 9.0.6, 9.0.7 > > > When generating the View Model with Transform from the Source Model, the information in the Description of the Source Model is not copied to Description in the View Model -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2664) Add Model Extension support for Procedure RESULTS OPTIONS

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2664?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-2664: ----------------------------------- Labels: release_notes verified_jbdsis-9.0.1 (was: ) > Add Model Extension support for Procedure RESULTS OPTIONS > --------------------------------------------------------- > > Key: TEIIDDES-2664 > URL: https://issues.jboss.org/browse/TEIIDDES-2664 > Project: Teiid Designer > Issue Type: Enhancement > Components: ModeShape Integration, Patch Release, Teiid Integration > Reporter: Ramesh Reddy > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.1 > Fix For: 10.0, 9.2.1 > > Time Spent: 2 hours > Remaining Estimate: 0 minutes > > Teiid DDL now supports options for procedure/functions returns clause parameters: > ... RETURNS (options ...) type > ... RETURNS (options ...) TABLE (...) > This was added to Teiid version 8.12 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2664) Add Model Extension support for Procedure RESULTS OPTIONS

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2664?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-2664. ---------------------------------- > Add Model Extension support for Procedure RESULTS OPTIONS > --------------------------------------------------------- > > Key: TEIIDDES-2664 > URL: https://issues.jboss.org/browse/TEIIDDES-2664 > Project: Teiid Designer > Issue Type: Enhancement > Components: ModeShape Integration, Patch Release, Teiid Integration > Reporter: Ramesh Reddy > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.1 > Fix For: 10.0, 9.2.1 > > Time Spent: 2 hours > Remaining Estimate: 0 minutes > > Teiid DDL now supports options for procedure/functions returns clause parameters: > ... RETURNS (options ...) type > ... RETURNS (options ...) TABLE (...) > This was added to Teiid version 8.12 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 9 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 July 2016