May 2017 - teiid-designer-issues - Jboss List Archives

[JBoss JIRA] (TEIIDDES-3083) Error indexing model resource

by Madou Coulibaly (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3083?page=com.atlassian.jira.plu... ] Madou Coulibaly commented on TEIIDDES-3083: ------------------------------------------- Hi [~mmakovy] Please attached my xmi file. [^CEPH_MVL.xmi] I have found the error. I do not know why but the properties "Materialized Table" got a wrong value. I think the error should have been more relevant. So I corrected it, everything was ok in JBDS but when I deployed the VDB, I got the following error from Teiid Server: 16:06:21,613 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB xxxx.1 model "CEPH_MVL" metadata failed to load. Reason:TEIID80004 Model CEPH_MVL not found: org.teiid.translator.TranslatorException: TEIID80004 Model CEPH_MVL not found at org.teiid.metadata.index.IndexMetadataRepository.loadMetadata(IndexMetadataRepository.java:238) [teiid-metadata-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2] at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2] at org.teiid.jboss.VDBService$7.run(VDBService.java:446) [teiid-jboss-integration-8.12.10.6_3-redhat-2.jar:8.12.10.6_3-redhat-2] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_131] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_131] at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131] at org.jboss.threads.JBossThread.run(JBossThread.java:122) I had to modify my View Model and to recreate my VDB in order to solve the problem. > Error indexing model resource > ----------------------------- > > Key: TEIIDDES-3083 > URL: https://issues.jboss.org/browse/TEIIDDES-3083 > Project: Teiid Designer > Issue Type: Bug > Components: Eclipse Integration > Affects Versions: 11.0.1 > Reporter: Madou Coulibaly > Attachments: CEPH_MVL.xmi, Capture d’écran 2017-05-29 à 17.56.25.png, Capture d’écran 2017-05-29 à 17.56.29.png > > > An error appears and I do not know how to fix it > Error indexing model resource CEPH_MVL.xmi : > null > Please find the screenshot attached > Any help? -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3083) Error indexing model resource

by Madou Coulibaly (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3083?page=com.atlassian.jira.plu... ] Madou Coulibaly updated TEIIDDES-3083: -------------------------------------- Attachment: CEPH_MVL.xmi > Error indexing model resource > ----------------------------- > > Key: TEIIDDES-3083 > URL: https://issues.jboss.org/browse/TEIIDDES-3083 > Project: Teiid Designer > Issue Type: Bug > Components: Eclipse Integration > Affects Versions: 11.0.1 > Reporter: Madou Coulibaly > Attachments: CEPH_MVL.xmi, Capture d’écran 2017-05-29 à 17.56.25.png, Capture d’écran 2017-05-29 à 17.56.29.png > > > An error appears and I do not know how to fix it > Error indexing model resource CEPH_MVL.xmi : > null > Please find the screenshot attached > Any help? -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3083) Error indexing model resource

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3083?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-3083: ---------------------------------------- Hi [~mcouliba], could you please upload the project or xmi file ? > Error indexing model resource > ----------------------------- > > Key: TEIIDDES-3083 > URL: https://issues.jboss.org/browse/TEIIDDES-3083 > Project: Teiid Designer > Issue Type: Bug > Components: Eclipse Integration > Affects Versions: 11.0.1 > Reporter: Madou Coulibaly > Attachments: Capture d’écran 2017-05-29 à 17.56.25.png, Capture d’écran 2017-05-29 à 17.56.29.png > > > An error appears and I do not know how to fix it > Error indexing model resource CEPH_MVL.xmi : > null > Please find the screenshot attached > Any help? -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3083) Error indexing model resource

by Madou Coulibaly (JIRA)

Madou Coulibaly created TEIIDDES-3083: ----------------------------------------- Summary: Error indexing model resource Key: TEIIDDES-3083 URL: https://issues.jboss.org/browse/TEIIDDES-3083 Project: Teiid Designer Issue Type: Bug Components: Eclipse Integration Affects Versions: 11.0.1 Reporter: Madou Coulibaly Attachments: Capture d’écran 2017-05-29 à 17.56.25.png, Capture d’écran 2017-05-29 à 17.56.29.png An error appears and I do not know how to fix it Error indexing model resource CEPH_MVL.xmi : null Please find the screenshot attached Any help? -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3069) odata4 fails to return data on top of mongoDB view model

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3069?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-3069: --------------------------------------------------- Debi Rieden <drieden(a)redhat.com> changed the Status of [bug 1435440|https://bugzilla.redhat.com/show_bug.cgi?id=1435440] from NEW to CLOSED > odata4 fails to return data on top of mongoDB view model > --------------------------------------------------------- > > Key: TEIIDDES-3069 > URL: https://issues.jboss.org/browse/TEIIDDES-3069 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Environment: Noticed in JDV 6.3.4 > Reporter: Michael Echevarria > Assignee: Barry LaFond > Priority: Critical > Fix For: 11.0.2 > > Attachments: Screenshot from 2017-03-28 15-38-25.png, Screenshot from 2017-03-28 15-38-32.png, Screenshot from 2017-03-28 15-38-46.png, Screenshot from 2017-03-28 15-38-56.png, designer-length-added.png, mongo-view-error.png, odata2-works.png, odata4-error.png, odata4-with-length-changed.png > > > Description of problem: > Accessing either an exclusive view model or combined view model for a mongoDB datasource via odata4 results in an error. > The data returns via odata2, jdbc and preview in the designer > Version-Release number of selected component (if applicable): > JDV 6.3.4 > Actual results: > Property mapping error > Expected results: > Model data -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3082) Revisit JDBC procedure import to ensure we are using all available information available in the driver

by Marc Shirley (JIRA)

Marc Shirley created TEIIDDES-3082: -------------------------------------- Summary: Revisit JDBC procedure import to ensure we are using all available information available in the driver Key: TEIIDDES-3082 URL: https://issues.jboss.org/browse/TEIIDDES-3082 Project: Teiid Designer Issue Type: Feature Request Environment: Oracle JDBC import including procedures Reporter: Marc Shirley JDBC procedure import (for Oracle at least) generally results in a skeleton procedure object being created, usually with input parameters and an undefined result set. Can we determine if there is any additional modeling we can do during import utilizing the available information from the driver or by executing a sample call to the procedure? TEIID-2644 [1] looks to potentially have something we can leverage at least in the case of a REF CURSOR output parameter that could be used to flesh out the imported procedure in some cases. [1] https://issues.jboss.org/browse/TEIID-2644 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3081) Change file importer logic to expose the file procedures

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3081?page=com.atlassian.jira.plu... ] Van Halbert reassigned TEIIDDES-3081: ------------------------------------- Assignee: Barry LaFond > Change file importer logic to expose the file procedures > -------------------------------------------------------- > > Key: TEIIDDES-3081 > URL: https://issues.jboss.org/browse/TEIIDDES-3081 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 11.0.2 > Reporter: Van Halbert > Assignee: Barry LaFond > > Teiid added the feature [1] to the file translator, that also needs a change to teiid designer file importer to expose those file procedures. > [1] https://issues.jboss.org/browse/TEIID-4857 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3081) Change file importer logic to expose the file procedures

by Van Halbert (JIRA)

Van Halbert created TEIIDDES-3081: ------------------------------------- Summary: Change file importer logic to expose the file procedures Key: TEIIDDES-3081 URL: https://issues.jboss.org/browse/TEIIDDES-3081 Project: Teiid Designer Issue Type: Enhancement Components: Import/Export Affects Versions: 11.0.2 Reporter: Van Halbert Teiid added the feature [1] to the file translator, that also needs a change to teiid designer file importer to expose those file procedures. [1] https://issues.jboss.org/browse/TEIID-4857 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3071) SQL transformation editor rewrites TRIM() function incorrectly most of the time

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3071?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-3071: ----------------------------------- Fix Version/s: 11.0.2 > SQL transformation editor rewrites TRIM() function incorrectly most of the time > ------------------------------------------------------------------------------- > > Key: TEIIDDES-3071 > URL: https://issues.jboss.org/browse/TEIIDDES-3071 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 11.0.1 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 11.0.2 > > > Paste the below SQL in the transformation editor to create a view table: > SELECT > trim(INTKEY),trim(STRINGKEY),trim(INTNUM),trim(STRINGNUM),trim(FLOATNUM),trim(LONGNUM),trim(DOUBLENUM),trim(BYTENUM),trim(DATEVALUE),trim(TIMESTAMPVALUE), trim(BOOLEANVALUE),trim(CHARVALUE),trim(SHORTVALUE),trim(BIGINTEGERVALUE),trim(BIGDECIMALVALUE),trim(OBJECTVALUE) > FROM > bqtora.LARGEB > Once you save it, it gets rewritten with the defaults, but it leaves the column name out most of the time: > SELECT > trim(' ' FROM ), trim(' ' FROM bqtora.LARGEB.STRINGKEY), trim(' ' FROM ), trim(' ' FROM bqtora.LARGEB.STRINGNUM), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM bqtora.LARGEB.OBJECTVALUE) > FROM > bqtora.LARGEB > So obviously you receive a validation parsing error: > ERROR: Error in parsing of sql - Encountered " ")" ") "" at line 2, column 31. > Was expecting one of: > "char" ... > "date" ... > "time" ... > "timestamp" ... > "cast" ... > "convert" ... > "any" ... > "array_agg" ... > "case" ... > "exists" ... > "false" ... > "hour" ... > "insert" ... > "left" ... > "minute" ... > "month" ... > "not" ... > "null" ... > "right" ... > "second" ... > "some" ... > "translate" ... > "true" ... > "unknown" ... > "user" ... > "year" ... > "xmlagg" ... > "xmlcast" ... > "xmlconcat" ... > "xmlcomment" ... > "xmlelement" ... > "xmlexists" ... > "xmlforest" ... > "xmlparse" ... > "xmlpi" ... > "xmlquery" ... > "xmlserialize" ... > "xmltext" ... > "instead" ... > "enabled" ... > "disabled" ... > "view" ... > "key" ... > "serial" ... > "textagg" ... > "count" ... > "row_number" ... > "rank" ... > "dense_rank" ... > "sum" ... > "avg" ... > "min" ... > "max" ... > "every" ... > "stddev_pop" ... > "stddev_samp" ... > "var_samp" ... > "var_pop" ... > "document" ... > "content" ... > "trim" ... > "empty" ... > "ordinality" ... > "path" ... > "first" ... > "last" ... > "next" ... > "substring" ... > "extract" ... > "to_chars" ... > "to_bytes" ... > "timestampadd" ... > "timestampdiff" ... > "querystring" ... > "namespace" ... > "result" ... > "index" ... > "accesspattern" ... > "auto_increment" ... > "wellformed" ... > "sql_tsi_frac_second" ... > "sql_tsi_second" ... > "sql_tsi_minute" ... > "sql_tsi_hour" ... > "sql_tsi_day" ... > "sql_tsi_week" ... > "sql_tsi_month" ... > "sql_tsi_quarter" ... > "sql_tsi_year" ... > "texttable" ... > "arraytable" ... > "selector" ... > "skip" ... > "width" ... > "passing" ... > "name" ... > "encoding" ... > "columns" ... > "delimiter" ... > "quote" ... > "header" ... > "nulls" ... > "objecttable" ... > "version" ... > "including" ... > "excluding" ... > "xmldeclaration" ... > "variadic" ... > "exception" ... > "raise" ... > "chain" ... > "jsonarray_agg" ... > "jsonobject" ... > "preserve" ... > <ID> ... > <ESCAPEDFUNCTION> ... > <ESCAPEDTYPE> ... > <DECIMALVAL> ... > <FLOATVAL> ... > <STRINGVAL> ... > <UNSIGNEDINTEGER> ... > <BINARYSTRINGVAL> ... > "(" ... > "+" ... > "-" ... > "?" ... > "$" ... > -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3071) SQL transformation editor rewrites TRIM() function incorrectly most of the time

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3071?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3071: ---------------------------------------- partial patch {code} diff --git a/plugins/teiid/org.teiid.runtime.client/engine/org/teiid/query/sql/visitor/SQLStringVisitor.java b/plugins/teiid/org.teiid.runtime.client/engine/org/teiid/query/sql/visitor/SQLStringVisitor.java index 25e49dc..13998a5 100644 --- a/plugins/teiid/org.teiid.runtime.client/engine/org/teiid/query/sql/visitor/SQLStringVisitor.java +++ b/plugins/teiid/org.teiid.runtime.client/engine/org/teiid/query/sql/visitor/SQLStringVisitor.java @@ -2716,13 +2716,26 @@ if (!value.equalsIgnoreCase(BOTH)) { append(((Constant)args[0]).getValue()); append(" "); //$NON-NLS-1$ + append(args[1]); + append(" "); //$NON-NLS-1$ + append(FROM); + append(" "); //$NON-NLS-1$ + append(args[2]); + append(SQLConstants.Tokens.RPAREN); //$NON-NLS-1$ + } else { + if( args[1] instanceof Constant && ((String)((Constant)args[1]).getValue()).equalsIgnoreCase(" ")) { + append(args[2]); + append(SQLConstants.Tokens.RPAREN); //$NON-NLS-1$ + } else { + append(args[1]); + append(" "); //$NON-NLS-1$ + append(FROM); + append(" "); //$NON-NLS-1$ + append(args[2]); + append(SQLConstants.Tokens.RPAREN); //$NON-NLS-1$ + } } - append(args[1]); - append(" "); //$NON-NLS-1$ - append(FROM); - append(" "); //$NON-NLS-1$ - append(args[2]); - append(")"); //$NON-NLS-1$ + } else { append(name); append("("); //$NON-NLS-1$ {code} > SQL transformation editor rewrites TRIM() function incorrectly most of the time > ------------------------------------------------------------------------------- > > Key: TEIIDDES-3071 > URL: https://issues.jboss.org/browse/TEIIDDES-3071 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 11.0.1 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 11.0.2 > > > Paste the below SQL in the transformation editor to create a view table: > SELECT > trim(INTKEY),trim(STRINGKEY),trim(INTNUM),trim(STRINGNUM),trim(FLOATNUM),trim(LONGNUM),trim(DOUBLENUM),trim(BYTENUM),trim(DATEVALUE),trim(TIMESTAMPVALUE), trim(BOOLEANVALUE),trim(CHARVALUE),trim(SHORTVALUE),trim(BIGINTEGERVALUE),trim(BIGDECIMALVALUE),trim(OBJECTVALUE) > FROM > bqtora.LARGEB > Once you save it, it gets rewritten with the defaults, but it leaves the column name out most of the time: > SELECT > trim(' ' FROM ), trim(' ' FROM bqtora.LARGEB.STRINGKEY), trim(' ' FROM ), trim(' ' FROM bqtora.LARGEB.STRINGNUM), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM bqtora.LARGEB.OBJECTVALUE) > FROM > bqtora.LARGEB > So obviously you receive a validation parsing error: > ERROR: Error in parsing of sql - Encountered " ")" ") "" at line 2, column 31. > Was expecting one of: > "char" ... > "date" ... > "time" ... > "timestamp" ... > "cast" ... > "convert" ... > "any" ... > "array_agg" ... > "case" ... > "exists" ... > "false" ... > "hour" ... > "insert" ... > "left" ... > "minute" ... > "month" ... > "not" ... > "null" ... > "right" ... > "second" ... > "some" ... > "translate" ... > "true" ... > "unknown" ... > "user" ... > "year" ... > "xmlagg" ... > "xmlcast" ... > "xmlconcat" ... > "xmlcomment" ... > "xmlelement" ... > "xmlexists" ... > "xmlforest" ... > "xmlparse" ... > "xmlpi" ... > "xmlquery" ... > "xmlserialize" ... > "xmltext" ... > "instead" ... > "enabled" ... > "disabled" ... > "view" ... > "key" ... > "serial" ... > "textagg" ... > "count" ... > "row_number" ... > "rank" ... > "dense_rank" ... > "sum" ... > "avg" ... > "min" ... > "max" ... > "every" ... > "stddev_pop" ... > "stddev_samp" ... > "var_samp" ... > "var_pop" ... > "document" ... > "content" ... > "trim" ... > "empty" ... > "ordinality" ... > "path" ... > "first" ... > "last" ... > "next" ... > "substring" ... > "extract" ... > "to_chars" ... > "to_bytes" ... > "timestampadd" ... > "timestampdiff" ... > "querystring" ... > "namespace" ... > "result" ... > "index" ... > "accesspattern" ... > "auto_increment" ... > "wellformed" ... > "sql_tsi_frac_second" ... > "sql_tsi_second" ... > "sql_tsi_minute" ... > "sql_tsi_hour" ... > "sql_tsi_day" ... > "sql_tsi_week" ... > "sql_tsi_month" ... > "sql_tsi_quarter" ... > "sql_tsi_year" ... > "texttable" ... > "arraytable" ... > "selector" ... > "skip" ... > "width" ... > "passing" ... > "name" ... > "encoding" ... > "columns" ... > "delimiter" ... > "quote" ... > "header" ... > "nulls" ... > "objecttable" ... > "version" ... > "including" ... > "excluding" ... > "xmldeclaration" ... > "variadic" ... > "exception" ... > "raise" ... > "chain" ... > "jsonarray_agg" ... > "jsonobject" ... > "preserve" ... > <ID> ... > <ESCAPEDFUNCTION> ... > <ESCAPEDTYPE> ... > <DECIMALVAL> ... > <FLOATVAL> ... > <STRINGVAL> ... > <UNSIGNEDINTEGER> ... > <BINARYSTRINGVAL> ... > "(" ... > "+" ... > "-" ... > "?" ... > "$" ... > -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 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 May 2017