January 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4666) Google translator throws SpreadsheetOperationException for query DELETE FROM table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4666?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-4666: ----------------------------------- Based upon the comments below, this can be reopened to cover the case when delete/update has no predicate. Another issue will be captured to handle the scenario when all non-header rows are deleted. > Google translator throws SpreadsheetOperationException for query DELETE FROM table > ---------------------------------------------------------------------------------- > > Key: TEIID-4666 > URL: https://issues.jboss.org/browse/TEIID-4666 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.12.8.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Attachments: googlespreadsheetcrud-vdb.xml, server.log, standalone.xml, teiid-4666.png > > > Query "DELETE FROM smalla" where smalla is table throws exception: > 07:06:52,219 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue20) Connector worker process failed for atomic-request=IlMZP21M8Gwr.8.0.2: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error getting spreadsheet feed. Possibly bad authentication or connection problems. com.google.gdata.util.InvalidEntryException: Bad Request > Invalid query parameter value for sq. > Please see server.log, standalone.xml and vdb for other information. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4661) Subsequent queries hang after materialized view TTL expires.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4661?page=com.atlassian.jira.plugin... ] Work on TEIID-4661 started by Steven Hawkins. --------------------------------------------- > Subsequent queries hang after materialized view TTL expires. > ------------------------------------------------------------ > > Key: TEIID-4661 > URL: https://issues.jboss.org/browse/TEIID-4661 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.x > Reporter: Colin Mondesir > Assignee: Steven Hawkins > > In a clustered configuration initially the materialized view is cached correctly but when the TTL expires (10 minutes) and the query is run again the state of the view changes to LOADING and never reverts to "LOADED", so the next query hangs. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4666) Google translator throws SpreadsheetOperationException for query DELETE FROM table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4666?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4666: --------------------------------------- Deleting all rows is possible, but highlights a new issue. Once the non-header rows are gone, google will automatically interpret the header row as a data row instead. This causes issues with subsequent select/update/delete operations or with a re-import of the metadata. > Google translator throws SpreadsheetOperationException for query DELETE FROM table > ---------------------------------------------------------------------------------- > > Key: TEIID-4666 > URL: https://issues.jboss.org/browse/TEIID-4666 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.12.8.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Attachments: googlespreadsheetcrud-vdb.xml, server.log, standalone.xml, teiid-4666.png > > > Query "DELETE FROM smalla" where smalla is table throws exception: > 07:06:52,219 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue20) Connector worker process failed for atomic-request=IlMZP21M8Gwr.8.0.2: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error getting spreadsheet feed. Possibly bad authentication or connection problems. com.google.gdata.util.InvalidEntryException: Bad Request > Invalid query parameter value for sq. > Please see server.log, standalone.xml and vdb for other information. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4666) Google translator throws SpreadsheetOperationException for query DELETE FROM table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4666?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4666: --------------------------------------- To clarify Q1 was causing a NPE on our side with the initial fix for TEIID-4468. It does appear that google expects a predicate for the delete and thus an exception on their side. We'll have to see if there is a workaround for this, such as a dummy predicate. If not, then that will simply be an unsupported operation. > Google translator throws SpreadsheetOperationException for query DELETE FROM table > ---------------------------------------------------------------------------------- > > Key: TEIID-4666 > URL: https://issues.jboss.org/browse/TEIID-4666 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.12.8.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Attachments: googlespreadsheetcrud-vdb.xml, server.log, standalone.xml, teiid-4666.png > > > Query "DELETE FROM smalla" where smalla is table throws exception: > 07:06:52,219 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue20) Connector worker process failed for atomic-request=IlMZP21M8Gwr.8.0.2: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error getting spreadsheet feed. Possibly bad authentication or connection problems. com.google.gdata.util.InvalidEntryException: Bad Request > Invalid query parameter value for sq. > Please see server.log, standalone.xml and vdb for other information. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4666) Google translator throws SpreadsheetOperationException for query DELETE FROM table

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4666?page=com.atlassian.jira.plugin... ] Lucie Fabrikova edited comment on TEIID-4666 at 1/4/17 6:23 AM: ---------------------------------------------------------------- I tested queries Q1: "delete from smalla", Q2: "SELECT intnum FROM SmallA where smalla.intnum <> 0" on WildFly 10.0.0 + teiid 9.1.1: - Q1 failed with same exception as in attachment (it differs in line number: at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.deleteRows(SpreadsheetConnectionImpl.java:137)) - Q2 passed (returned only not-null values) was (Author: lfabriko): I tested queries Q1: "delete from smalla", Q2: "SELECT intnum FROM SmallA where smalla.intnum <> 0" on WildFly 10.0.0 + teiid 9.1.1: - Q1 failed with same exception as in attachment (it differs in line number: at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.deleteRows(SpreadsheetConnectionImpl.java:137)) - Q2 passed > Google translator throws SpreadsheetOperationException for query DELETE FROM table > ---------------------------------------------------------------------------------- > > Key: TEIID-4666 > URL: https://issues.jboss.org/browse/TEIID-4666 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.12.8.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Attachments: googlespreadsheetcrud-vdb.xml, server.log, standalone.xml, teiid-4666.png > > > Query "DELETE FROM smalla" where smalla is table throws exception: > 07:06:52,219 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue20) Connector worker process failed for atomic-request=IlMZP21M8Gwr.8.0.2: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error getting spreadsheet feed. Possibly bad authentication or connection problems. com.google.gdata.util.InvalidEntryException: Bad Request > Invalid query parameter value for sq. > Please see server.log, standalone.xml and vdb for other information. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4666) Google translator throws SpreadsheetOperationException for query DELETE FROM table

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4666?page=com.atlassian.jira.plugin... ] Lucie Fabrikova commented on TEIID-4666: ---------------------------------------- I tested queries Q1: "delete from smalla", Q2: "SELECT intnum FROM SmallA where smalla.intnum <> 0" on WildFly 10.0.0 + teiid 9.1.1: - Q1 failed with same exception as in attachment (it differs in line number: at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.deleteRows(SpreadsheetConnectionImpl.java:137)) ) - Q2 passed > Google translator throws SpreadsheetOperationException for query DELETE FROM table > ---------------------------------------------------------------------------------- > > Key: TEIID-4666 > URL: https://issues.jboss.org/browse/TEIID-4666 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.12.8.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Attachments: googlespreadsheetcrud-vdb.xml, server.log, standalone.xml, teiid-4666.png > > > Query "DELETE FROM smalla" where smalla is table throws exception: > 07:06:52,219 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue20) Connector worker process failed for atomic-request=IlMZP21M8Gwr.8.0.2: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error getting spreadsheet feed. Possibly bad authentication or connection problems. com.google.gdata.util.InvalidEntryException: Bad Request > Invalid query parameter value for sq. > Please see server.log, standalone.xml and vdb for other information. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4666) Google translator throws SpreadsheetOperationException for query DELETE FROM table

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4666?page=com.atlassian.jira.plugin... ] Lucie Fabrikova edited comment on TEIID-4666 at 1/4/17 6:20 AM: ---------------------------------------------------------------- I tested queries Q1: "delete from smalla", Q2: "SELECT intnum FROM SmallA where smalla.intnum <> 0" on WildFly 10.0.0 + teiid 9.1.1: - Q1 failed with same exception as in attachment (it differs in line number: at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.deleteRows(SpreadsheetConnectionImpl.java:137)) - Q2 passed was (Author: lfabriko): I tested queries Q1: "delete from smalla", Q2: "SELECT intnum FROM SmallA where smalla.intnum <> 0" on WildFly 10.0.0 + teiid 9.1.1: - Q1 failed with same exception as in attachment (it differs in line number: at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.deleteRows(SpreadsheetConnectionImpl.java:137)) ) - Q2 passed > Google translator throws SpreadsheetOperationException for query DELETE FROM table > ---------------------------------------------------------------------------------- > > Key: TEIID-4666 > URL: https://issues.jboss.org/browse/TEIID-4666 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.12.8.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Attachments: googlespreadsheetcrud-vdb.xml, server.log, standalone.xml, teiid-4666.png > > > Query "DELETE FROM smalla" where smalla is table throws exception: > 07:06:52,219 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue20) Connector worker process failed for atomic-request=IlMZP21M8Gwr.8.0.2: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error getting spreadsheet feed. Possibly bad authentication or connection problems. com.google.gdata.util.InvalidEntryException: Bad Request > Invalid query parameter value for sq. > Please see server.log, standalone.xml and vdb for other information. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4647) Add Kerberos support to the MongoDB

by John Archer (JIRA)

[ https://issues.jboss.org/browse/TEIID-4647?page=com.atlassian.jira.plugin... ] John Archer commented on TEIID-4647: ------------------------------------ just a quick thought - You might want to check with the Feedhenry team to see if they have the enterprise version of MongoDB. > Add Kerberos support to the MongoDB > ------------------------------------ > > Key: TEIID-4647 > URL: https://issues.jboss.org/browse/TEIID-4647 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 9.2 > Reporter: Van Halbert > > Add support for kerberos in MongoDB resource adapter. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4668) Google translator skips NULL value in INSERT

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4668?page=com.atlassian.jira.plugin... ] Work on TEIID-4668 started by Steven Hawkins. --------------------------------------------- > Google translator skips NULL value in INSERT > -------------------------------------------- > > Key: TEIID-4668 > URL: https://issues.jboss.org/browse/TEIID-4668 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.8.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0.6, 9.1.2, 9.2 > > Attachments: google-crud.png, googlespreadsheetcrud-vdb.xml > > > I have google spreadsheet table smalla with defined header columns intkey, intnum and other (see attached screenshot). > Following query doesn't insert NULL value to column intnum: > INSERT INTO smalla(intnum, intkey) values (null, 562) > Instead, it inserts 562 to intnum and NULL to intkey. > (Server log shows no exception) > INSERT works correctly if none of the inserted values is NULL. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4668) Google translator skips NULL value in INSERT

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4668?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4668: ---------------------------------- Fix Version/s: 9.0.6 9.1.2 9.2 Priority: Blocker (was: Major) Updating to blocker since this corrupts the insert. > Google translator skips NULL value in INSERT > -------------------------------------------- > > Key: TEIID-4668 > URL: https://issues.jboss.org/browse/TEIID-4668 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.8.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0.6, 9.1.2, 9.2 > > Attachments: google-crud.png, googlespreadsheetcrud-vdb.xml > > > I have google spreadsheet table smalla with defined header columns intkey, intnum and other (see attached screenshot). > Following query doesn't insert NULL value to column intnum: > INSERT INTO smalla(intnum, intkey) values (null, 562) > Instead, it inserts 562 to intnum and NULL to intkey. > (Server log shows no exception) > INSERT works correctly if none of the inserted values is NULL. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 4 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2017