October 2015 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2682) Importing Teiid DDL and selecting wrong model type results in error

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2682?page=com.atlassian.jira.plu... ] RH Bugzilla Integration updated TEIIDDES-2682: ---------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1270793 Bugzilla Update: Perform > Importing Teiid DDL and selecting wrong model type results in error > ------------------------------------------------------------------- > > Key: TEIIDDES-2682 > URL: https://issues.jboss.org/browse/TEIIDDES-2682 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0.4 > Environment: MAC OS > Reporter: Matus Makovy > Attachments: Screen Shot 2015-10-12 at 13.32.49.png, view.ddl > > > When you import Teiid DDL that was created as export from VIEW MODEL and you select SOURCE MODEL during the import, this process results in error dialogue that is not really helpful for user. (see screenshot) > I think the error message should be more accurate -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2682) Importing Teiid DDL and selecting wrong model type results in error

by Matus Makovy (JIRA)

Matus Makovy created TEIIDDES-2682: -------------------------------------- Summary: Importing Teiid DDL and selecting wrong model type results in error Key: TEIIDDES-2682 URL: https://issues.jboss.org/browse/TEIIDDES-2682 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 9.0.4 Environment: MAC OS Reporter: Matus Makovy Attachments: Screen Shot 2015-10-12 at 13.32.49.png, view.ddl When you import Teiid DDL that was created as export from VIEW MODEL and you select SOURCE MODEL during the import, this process results in error dialogue that is not really helpful for user. (see screenshot) I think the error message should be more accurate -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2681) Cannot export Teiid DDL

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2681?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2681: ----------------------------------- Workaround Description: 2 options: 1.) Copy Teiid DDL when it is displayed during the wizard and save it to file manually. 2.) Hit "Export to workspace" button, specify a folder and name for ddl file and TD exports ddl into project was:Copy Teiid DDL when it is displayed during the wizard and save it to file manually. > Cannot export Teiid DDL > ----------------------- > > Key: TEIIDDES-2681 > URL: https://issues.jboss.org/browse/TEIIDDES-2681 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0.4 > Environment: MAC OS > Reporter: Matus Makovy > Assignee: Barry LaFond > Priority: Critical > Attachments: Screen Shot 2015-10-08 at 15.14.38.png > > > I can not export any model to Teiid DDL. > See steps to reproduce and attached screenshot of the last page of export wizard. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2500) Problems with model created via import from Salesforce when using JOIN query

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2500?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2500. ---------------------------------- Not able to reproduce anymore > Problems with model created via import from Salesforce when using JOIN query > ---------------------------------------------------------------------------- > > Key: TEIIDDES-2500 > URL: https://issues.jboss.org/browse/TEIIDDES-2500 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.1 > Reporter: Matus Makovy > Assignee: Mark Drilling > Fix For: 9.0.4, 9.2 > > Attachments: log, salesdynamic-vdb.xml, SalesforceTD.zip > > > Discovered this issue when trying to verify TEIID-3112 > I am trying to execute this query on VDB created via import from SalesForce in Teiid Designer. > {quote} > select distinct YEAR("Opportunity"."CloseDate") as "Opportunity_CloseDate1" from "SalesForceSource".salesforce.Campaign AS "Campaign" LEFT OUTER JOIN "SalesForceSource".salesforce.Opportunity AS "Opportunity" ON Campaign."Id" = Opportunity."CampaignId" order by YEAR("Opportunity"."CloseDate") ASC LIMIT 0 , 32 > {quote} > And I get this exception: > {quote} > org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidException: Invalid QName in mapping: sf:INVALID_TYPE > {quote} > Log attached > With dynamic VDB created manually or with import using Teiid Connection Importer via Designer everything works. > Project from Designer + dynamic VDB attached -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2647) Importing Teiid DDL with XML datatype ends up with object datatype

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2647?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2647. ---------------------------------- > Importing Teiid DDL with XML datatype ends up with object datatype > ------------------------------------------------------------------ > > Key: TEIIDDES-2647 > URL: https://issues.jboss.org/browse/TEIIDDES-2647 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, VDB & Execution > Affects Versions: 9.0.4, 9.2 > Reporter: Barry LaFond > Assignee: Barry LaFond > Priority: Critical > Labels: release_notes, verified_jbdsis-8.0.4.CR1 > Fix For: 9.0.4, 9.2 > > > Importing Teiid DDL with column entry: > columnA *xml* will end up with the *object* datatype > The TeiidDdlImporter needs to map *xml* to *XMLLiteral* -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2647) Importing Teiid DDL with XML datatype ends up with object datatype

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2647?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2647: ----------------------------------- Labels: release_notes verified_jbdsis-8.0.4.CR1 (was: ) > Importing Teiid DDL with XML datatype ends up with object datatype > ------------------------------------------------------------------ > > Key: TEIIDDES-2647 > URL: https://issues.jboss.org/browse/TEIIDDES-2647 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, VDB & Execution > Affects Versions: 9.0.4, 9.2 > Reporter: Barry LaFond > Assignee: Barry LaFond > Priority: Critical > Labels: release_notes, verified_jbdsis-8.0.4.CR1 > Fix For: 9.0.4, 9.2 > > > Importing Teiid DDL with column entry: > columnA *xml* will end up with the *object* datatype > The TeiidDdlImporter needs to map *xml* to *XMLLiteral* -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2458) Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database)

by Andrej Šmigala (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2458?page=com.atlassian.jira.plu... ] Andrej Šmigala commented on TEIIDDES-2458: ------------------------------------------ [~blafond], there is an additional issue here with current designer. The name in source for tables imported from sybase is currently e.g. bq. "bqt2"."SmallA" as stated in the original description. This does not work. [~jdurani] suggested in the original description that the name in source should be changed to bq. "bqt2"."dbo"."SmallA" This currently does not work either. The correct name in source is bq. bqt.dbo.SmallA i.e. without the quotes. Similarly, the name in source for columns is currently imported as e.g bq. "CharValue" which does not work, and should be bq. CharValue > Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database) > ------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2458 > URL: https://issues.jboss.org/browse/TEIIDDES-2458 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.1 > Environment: JBDS: 8.0.2GA > TD: 9.0.1.Final > OS: Fedora 20 > java: oracle 1.7 > JDBC driver: jconn4-26502 - jConnect (TM) for JDBC(TM)/7.00(Build 26502) > Sybase DB: ASE 15.0.3/EBF > Reporter: Juraj Duráni > Attachments: parts_sql_catalog_in_name_in_source.png, parts_sql_include_catalog_in_name.png, parts_sql_schema_tree.png, pic1.png, pic2.png, pic3.png, sybase_bqt2_datatools_tree.png > > > I am trying to import a Source model from Sybase database. But imported tables have wrong "name-in-source" property values. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2678) Cannot execute VDB which include UDF

by Paul Richardson (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2678?page=com.atlassian.jira.plu... ] Paul Richardson resolved TEIIDDES-2678. --------------------------------------- Resolution: Done Fixed. See [commit|https://github.com/Teiid-Designer/teiid-designer/commit/579c5f8dc9...] for details. > Cannot execute VDB which include UDF > ------------------------------------ > > Key: TEIIDDES-2678 > URL: https://issues.jboss.org/browse/TEIIDDES-2678 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 9.0.4 > Environment: Windows 7 64bit > Reporter: Matej Kralik > Assignee: Paul Richardson > Priority: Blocker > Fix For: 9.0.4, 9.2 > > Attachments: user-defined-function-example.zip, Windows 7.png, windowsUDF.zip > > > When I want execute VDB which include view Table with user define function, show me this dialog in the teiid designer : "Cannot execute VDB - still loading" and server show this stack trace: > {noformat} > ERROR [stderr] (teiid-async-threads - 1) Exception in thread "teiid-async-threads - 1" org.teiid.metadata.MetadataException: TEIID30387 Could not load UDF "ConcatNull", since its invocation class "userdefinedfunctions.ConcatNull" could not be found. > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:285) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at org.teiid.query.function.FunctionTree.addFunction(FunctionTree.java:190) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at org.teiid.query.function.FunctionTree.<init>(FunctionTree.java:91) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at org.teiid.deployers.CompositeVDB.buildTransformationMetaData(CompositeVDB.java:85) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:265) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:291) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:202) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at org.teiid.jboss.VDBService.access$1100(VDBService.java:85) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at org.teiid.jboss.VDBService$6.run(VDBService.java:411) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at org.teiid.jboss.VDBService$7.run(VDBService.java:442) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at java.lang.Thread.run(Thread.java:745) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at org.jboss.threads.JBossThread.run(JBossThread.java:122) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) Caused by: java.lang.ClassNotFoundException: userdefinedfunctions.ConcatNull from [Module "deployment.UdfVdb.vdb:main" from Service Module Loader] > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459) > 14:44:52,252 ERROR [stderr] (teiid-async-threads - 1) at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408) > 14:44:52,253 ERROR [stderr] (teiid-async-threads - 1) at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389) > 14:44:52,253 ERROR [stderr] (teiid-async-threads - 1) at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134) > 14:44:52,253 ERROR [stderr] (teiid-async-threads - 1) at java.lang.Class.forName0(Native Method) > 14:44:52,253 ERROR [stderr] (teiid-async-threads - 1) at java.lang.Class.forName(Class.java:348) > 14:44:52,253 ERROR [stderr] (teiid-async-threads - 1) at org.teiid.query.function.UDFSource.getInvocationClass(UDFSource.java:43) > 14:44:52,253 ERROR [stderr] (teiid-async-threads - 1) at org.teiid.query.function.FunctionTree.createFunctionDescriptor(FunctionTree.java:275) > 14:44:52,253 ERROR [stderr] (teiid-async-threads - 1) ... 13 more > {noformat} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2681) Cannot export Teiid DDL

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2681?page=com.atlassian.jira.plu... ] Van Halbert reassigned TEIIDDES-2681: ------------------------------------- Assignee: Barry LaFond > Cannot export Teiid DDL > ----------------------- > > Key: TEIIDDES-2681 > URL: https://issues.jboss.org/browse/TEIIDDES-2681 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0.4 > Environment: MAC OS > Reporter: Matus Makovy > Assignee: Barry LaFond > Priority: Critical > Attachments: Screen Shot 2015-10-08 at 15.14.38.png > > > I can not export any model to Teiid DDL. > See steps to reproduce and attached screenshot of the last page of export wizard. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1995) Add templates for OBJECTTABLE, TEXTABLE, etc

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1995?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-1995. ---------------------------------- OBJECTTABLE template is added. > Add templates for OBJECTTABLE, TEXTABLE, etc > -------------------------------------------- > > Key: TEIIDDES-1995 > URL: https://issues.jboss.org/browse/TEIIDDES-1995 > Project: Teiid Designer > Issue Type: Enhancement > Components: Transformations > Affects Versions: 8.4 > Reporter: Van Halbert > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-8.0.4.CR1 > Fix For: 9.0.4, 9.2 > > Attachments: select-object-table-sql-template.png > > > Add templates for using OBJECTTABLE, TEXTTABLE, etc. to the the list of templates to apply to the transformation. Example: > SELECT > o.{colname}, o.{colname} > FROM > {ObjectTableName} as T, > OBJECTTABLE('x' PASSING T.{ObjectColumnName}Object as x COLUMNS > {colname} type 'teiid_row.{colname}', ….) as o -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 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 October 2015