[JBoss JIRA] (TEIID-4467) Google translator throws exception invalid_query for GROUP BY
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4467?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4467:
----------------------------------
Fix Version/s: 9.3
(was: 9.2)
> Google translator throws exception invalid_query for GROUP BY
> --------------------------------------------------------------
>
> Key: TEIID-4467
> URL: https://issues.jboss.org/browse/TEIID-4467
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12
> Reporter: Lucie Fabrikova
> Fix For: 9.3
>
> Attachments: googlespreadsheet-vdb.xml, server.log
>
>
> Google translator produces following exception for a query: "SELECT IntKey FROM bqt1.SmallA GROUP BY IntKey":
> 16:27:26,955 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue14) TEIID30019 Unexpected exception for request vn+N1XY8Atf5.6: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: [invalid_query]
> at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDataProtocolAPI.java:196)
> ...
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 4 months
[JBoss JIRA] (TEIID-4500) Make documents to capable of building outside the GitBooks
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4500?page=com.atlassian.jira.plugin... ]
Steven Hawkins reassigned TEIID-4500:
-------------------------------------
Fix Version/s: 10.0
(was: 9.2)
Assignee: (was: Steven Hawkins)
> Make documents to capable of building outside the GitBooks
> ----------------------------------------------------------
>
> Key: TEIID-4500
> URL: https://issues.jboss.org/browse/TEIID-4500
> Project: Teiid
> Issue Type: Task
> Components: Documentation
> Reporter: Ramesh Reddy
> Fix For: 10.0
>
>
> Currently Teiid documentation is only built by automated process by GitBooks. However, this causes couple issues
> * There is no way to check the documentation formatting external to the GitBook.
> * Documents need to be always hosted by the Gitbook. I am sure there is way to export, but that may need human to do that? Going forward we would need a automated way if one wants to bundle the documents.
> * Gitbook only allows two books for free, we already against this limit with no resolution with the paid route.
> Thus it may be better we also have alternative ways to generate final documents, and be able to host on teiid.org. I find an example with Infinispan documents, we just need to mimic what they are doing
> >> We have also implemented generation of PDFs via the
> > > asciidoctor-maven-plugin with optimized post-processing via GhostScript
> > > (which shrinks the size of the PDFs to a 1/4 of the size).
> > > Look at [2] and [3] to see how that is done.
> > >
> > > Tristan
> > >
> > > [1] http://infinispan.org/docs/dev/user_guide/user_guide.html
> > > [2]
> > > https://github.com/infinispan/infinispan/blob/master/documentation/pom.xml
> > > [3]
> > > https://github.com/infinispan/infinispan/blob/master/documentation/optimi...
> also look at their google-analytics stuff, that is very useful to have. I do also like Infinispans style sheets better than the current default GitBook's, we should adapt them too.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 4 months
[JBoss JIRA] (TEIID-4557) Enable memory management at the query level
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4557?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4557:
---------------------------------------
For this to be worked in 9.2/9.3 we need more direction based upon the comment above. What is the priority order out of the actionable items mentioned?
> Enable memory management at the query level
> -------------------------------------------
>
> Key: TEIID-4557
> URL: https://issues.jboss.org/browse/TEIID-4557
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Fix For: 9.2
>
>
> Allows managing (and limiting if needed) the memory consumed by the execution of a particular view. Maybe this can be done through a max. memory and swapping settings on the view.
> Would it also be possible to set a global memory limit for the execution of any query in the server or in a particular VDB. This provides a simple and general setting to guarantee no query can monopolize server resources
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 4 months
[JBoss JIRA] (TEIID-4523) CXF is not used by Salesforce BulkConnection
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4523?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4523:
----------------------------------
Fix Version/s: 9.3
(was: 9.2)
> CXF is not used by Salesforce BulkConnection
> --------------------------------------------
>
> Key: TEIID-4523
> URL: https://issues.jboss.org/browse/TEIID-4523
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Affects Versions: 8.12
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.3
>
>
> TEIID-3493 added the CXF transport, but it's not used by the salesforce BulkConnection. In v22 they make use of a static call, so we won't make a change there. With 34 we can extend the SalesforceConnectorConfig createConnection - but a HttpURLConnection is expected so this may not be straight-forward.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 4 months
[JBoss JIRA] (TEIID-4427) Migration to Teiid 9.0.0 - Materialized views error: Expected integer, but was bigdecimal
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4427?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4427:
---------------------------------------
This may be related to TEIID-4648 - the mysql driver reports everything as unsigned, so our logic needs to be adjusted to account for that.
> Migration to Teiid 9.0.0 - Materialized views error: Expected integer, but was bigdecimal
> -----------------------------------------------------------------------------------------
>
> Key: TEIID-4427
> URL: https://issues.jboss.org/browse/TEIID-4427
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 9.0
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 9.2
>
>
> After migrating to Teiid 9.0.0, we are facing issues with existing views materialized on Oracle server.
> when fetching an Oracle materialized view that contains a column using date function like : "Month" or "Year" or "TIMESTAMPDIFF", we are getting the error : Expected integer, but was bigdecimal.
> If we go back to Teiid 8.11.3, the same materialized views fetch without any problem.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 4 months
[JBoss JIRA] (TEIID-4663) Support a more secure block mode for client/server encryption
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-4663:
-------------------------------------
Summary: Support a more secure block mode for client/server encryption
Key: TEIID-4663
URL: https://issues.jboss.org/browse/TEIID-4663
Project: Teiid
Issue Type: Quality Risk
Components: JDBC Driver, Server
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 9.0.6, 9.1.2, 9.2
ECB is the current default for the socket transport encryption of secure messages. While this is relatively ok for small messages as we also have a message key acting as a CTR counter to some of the blocks, it does not provide strong security - especially for large data volume scenarios, such as when using larger login payloads or the secure requests option. We should default instead to CBC with an explicit initialization vector.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 4 months
[JBoss JIRA] (TEIID-4662) jBPM workbench may give us some hints for a moderner web ui
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4662?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-4662:
------------------------------------
It looks kie workbench is a sub-project of droolsjbpm, we may develop our web-ui base on it.
> jBPM workbench may give us some hints for a moderner web ui
> -----------------------------------------------------------
>
> Key: TEIID-4662
> URL: https://issues.jboss.org/browse/TEIID-4662
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Kylin Soong
> Assignee: Steven Hawkins
> Attachments: screen-1.png, screen-2.png, screen-3.png, screen-4.png
>
>
> I have installed a jBPM and looked it roughly, found that the jbpm workbench looks beautify, especially there is a DataSet panels, almost do the same work of what Our designer do, as [1], current, RDBMS. excel/csv file, Elastic Search be support to import and mapping in web UI.
> Also the UI more moderner than our Designer, I would attach some screenshot
> [1] https://docs.jboss.org/jbpm/release/6.5.0.Final/jbpm-docs/html/ch09.html#...
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 4 months
[JBoss JIRA] (TEIID-4662) jBPM workbench may give us some hints for a moderner web ui
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4662?page=com.atlassian.jira.plugin... ]
Kylin Soong updated TEIID-4662:
-------------------------------
Attachment: screen-4.png
> jBPM workbench may give us some hints for a moderner web ui
> -----------------------------------------------------------
>
> Key: TEIID-4662
> URL: https://issues.jboss.org/browse/TEIID-4662
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Kylin Soong
> Assignee: Steven Hawkins
> Attachments: screen-1.png, screen-2.png, screen-3.png, screen-4.png
>
>
> I have installed a jBPM and looked it roughly, found that the jbpm workbench looks beautify, especially there is a DataSet panels, almost do the same work of what Our designer do, as [1], current, RDBMS. excel/csv file, Elastic Search be support to import and mapping in web UI.
> Also the UI more moderner than our Designer, I would attach some screenshot
> [1] https://docs.jboss.org/jbpm/release/6.5.0.Final/jbpm-docs/html/ch09.html#...
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 4 months
[JBoss JIRA] (TEIID-4662) jBPM workbench may give us some hints for a moderner web ui
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4662?page=com.atlassian.jira.plugin... ]
Kylin Soong updated TEIID-4662:
-------------------------------
Attachment: screen-3.png
> jBPM workbench may give us some hints for a moderner web ui
> -----------------------------------------------------------
>
> Key: TEIID-4662
> URL: https://issues.jboss.org/browse/TEIID-4662
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Kylin Soong
> Assignee: Steven Hawkins
> Attachments: screen-1.png, screen-2.png, screen-3.png
>
>
> I have installed a jBPM and looked it roughly, found that the jbpm workbench looks beautify, especially there is a DataSet panels, almost do the same work of what Our designer do, as [1], current, RDBMS. excel/csv file, Elastic Search be support to import and mapping in web UI.
> Also the UI more moderner than our Designer, I would attach some screenshot
> [1] https://docs.jboss.org/jbpm/release/6.5.0.Final/jbpm-docs/html/ch09.html#...
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years, 4 months