November 2015 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2728) Connection to remote DV server doesn't work

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2728?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-2728: ---------------------------------------- server version: DV 6.2 CR2 that means teiid 8.7.1.6_2-redhat-6 > Connection to remote DV server doesn't work > ------------------------------------------- > > Key: TEIIDDES-2728 > URL: https://issues.jboss.org/browse/TEIIDDES-2728 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.4 > Environment: MAC OS X > Reporter: Matus Makovy > Priority: Blocker > Attachments: Screen Shot 2015-11-16 at 16.40.27.png > > > I am not able to connect to remote DV server. > I get this exception: > ava.lang.IllegalArgumentException: admin > at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:302) > at org.teiid.runtime.client.admin.ExecutionAdmin.<init>(ExecutionAdmin.java:124) > at org.teiid.runtime.client.admin.ExecutionAdminFactory.createExecutionAdmin(ExecutionAdminFactory.java:53) > at org.teiid.designer.runtime.registry.TeiidRuntimeRegistry.getExecutionAdmin(TeiidRuntimeRegistry.java:90) > at org.teiid.designer.runtime.TeiidServer.connect(TeiidServer.java:224) > at org.teiid.designer.runtime.TeiidServer.reconnect(TeiidServer.java:274) > at org.teiid.designer.runtime.TeiidParentServerListener$1.tryConnecting(TeiidParentServerListener.java:242) > at org.teiid.designer.runtime.TeiidParentServerListener$1.run(TeiidParentServerListener.java:184) > at java.lang.Thread.run(Thread.java:745) > Discovered this issue on MAC OS with build TD 9.0.4.Final-v20151111... . I'll try to test this on Fedora. > This worked without problems with previous build. > Since this doesn't have a workaround I am marking it as a blocker. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2728) Connection to remote DV server doesn't work

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2728?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-2728: ---------------------------------------- Same behavior on Fedora > Connection to remote DV server doesn't work > ------------------------------------------- > > Key: TEIIDDES-2728 > URL: https://issues.jboss.org/browse/TEIIDDES-2728 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.4 > Environment: MAC OS X > Reporter: Matus Makovy > Priority: Blocker > Attachments: Screen Shot 2015-11-16 at 16.40.27.png > > > I am not able to connect to remote DV server. > I get this exception: > ava.lang.IllegalArgumentException: admin > at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:302) > at org.teiid.runtime.client.admin.ExecutionAdmin.<init>(ExecutionAdmin.java:124) > at org.teiid.runtime.client.admin.ExecutionAdminFactory.createExecutionAdmin(ExecutionAdminFactory.java:53) > at org.teiid.designer.runtime.registry.TeiidRuntimeRegistry.getExecutionAdmin(TeiidRuntimeRegistry.java:90) > at org.teiid.designer.runtime.TeiidServer.connect(TeiidServer.java:224) > at org.teiid.designer.runtime.TeiidServer.reconnect(TeiidServer.java:274) > at org.teiid.designer.runtime.TeiidParentServerListener$1.tryConnecting(TeiidParentServerListener.java:242) > at org.teiid.designer.runtime.TeiidParentServerListener$1.run(TeiidParentServerListener.java:184) > at java.lang.Thread.run(Thread.java:745) > Discovered this issue on MAC OS with build TD 9.0.4.Final-v20151111... . I'll try to test this on Fedora. > This worked without problems with previous build. > Since this doesn't have a workaround I am marking it as a blocker. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2728) Connection to remote DV server doesn't work

by Matus Makovy (JIRA)

Matus Makovy created TEIIDDES-2728: -------------------------------------- Summary: Connection to remote DV server doesn't work Key: TEIIDDES-2728 URL: https://issues.jboss.org/browse/TEIIDDES-2728 Project: Teiid Designer Issue Type: Bug Affects Versions: 9.0.4 Environment: MAC OS X Reporter: Matus Makovy Priority: Blocker Attachments: Screen Shot 2015-11-16 at 16.40.27.png I am not able to connect to remote DV server. I get this exception: ava.lang.IllegalArgumentException: admin at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:302) at org.teiid.runtime.client.admin.ExecutionAdmin.<init>(ExecutionAdmin.java:124) at org.teiid.runtime.client.admin.ExecutionAdminFactory.createExecutionAdmin(ExecutionAdminFactory.java:53) at org.teiid.designer.runtime.registry.TeiidRuntimeRegistry.getExecutionAdmin(TeiidRuntimeRegistry.java:90) at org.teiid.designer.runtime.TeiidServer.connect(TeiidServer.java:224) at org.teiid.designer.runtime.TeiidServer.reconnect(TeiidServer.java:274) at org.teiid.designer.runtime.TeiidParentServerListener$1.tryConnecting(TeiidParentServerListener.java:242) at org.teiid.designer.runtime.TeiidParentServerListener$1.run(TeiidParentServerListener.java:184) at java.lang.Thread.run(Thread.java:745) Discovered this issue on MAC OS with build TD 9.0.4.Final-v20151111... . I'll try to test this on Fedora. This worked without problems with previous build. Since this doesn't have a workaround I am marking it as a blocker. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2093) Populate the "import" properties defined for translator

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2093?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2093: --------------------------------------------------- Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1045206|https://bugzilla.redhat.com/show_bug.cgi?id=1045206] from ASSIGNED to MODIFIED > Populate the "import" properties defined for translator > ------------------------------------------------------- > > Key: TEIIDDES-2093 > URL: https://issues.jboss.org/browse/TEIIDDES-2093 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 8.2 > Reporter: Ramesh Reddy > Assignee: Barry LaFond > Priority: Critical > Fix For: 8.5 > > > With TEIID-2904, Teiid 8.7 will contain a facility to retrieve the import properties for a translator that are used to customize the metadata import process through Admin API. > Teiid Connection importer needs currently is designed to add ad-hoc import properties, and this can be enhanced to populate with this dynamic list, so that user does not have to search through documents for these import properties. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2723) Properties lost when importing from dynamic VDB

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2723?page=com.atlassian.jira.plu... ] Van Halbert reassigned TEIIDDES-2723: ------------------------------------- Assignee: Barry LaFond > Properties lost when importing from dynamic VDB > ----------------------------------------------- > > Key: TEIIDDES-2723 > URL: https://issues.jboss.org/browse/TEIIDDES-2723 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, VDB & Execution > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Attachments: CustomPropertyVdb-vdb.xml > > > When importing a -vdb.xml, the properties are not imported. This includes both properties defined in the vdb root, as well as properties defined in the models (not sure where would those be imported though). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2414) Large transformation SQL is not exported to INDEX file.

by hisao furuichi (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2414?page=com.atlassian.jira.plu... ] hisao furuichi commented on TEIIDDES-2414: ------------------------------------------ Hello. If it takes a long time to fix this issue, could you consider to implement a validation feature by Teiid Designer as a work around please? So user can notice that they should write a transformation sql less than 8192. Regards, Hisao > Large transformation SQL is not exported to INDEX file. > ------------------------------------------------------- > > Key: TEIIDDES-2414 > URL: https://issues.jboss.org/browse/TEIIDDES-2414 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 8.3.4 > Reporter: Hisanobu Okuda > Assignee: Paul Richardson > Fix For: 9.3 > > Attachments: test.csv > > > A large transformation SQL of a view model is not exported to INDEX file. > I have a large transformation SQL > 8192 bytes in my view model. TDesigner fails to convert the xmi to XXXXXXXXXX.INDEX file. There is no transformation SQL in the INDEX file, therefore, deploying my vdb fails and the vdb is inactivated. When you deploy the vdb, you can see the following message in a log file:- > {code} > 17:16:11,632 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31079 View ViewModel.new_table is not defined by a query expression. > 17:16:11,636 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40073 The metadata for the VDB test.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy. > 17:16:11,637 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB test.1 is set to FAILED > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2727) SQL Queries generated via "Generate REST Virtual Procedures" do not work when executed directly in JBoss Developer Studio

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2727?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-2727: ------------------------------------------ Is the standard JDBC client code being used or is it possible that there are overrides? If it's just the standard client code then what is the exact version of the server / client? > SQL Queries generated via "Generate REST Virtual Procedures" do not work when executed directly in JBoss Developer Studio > ------------------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2727 > URL: https://issues.jboss.org/browse/TEIIDDES-2727 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution, Web Services Support > Affects Versions: 9.2 > Reporter: sw vajanyatek > > The following procedure was generated via right-clicking a view model --> "Generate REST Virtual Procedures": > {code:sql} > BEGIN > SELECT XMLELEMENT(NAME elems, XMLATTRIBUTES(ss4_view.stockRestProc.pk_stockid_in AS pk_stockid_in), XMLAGG(XMLELEMENT(NAME elem, XMLFOREST(ss4_view.stock.stockid, ss4_view.stock.exchangeid, ss4_view.stock.ticker, ss4_view.stock.name, ss4_view.stock.description, ss4_view.stock.notes)))) AS xml_out FROM ss4_view.stock WHERE ss4_view.stockRestProc.pk_stockid_in = ss4_view.stock.stockid; > END > {code} > The resulting REST service (../json/stock/{stockid}) produces the expected results and appears fine. However, executing the following in a sql script connected to the same teiid server via jdbc produces an exception: > {code:sql} > SELECT XMLELEMENT(NAME elems > , XMLAGG(XMLELEMENT(NAME elem, > XMLFOREST(ss4_view.stock.stockid > , ss4_view.stock.exchangeid > , ss4_view.stock.ticker > , ss4_view.stock.name > , ss4_view.stock.description > , ss4_view.stock.notes) > ) > ) > ) AS xml_out > FROM ss4_view.stock > WHERE 4 = ss4_view.stock.stockid; > {code} > {{org.teiid.net.socket.SingleInstanceCommunicationException: java.io.OptionalDataException}} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2727) SQL Queries generated via "Generate REST Virtual Procedures" do not work when executed directly in JBoss Developer Studio

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2727?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2727: ---------------------------------------- [~asmigala] I know that DTP only processes the XML return as a string. > SQL Queries generated via "Generate REST Virtual Procedures" do not work when executed directly in JBoss Developer Studio > ------------------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2727 > URL: https://issues.jboss.org/browse/TEIIDDES-2727 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution, Web Services Support > Affects Versions: 9.2 > Reporter: sw vajanyatek > > The following procedure was generated via right-clicking a view model --> "Generate REST Virtual Procedures": > {code:sql} > BEGIN > SELECT XMLELEMENT(NAME elems, XMLATTRIBUTES(ss4_view.stockRestProc.pk_stockid_in AS pk_stockid_in), XMLAGG(XMLELEMENT(NAME elem, XMLFOREST(ss4_view.stock.stockid, ss4_view.stock.exchangeid, ss4_view.stock.ticker, ss4_view.stock.name, ss4_view.stock.description, ss4_view.stock.notes)))) AS xml_out FROM ss4_view.stock WHERE ss4_view.stockRestProc.pk_stockid_in = ss4_view.stock.stockid; > END > {code} > The resulting REST service (../json/stock/{stockid}) produces the expected results and appears fine. However, executing the following in a sql script connected to the same teiid server via jdbc produces an exception: > {code:sql} > SELECT XMLELEMENT(NAME elems > , XMLAGG(XMLELEMENT(NAME elem, > XMLFOREST(ss4_view.stock.stockid > , ss4_view.stock.exchangeid > , ss4_view.stock.ticker > , ss4_view.stock.name > , ss4_view.stock.description > , ss4_view.stock.notes) > ) > ) > ) AS xml_out > FROM ss4_view.stock > WHERE 4 = ss4_view.stock.stockid; > {code} > {{org.teiid.net.socket.SingleInstanceCommunicationException: java.io.OptionalDataException}} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2727) SQL Queries generated via "Generate REST Virtual Procedures" do not work when executed directly in JBoss Developer Studio

by Andrej Šmigala (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2727?page=com.atlassian.jira.plu... ] Andrej Šmigala edited comment on TEIIDDES-2727 at 11/12/15 11:58 AM: --------------------------------------------------------------------- I am now fully convinced the issue is with XML return type: This throws the above error: {code:sql} select x.xml_out from (exec testProc('a')) as x {code} This works as expected: {code:sql} select r.* from (exec testProc('a')) as x, xmltable('/test' PASSING x.xml_out COLUMNS elem1 string, elem2 string) as r {code} [~blafond] could this in fact be issue in DTP? was (Author: asmigala): I am now fully convinced the issue is with XML return type: This throws the above error: {code:sql} select x.xml_out from (exec testProc('a')) as x {code} This works as expected: {code:sql} select r.* from (exec testProc('a')) as x, xmltable('/test' PASSING x.xml_out COLUMNS elem1 string, elem2 string) as r {code} > SQL Queries generated via "Generate REST Virtual Procedures" do not work when executed directly in JBoss Developer Studio > ------------------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2727 > URL: https://issues.jboss.org/browse/TEIIDDES-2727 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution, Web Services Support > Affects Versions: 9.2 > Reporter: sw vajanyatek > > The following procedure was generated via right-clicking a view model --> "Generate REST Virtual Procedures": > {code:sql} > BEGIN > SELECT XMLELEMENT(NAME elems, XMLATTRIBUTES(ss4_view.stockRestProc.pk_stockid_in AS pk_stockid_in), XMLAGG(XMLELEMENT(NAME elem, XMLFOREST(ss4_view.stock.stockid, ss4_view.stock.exchangeid, ss4_view.stock.ticker, ss4_view.stock.name, ss4_view.stock.description, ss4_view.stock.notes)))) AS xml_out FROM ss4_view.stock WHERE ss4_view.stockRestProc.pk_stockid_in = ss4_view.stock.stockid; > END > {code} > The resulting REST service (../json/stock/{stockid}) produces the expected results and appears fine. However, executing the following in a sql script connected to the same teiid server via jdbc produces an exception: > {code:sql} > SELECT XMLELEMENT(NAME elems > , XMLAGG(XMLELEMENT(NAME elem, > XMLFOREST(ss4_view.stock.stockid > , ss4_view.stock.exchangeid > , ss4_view.stock.ticker > , ss4_view.stock.name > , ss4_view.stock.description > , ss4_view.stock.notes) > ) > ) > ) AS xml_out > FROM ss4_view.stock > WHERE 4 = ss4_view.stock.stockid; > {code} > {{org.teiid.net.socket.SingleInstanceCommunicationException: java.io.OptionalDataException}} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2727) SQL Queries generated via "Generate REST Virtual Procedures" do not work when executed directly in JBoss Developer Studio

by Andrej Šmigala (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2727?page=com.atlassian.jira.plu... ] Andrej Šmigala commented on TEIIDDES-2727: ------------------------------------------ I am now fullu convinced the issue is with XML return type: This throws the above error: {code:sql} select x.xml_out from (exec testProc('a')) as x {code} This works as expected: {code:sql} select r.* from (exec testProc('a')) as x, xmltable('/test' PASSING x.xml_out COLUMNS elem1 string, elem2 string) as r {code} > SQL Queries generated via "Generate REST Virtual Procedures" do not work when executed directly in JBoss Developer Studio > ------------------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2727 > URL: https://issues.jboss.org/browse/TEIIDDES-2727 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution, Web Services Support > Affects Versions: 9.2 > Reporter: sw vajanyatek > > The following procedure was generated via right-clicking a view model --> "Generate REST Virtual Procedures": > {code:sql} > BEGIN > SELECT XMLELEMENT(NAME elems, XMLATTRIBUTES(ss4_view.stockRestProc.pk_stockid_in AS pk_stockid_in), XMLAGG(XMLELEMENT(NAME elem, XMLFOREST(ss4_view.stock.stockid, ss4_view.stock.exchangeid, ss4_view.stock.ticker, ss4_view.stock.name, ss4_view.stock.description, ss4_view.stock.notes)))) AS xml_out FROM ss4_view.stock WHERE ss4_view.stockRestProc.pk_stockid_in = ss4_view.stock.stockid; > END > {code} > The resulting REST service (../json/stock/{stockid}) produces the expected results and appears fine. However, executing the following in a sql script connected to the same teiid server via jdbc produces an exception: > {code:sql} > SELECT XMLELEMENT(NAME elems > , XMLAGG(XMLELEMENT(NAME elem, > XMLFOREST(ss4_view.stock.stockid > , ss4_view.stock.exchangeid > , ss4_view.stock.ticker > , ss4_view.stock.name > , ss4_view.stock.description > , ss4_view.stock.notes) > ) > ) > ) AS xml_out > FROM ss4_view.stock > WHERE 4 = ss4_view.stock.stockid; > {code} > {{org.teiid.net.socket.SingleInstanceCommunicationException: java.io.OptionalDataException}} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 7 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues November 2015