[JBoss JIRA] (TEIIDDES-2502) Incorrect transformation reconciliation
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2502?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2502:
----------------------------------------
Tested on Linux on fresh 8.0.0 JBDS + Designer 9.0.1.Final and the SQL was not changed.
[~virtualdatabase] Wondering if your copy/paste from in Windows from a Notepad, or other text editor may have ended up pasting some hidden/special characters in the T-Editor?
Gonna try and test with Windows tomorrow
> Incorrect transformation reconciliation
> ---------------------------------------
>
> Key: TEIIDDES-2502
> URL: https://issues.jboss.org/browse/TEIIDDES-2502
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling, Transformations
> Affects Versions: 9.0.1
> Environment: 9.0.1.Final-v20150211-1407-B643
> JBDS / Designer on Windows
> Reporter: Tom Johnston
> Assignee: Barry LaFond
>
> SELECT
> proj.\*, act.\*, cm.Field_Num, cm.Identity_Token, f.Plant_Num
> FROM
> ((Table1 AS act LEFT OUTER JOIN Table2 AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN Table4 AS cm ON cm.Contract_ID = f.Contract_ID
> ORDER BY act.Crop_Year
> "resolves"
> to:
> SELECT
> Table2 AS proj.\*,
> Table1 AS act.\*, cm.Field_Num, cm.Identity_Token,
> f.Plant_Num
> FROM
> ((Table1 AS act LEFT OUTER JOIN
> Table2 AS proj ON proj.Field_ID = act.Field_ID)
> LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN
> Table4 AS cm ON cm.Contract_ID = f.Contract_ID
> ORDER BY act.Crop_Year
> with error:
> ERROR: Error in parsing of sql - Encountered " <ALL_IN_GROUP> "proj.\* "" at
> line 2, column 54.
> Was expecting one of:
> "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" ...
> <ID> ...
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2480) LDAP importer fails silently when no location is explicitly entered for the new model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2480?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2480:
--------------------------------------
Assignee: Paul Richardson
> LDAP importer fails silently when no location is explicitly entered for the new model
> -------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2480
> URL: https://issues.jboss.org/browse/TEIIDDES-2480
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0
> Reporter: Marc Shirley
> Assignee: Paul Richardson
> Fix For: 9.1, 9.0.2, 8.6.2
>
>
> LDAP import fails silently when no location is entered for the "Source Model Definition" section's "Location" field on the first page of the wizard. This occurs even when using the context menu to initiate from a specific project or child object level. The wizard functions as expected until you finish, at which point the model is never generated. No error dialog or failure notification is presented to the user. checking error log shows:
> java.lang.NullPointerException
> at org.teiid.designer.modelgenerator.ldap.RelationalModelBuilder.createNewModelResource(RelationalModelBuilder.java:65)
> at org.teiid.designer.modelgenerator.ldap.RelationalModelBuilder.modelEntries(RelationalModelBuilder.java:109)
> at org.teiid.designer.modelgenerator.ldap.ui.wizards.LdapImportWizardManager.createModel(LdapImportWizardManager.java:384)
> at org.teiid.designer.modelgenerator.ldap.ui.wizards.LdapImportWizard$1.run(LdapImportWizard.java:158)
> at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2467) Query Results Table Hides Query Results
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2467?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2467:
----------------------------------------
This is an Eclipse Data Tools issue around their Results View. Need to check Eclipse BZ's and file a bug if none exists.
> Query Results Table Hides Query Results
> ---------------------------------------
>
> Key: TEIIDDES-2467
> URL: https://issues.jboss.org/browse/TEIIDDES-2467
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview
> Affects Versions: 9.0
> Reporter: Debbie Steigner
> Fix For: 9.1, 9.0.2, 8.6.2
>
>
> The query results table hides results for queries that have a number of rows that would fit inside of the window. After a query was updated, the Result hides the first row, and the user can not scroll up to see that row.
> This appears to occur on tables where the number of rows will all fit within the view without scrolling. In these situations the results are available only by clicking on the result tab content and scrolling up with the keyboard. Scrolling with the mouse does not work to show these hidden rows.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2509) Import from REST doesn't create View model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2509?page=com.atlassian.jira.plu... ]
Barry LaFond edited comment on TEIIDDES-2509 at 5/7/15 3:43 PM:
----------------------------------------------------------------
I verified this works in my IDE, however, in an installation if fails. Looks like a SAXON jar version issue:
Caused by: java.lang.ClassNotFoundException: net.sf.saxon.expr.PathMap$PathMapNode cannot be found by org.teiid.runtime.client_9.0.2.Beta1-v20150429-1449-B949
My IDE client plugin and my JBDS install have *org.jboss.tools.locus.sf.saxon_9.2.1.5j-Final-v20131024-0922-B58.jar*. BUT my install also has a newer jar: *org.jboss.tools.locus.sf.saxon_9.5.1.6-Final-v20150427-1451-B75.jar*. That jar does not have a PathMap class.
{code}
java.lang.NoClassDefFoundError: net/sf/saxon/expr/PathMap$PathMapNode
at org.teiid.query.sql.lang.XMLTable.compileXqueryExpression(XMLTable.java:124)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:398)
at org.teiid.query.sql.lang.XMLTable.acceptVisitor(XMLTable.java:183)
at org.teiid.query.sql.lang.SimpleNode.acceptVisitor(SimpleNode.java:1)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:69)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:82)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:335)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:661)
at org.teiid.query.sql.lang.From.acceptVisitor(From.java:119)
at org.teiid.query.sql.lang.SimpleNode.acceptVisitor(SimpleNode.java:1)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:69)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:277)
at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:121)
{code}
was (Author: blafond):
I verified this works in my IDE, however, in an installation if fails. Looks like a SAXON jar version issue:
Caused by: java.lang.ClassNotFoundException: net.sf.saxon.expr.PathMap$PathMapNode cannot be found by org.teiid.runtime.client_9.0.2.Beta1-v20150429-1449-B949
My IDE client plugin and my JBDS install have *org.jboss.tools.locus.sf.saxon_9.2.1.5j-Final-v20131024-0922-B58.jar*. BUT my install also has a newer jar: *org.jboss.tools.locus.sf.saxon_9.5.1.6-Final-v20150427-1451-B75.jar*
{code}
java.lang.NoClassDefFoundError: net/sf/saxon/expr/PathMap$PathMapNode
at org.teiid.query.sql.lang.XMLTable.compileXqueryExpression(XMLTable.java:124)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:398)
at org.teiid.query.sql.lang.XMLTable.acceptVisitor(XMLTable.java:183)
at org.teiid.query.sql.lang.SimpleNode.acceptVisitor(SimpleNode.java:1)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:69)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:82)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:335)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:661)
at org.teiid.query.sql.lang.From.acceptVisitor(From.java:119)
at org.teiid.query.sql.lang.SimpleNode.acceptVisitor(SimpleNode.java:1)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:69)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:277)
at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:121)
{code}
> Import from REST doesn't create View model
> ------------------------------------------
>
> Key: TEIIDDES-2509
> URL: https://issues.jboss.org/browse/TEIIDDES-2509
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.2 Beta1
> Environment: OSX, Fedora 20, Windows 7
> Reporter: Matus Makovy
> Assignee: Paul Richardson
> Priority: Blocker
> Fix For: 9.1, 9.0.2
>
> Attachments: Screen Shot 2015-05-06 at 12.19.49 PM.png
>
>
> Import from REST WS (both JSON and XML) doesn't create View model, only Source model is created
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2509) Import from REST doesn't create View model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2509?page=com.atlassian.jira.plu... ]
Barry LaFond edited comment on TEIIDDES-2509 at 5/7/15 3:42 PM:
----------------------------------------------------------------
I verified this works in my IDE, however, in an installation if fails. Looks like a SAXON jar version issue:
Caused by: java.lang.ClassNotFoundException: net.sf.saxon.expr.PathMap$PathMapNode cannot be found by org.teiid.runtime.client_9.0.2.Beta1-v20150429-1449-B949
My IDE client plugin and my JBDS install have *org.jboss.tools.locus.sf.saxon_9.2.1.5j-Final-v20131024-0922-B58.jar*. BUT my install also has a newer jar: *org.jboss.tools.locus.sf.saxon_9.5.1.6-Final-v20150427-1451-B75.jar*
{code}
java.lang.NoClassDefFoundError: net/sf/saxon/expr/PathMap$PathMapNode
at org.teiid.query.sql.lang.XMLTable.compileXqueryExpression(XMLTable.java:124)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:398)
at org.teiid.query.sql.lang.XMLTable.acceptVisitor(XMLTable.java:183)
at org.teiid.query.sql.lang.SimpleNode.acceptVisitor(SimpleNode.java:1)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:69)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:82)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:335)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:661)
at org.teiid.query.sql.lang.From.acceptVisitor(From.java:119)
at org.teiid.query.sql.lang.SimpleNode.acceptVisitor(SimpleNode.java:1)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:69)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:277)
at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:121)
{code}
was (Author: blafond):
I verified this works in my IDE, however, in an installation if fails. Looks like a SAXON jar version issue:
Caused by: java.lang.ClassNotFoundException: net.sf.saxon.expr.PathMap$PathMapNode cannot be found by org.teiid.runtime.client_9.0.2.Beta1-v20150429-1449-B949
My IDE client plugin and my JBDS install have org.jboss.tools.locus.sf.saxon_9.2.1.5j-Final-v20131024-0922-B58.jar. BUT my install also has a newer jar: org.jboss.tools.locus.sf.saxon_9.5.1.6-Final-v20150427-1451-B75.jar
{code}
java.lang.NoClassDefFoundError: net/sf/saxon/expr/PathMap$PathMapNode
at org.teiid.query.sql.lang.XMLTable.compileXqueryExpression(XMLTable.java:124)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:398)
at org.teiid.query.sql.lang.XMLTable.acceptVisitor(XMLTable.java:183)
at org.teiid.query.sql.lang.SimpleNode.acceptVisitor(SimpleNode.java:1)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:69)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:82)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:335)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:661)
at org.teiid.query.sql.lang.From.acceptVisitor(From.java:119)
at org.teiid.query.sql.lang.SimpleNode.acceptVisitor(SimpleNode.java:1)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:69)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:277)
at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:121)
{code}
> Import from REST doesn't create View model
> ------------------------------------------
>
> Key: TEIIDDES-2509
> URL: https://issues.jboss.org/browse/TEIIDDES-2509
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.2 Beta1
> Environment: OSX, Fedora 20, Windows 7
> Reporter: Matus Makovy
> Assignee: Paul Richardson
> Priority: Blocker
> Fix For: 9.1, 9.0.2
>
> Attachments: Screen Shot 2015-05-06 at 12.19.49 PM.png
>
>
> Import from REST WS (both JSON and XML) doesn't create View model, only Source model is created
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2509) Import from REST doesn't create View model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2509?page=com.atlassian.jira.plu... ]
Barry LaFond edited comment on TEIIDDES-2509 at 5/7/15 3:42 PM:
----------------------------------------------------------------
I verified this works in my IDE, however, in an installation if fails. Looks like a SAXON jar version issue:
Caused by: java.lang.ClassNotFoundException: net.sf.saxon.expr.PathMap$PathMapNode cannot be found by org.teiid.runtime.client_9.0.2.Beta1-v20150429-1449-B949
My IDE client plugin and my JBDS install have org.jboss.tools.locus.sf.saxon_9.2.1.5j-Final-v20131024-0922-B58.jar. BUT my install also has a newer jar: org.jboss.tools.locus.sf.saxon_9.5.1.6-Final-v20150427-1451-B75.jar
{code}
java.lang.NoClassDefFoundError: net/sf/saxon/expr/PathMap$PathMapNode
at org.teiid.query.sql.lang.XMLTable.compileXqueryExpression(XMLTable.java:124)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:398)
at org.teiid.query.sql.lang.XMLTable.acceptVisitor(XMLTable.java:183)
at org.teiid.query.sql.lang.SimpleNode.acceptVisitor(SimpleNode.java:1)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:69)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:82)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:335)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:661)
at org.teiid.query.sql.lang.From.acceptVisitor(From.java:119)
at org.teiid.query.sql.lang.SimpleNode.acceptVisitor(SimpleNode.java:1)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:69)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:277)
at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:121)
{code}
was (Author: blafond):
I verified this works in my IDE, however, in an installation if fails. Looks like a SAXON jar version issue:
Caused by: java.lang.ClassNotFoundException: net.sf.saxon.expr.PathMap$PathMapNode cannot be found by org.teiid.runtime.client_9.0.2.Beta1-v20150429-1449-B949
{code}
java.lang.NoClassDefFoundError: net/sf/saxon/expr/PathMap$PathMapNode
at org.teiid.query.sql.lang.XMLTable.compileXqueryExpression(XMLTable.java:124)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:398)
at org.teiid.query.sql.lang.XMLTable.acceptVisitor(XMLTable.java:183)
at org.teiid.query.sql.lang.SimpleNode.acceptVisitor(SimpleNode.java:1)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:69)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNodes(AbstractNavigator.java:82)
at org.teiid.query.sql.navigator.PreOrPostOrderNavigator.visit(PreOrPostOrderNavigator.java:335)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:661)
at org.teiid.query.sql.lang.From.acceptVisitor(From.java:119)
at org.teiid.query.sql.lang.SimpleNode.acceptVisitor(SimpleNode.java:1)
at org.teiid.query.sql.navigator.AbstractNavigator.visitNode(AbstractNavigator.java:69)
at org.teiid.query.resolver.command.SimpleQueryResolver$QueryResolverVisitor.visit(SimpleQueryResolver.java:277)
at org.teiid.query.resolver.command.SimpleQueryResolver.resolveCommand(SimpleQueryResolver.java:121)
{code}
> Import from REST doesn't create View model
> ------------------------------------------
>
> Key: TEIIDDES-2509
> URL: https://issues.jboss.org/browse/TEIIDDES-2509
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.2 Beta1
> Environment: OSX, Fedora 20, Windows 7
> Reporter: Matus Makovy
> Assignee: Paul Richardson
> Priority: Blocker
> Fix For: 9.1, 9.0.2
>
> Attachments: Screen Shot 2015-05-06 at 12.19.49 PM.png
>
>
> Import from REST WS (both JSON and XML) doesn't create View model, only Source model is created
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months