October 2014 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2287) Error Generating REST Transformation with Teiid Reserved Word

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2287?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2287. ------------------------------------ Resolution: Done master: https://github.com/Teiid-Designer/teiid-designer/commit/6a73660037e28b38b... > Error Generating REST Transformation with Teiid Reserved Word > ------------------------------------------------------------- > > Key: TEIIDDES-2287 > URL: https://issues.jboss.org/browse/TEIIDDES-2287 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 8.6 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 8.7, 8.6.1 > > > The following procedure transformation generated for a REST source is invalid due to using the OUTPUT Teiid reserved word as a column. > BEGIN > DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google."output" AS output, ViewModel.google.q AS q); > SELECT A.data AS data FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH '/suggestion/@data') AS A; > END > The word output should be in double quotes: BEGIN > DECLARE STRING VARIABLES.qp = QUERYSTRING('http://www.google.com/complete/search', ViewModel.google."output" AS "output", ViewModel.google.q AS q); > SELECT A.data AS data FROM (EXEC SourceModel.invokeHttp('GET', null, VARIABLES.qp, 'TRUE')) AS f, XMLTABLE('/toplevel/CompleteSuggestion' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS data string PATH '/suggestion/@data') AS A; > END -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2323) Rest Importer should encode the both "default" and provided values before submitting query

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2323?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2323. ------------------------------------ Resolution: Done master: https://github.com/Teiid-Designer/teiid-designer/commit/3af86d60d0d6938c1... > Rest Importer should encode the both "default" and provided values before submitting query > ------------------------------------------------------------------------------------------ > > Key: TEIIDDES-2323 > URL: https://issues.jboss.org/browse/TEIIDDES-2323 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 8.6 > Reporter: Ramesh Reddy > Assignee: Ted Jones > Fix For: 8.6.1 > > Attachments: postoffice.png > > > For example take a web api examples here look at [https://www.usps.com/business/web-tools-apis/address-information.htm] > Here one is required to submit the XML as query parameter, XML needs to be encoded before the query is sent -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2367) MongoDB: sampling the data and auto generate schema

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2367?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-2367: ---------------------------------------- [~ichanjasper] have u tried using Teiid Connection Importer with MongoDB? > MongoDB: sampling the data and auto generate schema > ---------------------------------------------------- > > Key: TEIIDDES-2367 > URL: https://issues.jboss.org/browse/TEIIDDES-2367 > Project: Teiid Designer > Issue Type: Feature Request > Components: Teiid Integration > Affects Versions: 8.7 > Environment: Teiid with MongoDB > Reporter: Ivan Chan > Labels: Teiid > > Currently, Teiid requires user to generate schema for MongoDB data source manually. I think it would be much nicer if Teiid can sample the data and generate default schema. > And users may modify the schema to fit their needs or use it as it. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2367) MongoDB: sampling the data and auto generate schema

by Ivan Chan (JIRA)

Ivan Chan created TEIIDDES-2367: ----------------------------------- Summary: MongoDB: sampling the data and auto generate schema Key: TEIIDDES-2367 URL: https://issues.jboss.org/browse/TEIIDDES-2367 Project: Teiid Designer Issue Type: Feature Request Components: Teiid Integration Affects Versions: 8.7 Environment: Teiid with MongoDB Reporter: Ivan Chan Currently, Teiid requires user to generate schema for MongoDB data source manually. I think it would be much nicer if Teiid can sample the data and generate default schema. And users may modify the schema to fit their needs or use it as it. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2323) Rest Importer should encode the both "default" and provided values before submitting query

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2323?page=com.atlassian.jira.plu... ] Ted Jones updated TEIIDDES-2323: -------------------------------- Fix Version/s: 8.6.1 (was: 8.6) > Rest Importer should encode the both "default" and provided values before submitting query > ------------------------------------------------------------------------------------------ > > Key: TEIIDDES-2323 > URL: https://issues.jboss.org/browse/TEIIDDES-2323 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 8.6 > Reporter: Ramesh Reddy > Assignee: Ted Jones > Fix For: 8.6.1 > > Attachments: postoffice.png > > > For example take a web api examples here look at [https://www.usps.com/business/web-tools-apis/address-information.htm] > Here one is required to submit the XML as query parameter, XML needs to be encoded before the query is sent -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2323) Rest Importer should encode the both "default" and provided values before submitting query

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2323?page=com.atlassian.jira.plu... ] Ted Jones reopened TEIIDDES-2323: --------------------------------- Reopening to address issues with paramter encoding > Rest Importer should encode the both "default" and provided values before submitting query > ------------------------------------------------------------------------------------------ > > Key: TEIIDDES-2323 > URL: https://issues.jboss.org/browse/TEIIDDES-2323 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 8.6 > Reporter: Ramesh Reddy > Assignee: Ted Jones > Fix For: 8.6 > > Attachments: postoffice.png > > > For example take a web api examples here look at [https://www.usps.com/business/web-tools-apis/address-information.htm] > Here one is required to submit the XML as query parameter, XML needs to be encoded before the query is sent -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2336) Data lost performing Back and Next actions in WS to Source Model (REST) importer

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2336?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2336. ------------------------------------ Assignee: Barry LaFond (was: Ted Jones) Resolution: Done master: https://github.com/Teiid-Designer/teiid-designer/commit/746123e5cc3a77c91... > Data lost performing Back and Next actions in WS to Source Model (REST) importer > -------------------------------------------------------------------------------- > > Key: TEIIDDES-2336 > URL: https://issues.jboss.org/browse/TEIIDDES-2336 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 8.5 > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 8.6.1 > > > Noticing that after clicking NEXT> from the Source Selection page, then defining import options and clicking <BACK, the state of the first page was mostly empty and intitial values and combo selections were gone. > Need to restore all the user data to it's original form on BACK action -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2229) Merge various fixes from master into 8.6.1

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2229?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2229: ----------------------------------- Description: *Candidates* * TEIIDDES-XXXX - XXX *Completed Upstream* * TEIIDDES-1037 Data types inported from flat file partially implemented in wizard * TEIIDDES-2336 Data lost performing Back and Next actions in WS to Source Model (REST) importer * TEIIDDES-2347 Undeploying a Dynamic VDB results in TeiidAdminProcessing exception * TEIIDDES-2350 Select Datatype Dialog UI issue * TEIIDDES-2354 Import -> Web Service Source >> Source and View Model(REST) is missing one quote in SQL * TEIIDDES-2356 Import DDL file from workspace location does not work. File not found * TEIIDDES-2362 removed column object type when trying to ADD row-base security filter * TEIIDDES-2358 REST WS import issues with translator and data source * TEIIDDES-2359 Teiid Designer sends header-accept="application/xml" when trying to import from REST JSON *Merged* * TEIIDDES-2194 On windows, when deploying VDB, and data source exist, it still wants to create datasource * TEIIDDES-2301 & TEIIDDES-2276 XML File importer - issues with SQL generation * TEIIDDES-2342 Layout issues with second page of Teiid Import Wizard in Luna was: *Candidates* * TEIIDDES-XXXX - XXX *Completed Upstream* * TEIIDDES-1037 Data types inported from flat file partially implemented in wizard * TEIIDDES-2347 Undeploying a Dynamic VDB results in TeiidAdminProcessing exception * TEIIDDES-2350 Select Datatype Dialog UI issue * TEIIDDES-2354 Import -> Web Service Source >> Source and View Model(REST) is missing one quote in SQL * TEIIDDES-2356 Import DDL file from workspace location does not work. File not found * TEIIDDES-2362 removed column object type when trying to ADD row-base security filter * TEIIDDES-2358 REST WS import issues with translator and data source * TEIIDDES-2359 Teiid Designer sends header-accept="application/xml" when trying to import from REST JSON *Merged* * TEIIDDES-2194 On windows, when deploying VDB, and data source exist, it still wants to create datasource * TEIIDDES-2301 & TEIIDDES-2276 XML File importer - issues with SQL generation * TEIIDDES-2342 Layout issues with second page of Teiid Import Wizard in Luna > Merge various fixes from master into 8.6.1 > ------------------------------------------ > > Key: TEIIDDES-2229 > URL: https://issues.jboss.org/browse/TEIIDDES-2229 > Project: Teiid Designer > Issue Type: Task > Components: Patch Release > Affects Versions: 8.5.1, 8.6.1 > Reporter: Ted Jones > Assignee: Johnathon Lee > Priority: Blocker > Fix For: 8.6.1 > > > *Candidates* > * TEIIDDES-XXXX - XXX > *Completed Upstream* > * TEIIDDES-1037 Data types inported from flat file partially implemented in wizard > * TEIIDDES-2336 Data lost performing Back and Next actions in WS to Source Model (REST) importer > * TEIIDDES-2347 Undeploying a Dynamic VDB results in TeiidAdminProcessing exception > * TEIIDDES-2350 Select Datatype Dialog UI issue > * TEIIDDES-2354 Import -> Web Service Source >> Source and View Model(REST) is missing one quote in SQL > * TEIIDDES-2356 Import DDL file from workspace location does not work. File not found > * TEIIDDES-2362 removed column object type when trying to ADD row-base security filter > * TEIIDDES-2358 REST WS import issues with translator and data source > * TEIIDDES-2359 Teiid Designer sends header-accept="application/xml" when trying to import from REST JSON > *Merged* > * TEIIDDES-2194 On windows, when deploying VDB, and data source exist, it still wants to create datasource > * TEIIDDES-2301 & TEIIDDES-2276 XML File importer - issues with SQL generation > * TEIIDDES-2342 Layout issues with second page of Teiid Import Wizard in Luna -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2229) Merge various fixes from master into 8.6.1

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2229?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2229: ----------------------------------- Description: *Candidates* * TEIIDDES-XXXX - XXX *Completed Upstream* * TEIIDDES-1037 Data types inported from flat file partially implemented in wizard * TEIIDDES-2347 Undeploying a Dynamic VDB results in TeiidAdminProcessing exception * TEIIDDES-2350 Select Datatype Dialog UI issue * TEIIDDES-2354 Import -> Web Service Source >> Source and View Model(REST) is missing one quote in SQL * TEIIDDES-2356 Import DDL file from workspace location does not work. File not found * TEIIDDES-2362 removed column object type when trying to ADD row-base security filter * TEIIDDES-2358 REST WS import issues with translator and data source * TEIIDDES-2359 Teiid Designer sends header-accept="application/xml" when trying to import from REST JSON *Merged* * TEIIDDES-2194 On windows, when deploying VDB, and data source exist, it still wants to create datasource * TEIIDDES-2301 & TEIIDDES-2276 XML File importer - issues with SQL generation * TEIIDDES-2342 Layout issues with second page of Teiid Import Wizard in Luna was: *Candidates* * TEIIDDES-XXXX - XXX *Completed Upstream* * TEIIDDES-1037 Data types inported from flat file partially implemented in wizard * TEIIDDES-2347 Undeploying a Dynamic VDB results in TeiidAdminProcessing exception * TEIIDDES-2350 Select Datatype Dialog UI issue * TEIIDDES-2354 Import -> Web Service Source >> Source and View Model(REST) is missing one quote in SQL * TEIIDDES-2356 Import DDL file from workspace location does not work. File not found * TEIIDDES-2362 removed column object type when trying to ADD row-base security filter * TEIIDDES-2358 REST WS import issues with translator and data source *Merged* * TEIIDDES-2194 On windows, when deploying VDB, and data source exist, it still wants to create datasource * TEIIDDES-2301 & TEIIDDES-2276 XML File importer - issues with SQL generation * TEIIDDES-2342 Layout issues with second page of Teiid Import Wizard in Luna > Merge various fixes from master into 8.6.1 > ------------------------------------------ > > Key: TEIIDDES-2229 > URL: https://issues.jboss.org/browse/TEIIDDES-2229 > Project: Teiid Designer > Issue Type: Task > Components: Patch Release > Affects Versions: 8.5.1, 8.6.1 > Reporter: Ted Jones > Assignee: Johnathon Lee > Priority: Blocker > Fix For: 8.6.1 > > > *Candidates* > * TEIIDDES-XXXX - XXX > *Completed Upstream* > * TEIIDDES-1037 Data types inported from flat file partially implemented in wizard > * TEIIDDES-2347 Undeploying a Dynamic VDB results in TeiidAdminProcessing exception > * TEIIDDES-2350 Select Datatype Dialog UI issue > * TEIIDDES-2354 Import -> Web Service Source >> Source and View Model(REST) is missing one quote in SQL > * TEIIDDES-2356 Import DDL file from workspace location does not work. File not found > * TEIIDDES-2362 removed column object type when trying to ADD row-base security filter > * TEIIDDES-2358 REST WS import issues with translator and data source > * TEIIDDES-2359 Teiid Designer sends header-accept="application/xml" when trying to import from REST JSON > *Merged* > * TEIIDDES-2194 On windows, when deploying VDB, and data source exist, it still wants to create datasource > * TEIIDDES-2301 & TEIIDDES-2276 XML File importer - issues with SQL generation > * TEIIDDES-2342 Layout issues with second page of Teiid Import Wizard in Luna -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2359) Teiid Designer sends header-accept="application/xml" when trying to import from REST JSON

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2359?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2359: ----------------------------------- Summary: Teiid Designer sends header-accept="application/xml" when trying to import from REST JSON (was: Tiied Designer sends header-accept="application/xml" when trying to import from REST JSON) > Teiid Designer sends header-accept="application/xml" when trying to import from REST JSON > ----------------------------------------------------------------------------------------- > > Key: TEIIDDES-2359 > URL: https://issues.jboss.org/browse/TEIIDDES-2359 > Project: Teiid Designer > Issue Type: Enhancement > Affects Versions: 8.6.1 > Environment: Windows 7 > Reporter: Matus Makovy > Attachments: 1.png, 2.png, 3.png, 4.png, 5.png, 6.png, log.txt > > > I have my small web application that should simulate a REST web service (it simply returns XML and JSON strings), when I have annotation @Produces("application/json") and I try to import from this REST JSON, TD gives me an error that server returned response code 406. > After I change it in my application to @Produces("application/xml") it is OK. > I tried to force server to log accept-headers that it is sending. Server sends accept-headers: aplication/xml (Log attached) > Screenshots attached > TD 8.6.1.Alpha1 + DV 6.1.ER2 > I am not sure, but I think this issue occurs also in 8.3.4 -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 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 2014