December 2015 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2688) Dynamic VDB Generation - Problem with DDL generated for procedure

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2688?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2688: --------------------------------------------------- Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1271233|https://bugzilla.redhat.com/show_bug.cgi?id=1271233] from ASSIGNED to CLOSED > Dynamic VDB Generation - Problem with DDL generated for procedure > ----------------------------------------------------------------- > > Key: TEIIDDES-2688 > URL: https://issues.jboss.org/browse/TEIIDDES-2688 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.4 > Reporter: Matus Makovy > Assignee: Barry LaFond > Fix For: 9.2 > > > I have a VDB that was created for consumption of REST Web Service. > There is a procedure named getProgrammes(). DDL generated for dynamic VDB is: > {quote} > CREATE VIRTUAL PROCEDURE getProgrammes () > AS > CREATE VIRTUAL PROCEDURE > BEGIN > DECLARE STRING VARIABLES.qp = ''; > SELECT > A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title > FROM > (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A; > END; > {quote} > Obviously, there is one extra "CREATE VIRTUAL PROCEDURE". > Even after fixing this issue there is another error: > {quote} > VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel > {quote} > "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2687) Dynamic VDB generation - Default value for string column problem (DDL)

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2687?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2687: --------------------------------------------------- Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1271226|https://bugzilla.redhat.com/show_bug.cgi?id=1271226] from NEW to CLOSED > Dynamic VDB generation - Default value for string column problem (DDL) > ---------------------------------------------------------------------- > > Key: TEIIDDES-2687 > URL: https://issues.jboss.org/browse/TEIIDDES-2687 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Patch Release, VDB & Execution > Affects Versions: 9.0.4 > Reporter: Matus Makovy > Assignee: Mark Drilling > Fix For: 9.2.1 > > > I have a model with table that has String column with default value "Stock". > DDL generated by TD for dynamic VDB looks like this: > {quote} > ... > TYPE string(15) DEFAULT ('Stock') OPTIONS(NAMEINSOURCE '"TYPE"', NATIVE_TYPE 'VARCHAR2', UPDATABLE 'FALSE'), > ... > {quote} > *DEFAULT ('Stock')* is not correct, it should be: *DEFAULT '("Stock")'* -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2684) SalesForce importer issue

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2684?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2684: --------------------------------------------------- Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1270843|https://bugzilla.redhat.com/show_bug.cgi?id=1270843] from NEW to CLOSED > SalesForce importer issue > ------------------------- > > Key: TEIIDDES-2684 > URL: https://issues.jboss.org/browse/TEIIDDES-2684 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Patch Release > Affects Versions: 9.0.4 > Environment: MAC OS > Reporter: Matus Makovy > Assignee: Mark Drilling > Fix For: 9.2.1 > > Attachments: salesdynamic-vdb.xml > > > According to conversation in TEIID-3112 this is a Designer issue. If I understood correctly, it has been fixed in Teiid and now the changes have to be made in TD SF importer. > I have a VDB with Source model that is created via SalesForce importer and I am getting this error: > {quote} > Didn't understand relationship 'Opportunitys' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names > {quote} > when trying to submit this query: > {quote} > select distinct YEAR("Opportunity"."CloseDate") as "Opportunity_CloseDate1" from "SalesForceSource".Campaign AS "Campaign" LEFT OUTER JOIN "SalesForceSource".Opportunity AS "Opportunity" ON Campaign."Id" = Opportunity."CampaignId" order by YEAR("Opportunity"."CloseDate") ASC LIMIT 0 , 32 > {quote} > It works without problems with dynamic VDB. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2683) Importing Excel file using Teiid Connection does not import extension properties

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2683?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2683: --------------------------------------------------- Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1270833|https://bugzilla.redhat.com/show_bug.cgi?id=1270833] from NEW to CLOSED > Importing Excel file using Teiid Connection does not import extension properties > -------------------------------------------------------------------------------- > > Key: TEIIDDES-2683 > URL: https://issues.jboss.org/browse/TEIIDDES-2683 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > > When importing an excel file using Teiid Connection, the extension properties are silently discarded. This results in invalid model, which, when deployed and queried, causes the following error in the server log: > bq. Connector worker process failed for atomic-request=AVU37BnZoOUS.0.0.0: org.teiid.translator.TranslatorException: TEIID23007 OPTIONS property CELL_NUMBER is required and it not defined on column ROW_ID > The DDL obtained from the server is > {code:sql} > SET NAMESPACE 'http://www.teiid.org/translator/excel/2014' AS teiid_excel; > CREATE FOREIGN TABLE Sheet1 ( > ROW_ID integer OPTIONS (SEARCHABLE 'All_Except_Like', "teiid_excel:CELL_NUMBER" 'ROW_ID'), > StringNum string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '1'), > CharValue string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '2'), > DoubleNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '3'), > BigIntegerValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '4'), > ShortValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '5'), > FloatNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '6'), > ObjectValue string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '7'), > IntNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '8'), > BigDecimalValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '9'), > LongNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '10'), > BooleanValue boolean OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '11'), > TimestampValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '12'), > ByteNum double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '13'), > IntKey double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '14'), > StringKey string OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '15'), > TimeValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '16'), > DateValue double OPTIONS (SEARCHABLE 'Unsearchable', "teiid_excel:CELL_NUMBER" '17'), > CONSTRAINT PK0 PRIMARY KEY(ROW_ID) > ) OPTIONS ("teiid_excel:FILE" 'smalla.xlsx', "teiid_excel:FIRST_DATA_ROW_NUMBER" '2'); > {code} > When trying to import the same DDL using the DDL import wizard, a warning dialog is shown stating that the extension properties could not be processed and the Model Extension Definition should be registered -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[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 commented on TEIIDDES-2682: --------------------------------------------------- Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1270793|https://bugzilla.redhat.com/show_bug.cgi?id=1270793] from NEW to CLOSED > 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 > Assignee: Barry LaFond > Fix For: 10.0 > > 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)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2677) Preview data from the view table which use UDF procedure doesn't work

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2677?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2677: --------------------------------------------------- Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1268843|https://bugzilla.redhat.com/show_bug.cgi?id=1268843] from NEW to CLOSED > Preview data from the view table which use UDF procedure doesn't work > --------------------------------------------------------------------- > > Key: TEIIDDES-2677 > URL: https://issues.jboss.org/browse/TEIIDDES-2677 > Project: Teiid Designer > Issue Type: Bug > Components: Data Preview > Affects Versions: 9.0.4 > Environment: Fedora 22 > Reporter: Matej Kralik > > When I tried data preview from the view table which use UDF procedure, it has failed and show > "org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryResolverException: Group does not exist: UdfViewModel.UdfView" > but UdfView exist. > However,when I exported the project and import it back, preview data works correctly. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2674) When deleting project with read-only model TD produces 4 warnings instead of 1

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2674?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2674: --------------------------------------------------- Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1268214|https://bugzilla.redhat.com/show_bug.cgi?id=1268214] from NEW to CLOSED > When deleting project with read-only model TD produces 4 warnings instead of 1 > ------------------------------------------------------------------------------ > > Key: TEIIDDES-2674 > URL: https://issues.jboss.org/browse/TEIIDDES-2674 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling, Patch Release > Affects Versions: 9.0.4 > Environment: MAC OS X > Reporter: Matus Makovy > Assignee: Dan Florian > Priority: Minor > Fix For: 9.2.1 > > Attachments: Screen Shot 2015-10-02 at 9.38.33.png > > > When you try to delete project with read-only model in it, TD shows a warning that there is this kind of model, but instead of one there are 4 warnings. > See screenshot -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2670) Copying XML Schema Model problem

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2670?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2670: --------------------------------------------------- Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1267290|https://bugzilla.redhat.com/show_bug.cgi?id=1267290] from NEW to CLOSED > Copying XML Schema Model problem > -------------------------------- > > Key: TEIIDDES-2670 > URL: https://issues.jboss.org/browse/TEIIDDES-2670 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.3 > Reporter: stanislav kaleta > Priority: Optional > Attachments: TestedProject.zip > > > When creating new XML Schema (XSD) Model by copying from existing model (see steps to reproduce), action fails with error (and new empty schema) for some schemas (e.g. schemas in attachement). > Error message: > Error attempting to load a Model Editor Page plugin > ID = org.teiid.designer.xsd.ui.editor.XsdSimpleDatatypesEditorPage@611ddac3 > Exception Stack Trace: > ... > Caused by: org.xml.sax.SAXParseException ... ... lineNumber: 1; columnNumber: 1; Premature end of file. > I assume it might be something with line endings of Windows text files, because it happened only for files originally created in Windows for me (However some schemas created in Windows works properly). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

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

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2414?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2414: --------------------------------------------------- Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1263723|https://bugzilla.redhat.com/show_bug.cgi?id=1263723] from NEW to CLOSED > 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, Patch Release > Affects Versions: 8.3.4 > Reporter: Hisanobu Okuda > Assignee: Paul Richardson > Fix For: 9.2.1 > > Attachments: reosurce-problem-marker.png, 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)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2659) Preview data will have deployed the driver to the server only after first error.

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2659?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2659: --------------------------------------------------- Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1265732|https://bugzilla.redhat.com/show_bug.cgi?id=1265732] from NEW to CLOSED > Preview data will have deployed the driver to the server only after first error. > -------------------------------------------------------------------------------- > > Key: TEIIDDES-2659 > URL: https://issues.jboss.org/browse/TEIIDDES-2659 > Project: Teiid Designer > Issue Type: Bug > Components: Data Preview, Patch Release > Affects Versions: 9.0.3 > Reporter: Matej Kralik > Assignee: Dan Florian > Priority: Minor > Fix For: 9.2.1 > > > I removed a driver from the server,then clicked to refresh teiid instance connection in the Jboss developer studio. (once or more) but preview data doesn't deploy the driver on the server and shows error (TEIID30498 Capabilities for [source model] were not avaialable. The command could not be planned properly.). And from now when I click to refresh teiid instance connection and I click to preview data, data will be show correctly. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues December 2015