February 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3316) MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1

by Ivan Chan (JIRA)

[ https://issues.jboss.org/browse/TEIID-3316?page=com.atlassian.jira.plugin... ] Ivan Chan commented on TEIID-3316: ---------------------------------- Unfortunately, I got the same null pointer exception using Teiid 8.10 CR2 version again MongoDB 2.4.8 with the step in comment 3. (But works for MongoDB 2.6.6) Thanks for looking into this issue. Caused by: java.lang.NullPointerException at org.teiid.translator.mongodb.MongoDBQueryExecution.close(MongoDBQueryExecution.java:149) at org.teiid.translator.mongodb.MongoDBQueryExecution.cancel(MongoDBQueryExecution.java:155) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.cancel(ConnectorWorkItem.java:193) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:209) at $Proxy183.cancel(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.fullyCloseSource(DataTierTupleSource.java:323) at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:378) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:154) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:369) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:455) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:337) > MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1 > -------------------------------------------------------------------------------------------------- > > Key: TEIID-3316 > URL: https://issues.jboss.org/browse/TEIID-3316 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.9.1 > Environment: Teiid 8.9.1 with MongoDB shell version: 2.4.8 using MongoDB Driver mongo-java-driver-2.12.3.jar > Reporter: Ivan Chan > Assignee: Ramesh Reddy > Fix For: 8.10 > > > I am getting the following erroe when connecting to MongoDB using Teiid 8.9.1: > Caused by: com.mongodb.CommandFailureException: { "serverUsed" : "donetsk:27017" , "ok" : 0.0 , "errmsg" : "unrecognized field \"cursor"} > at com.mongodb.CommandResult.getException(CommandResult.java:76) > at com.mongodb.CommandResult.throwOnError(CommandResult.java:131) > at com.mongodb.DBCollectionImpl.aggregate(DBCollectionImpl.java:100) > at com.mongodb.DBCollection.aggregate(DBCollection.java:1571) > at org.teiid.translator.mongodb.MongoDBQueryExecution.execute(MongoDBQueryExecution.java:111) -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3316) MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1

by Ivan Chan (JIRA)

[ https://issues.jboss.org/browse/TEIID-3316?page=com.atlassian.jira.plugin... ] Ivan Chan edited comment on TEIID-3316 at 2/20/15 1:22 PM: ----------------------------------------------------------- Thanks. Sure. Let me test it out today. was (Author: ichanjasper): Sure. Let me test it out today. > MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1 > -------------------------------------------------------------------------------------------------- > > Key: TEIID-3316 > URL: https://issues.jboss.org/browse/TEIID-3316 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.9.1 > Environment: Teiid 8.9.1 with MongoDB shell version: 2.4.8 using MongoDB Driver mongo-java-driver-2.12.3.jar > Reporter: Ivan Chan > Assignee: Ramesh Reddy > Fix For: 8.10 > > > I am getting the following erroe when connecting to MongoDB using Teiid 8.9.1: > Caused by: com.mongodb.CommandFailureException: { "serverUsed" : "donetsk:27017" , "ok" : 0.0 , "errmsg" : "unrecognized field \"cursor"} > at com.mongodb.CommandResult.getException(CommandResult.java:76) > at com.mongodb.CommandResult.throwOnError(CommandResult.java:131) > at com.mongodb.DBCollectionImpl.aggregate(DBCollectionImpl.java:100) > at com.mongodb.DBCollection.aggregate(DBCollection.java:1571) > at org.teiid.translator.mongodb.MongoDBQueryExecution.execute(MongoDBQueryExecution.java:111) -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3316) MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1

by Ivan Chan (JIRA)

[ https://issues.jboss.org/browse/TEIID-3316?page=com.atlassian.jira.plugin... ] Ivan Chan commented on TEIID-3316: ---------------------------------- Sure. Let me test it out today. > MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1 > -------------------------------------------------------------------------------------------------- > > Key: TEIID-3316 > URL: https://issues.jboss.org/browse/TEIID-3316 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.9.1 > Environment: Teiid 8.9.1 with MongoDB shell version: 2.4.8 using MongoDB Driver mongo-java-driver-2.12.3.jar > Reporter: Ivan Chan > Assignee: Ramesh Reddy > Fix For: 8.10 > > > I am getting the following erroe when connecting to MongoDB using Teiid 8.9.1: > Caused by: com.mongodb.CommandFailureException: { "serverUsed" : "donetsk:27017" , "ok" : 0.0 , "errmsg" : "unrecognized field \"cursor"} > at com.mongodb.CommandResult.getException(CommandResult.java:76) > at com.mongodb.CommandResult.throwOnError(CommandResult.java:131) > at com.mongodb.DBCollectionImpl.aggregate(DBCollectionImpl.java:100) > at com.mongodb.DBCollection.aggregate(DBCollection.java:1571) > at org.teiid.translator.mongodb.MongoDBQueryExecution.execute(MongoDBQueryExecution.java:111) -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3316) MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3316?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3316: ------------------------------------- Can you try with CR2 from yesterday, if it still occurs then yes open a JIRA. I will try to fix before the 8.10 Final > MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1 > -------------------------------------------------------------------------------------------------- > > Key: TEIID-3316 > URL: https://issues.jboss.org/browse/TEIID-3316 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.9.1 > Environment: Teiid 8.9.1 with MongoDB shell version: 2.4.8 using MongoDB Driver mongo-java-driver-2.12.3.jar > Reporter: Ivan Chan > Assignee: Ramesh Reddy > Fix For: 8.10 > > > I am getting the following erroe when connecting to MongoDB using Teiid 8.9.1: > Caused by: com.mongodb.CommandFailureException: { "serverUsed" : "donetsk:27017" , "ok" : 0.0 , "errmsg" : "unrecognized field \"cursor"} > at com.mongodb.CommandResult.getException(CommandResult.java:76) > at com.mongodb.CommandResult.throwOnError(CommandResult.java:131) > at com.mongodb.DBCollectionImpl.aggregate(DBCollectionImpl.java:100) > at com.mongodb.DBCollection.aggregate(DBCollection.java:1571) > at org.teiid.translator.mongodb.MongoDBQueryExecution.execute(MongoDBQueryExecution.java:111) -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3316) MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1

by Ivan Chan (JIRA)

[ https://issues.jboss.org/browse/TEIID-3316?page=com.atlassian.jira.plugin... ] Ivan Chan commented on TEIID-3316: ---------------------------------- Should I file a new bug for what I found in comment 3? > MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1 > -------------------------------------------------------------------------------------------------- > > Key: TEIID-3316 > URL: https://issues.jboss.org/browse/TEIID-3316 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.9.1 > Environment: Teiid 8.9.1 with MongoDB shell version: 2.4.8 using MongoDB Driver mongo-java-driver-2.12.3.jar > Reporter: Ivan Chan > Assignee: Ramesh Reddy > Fix For: 8.10 > > > I am getting the following erroe when connecting to MongoDB using Teiid 8.9.1: > Caused by: com.mongodb.CommandFailureException: { "serverUsed" : "donetsk:27017" , "ok" : 0.0 , "errmsg" : "unrecognized field \"cursor"} > at com.mongodb.CommandResult.getException(CommandResult.java:76) > at com.mongodb.CommandResult.throwOnError(CommandResult.java:131) > at com.mongodb.DBCollectionImpl.aggregate(DBCollectionImpl.java:100) > at com.mongodb.DBCollection.aggregate(DBCollection.java:1571) > at org.teiid.translator.mongodb.MongoDBQueryExecution.execute(MongoDBQueryExecution.java:111) -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3347) Most subplans do not show node stats

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3347: ------------------------------------- Summary: Most subplans do not show node stats Key: TEIID-3347 URL: https://issues.jboss.org/browse/TEIID-3347 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.11 When looking at the node stats, only the direct nodes of the current plan have stats. Subqueries, which are executed off of a cloned plan, do not have stats. There isn't an easy solution for this with the current design. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2694) Support for Blob Input in Teiid REST services

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2694?page=com.atlassian.jira.plugin... ] Ramesh Reddy edited comment on TEIID-2694 at 2/20/15 7:51 AM: -------------------------------------------------------------- https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB The summary is the previous POST methods continue to work as is, unless procedure contains a BLOB/CLOB/XML as one of the parameters, then "multipart" protocol will be used for POST. VARBINARY type parameter irrespective of the HTTP method used they need to be properly encoded in BASE64 encoding. sorry, the last commit went with wrong commit JIRA # TEIID-2943 instead of TEIID-2694 was (Author: rareddy): https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB The summary is the previous POST methods continue to work as is, unless procedure contains a BLOB/CLOB/XML or VARBINARY as one of the parameters. If yes, then "mutlipart" will b used. > Support for Blob Input in Teiid REST services > --------------------------------------------- > > Key: TEIID-2694 > URL: https://issues.jboss.org/browse/TEIID-2694 > Project: Teiid > Issue Type: Enhancement > Affects Versions: 8.5 > Environment: EAP 6.1 Alpha , Teiid 8.5 > Reporter: Madhu Garimilla > Assignee: Ramesh Reddy > Labels: Final > Fix For: 8.10 > > > We are trying to upload large files as Blobs using Teiid REST service through VDB. Though we are writing the Blob objects to HttpUrlConnection object, it is not received on REST method. As per the conversation in the thread "https://community.jboss.org/thread/232840" Current parameter handling is done through strings and needs be enhanced to support Blob objects. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3346) File Source | Dot in file column names causes VDB deployment errors

by Shiveeta Mattoo (JIRA)

Shiveeta Mattoo created TEIID-3346: -------------------------------------- Summary: File Source | Dot in file column names causes VDB deployment errors Key: TEIID-3346 URL: https://issues.jboss.org/browse/TEIID-3346 Project: Teiid Issue Type: Bug Reporter: Shiveeta Mattoo Assignee: Steven Hawkins In case a Delimited Flat file , contains a "Dot" character in any of the column names, we get an issue during Virtual Data Base deployment - Root cause - org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "'UTF-8') COLUMNS [*]\"name.full\"[*] STRING," at line 1, column 126. Invalid simple identifier format: [name.full] The query is : SELECT A."name.full",A."surname" FROM (EXEC tabwithdot.getFiles('tab.csv')) AS F, TEXTTABLE(TO_CHARS(F.file,'UTF-8') COLUMNS "name.full" STRING,"surname" STRING delimiter ' ' quote ' ' HEADER) AS A Please note, that although the column name [name.full], is enclosed in Double Quotes, still this issue is observed. If there was instead any other special character, that works successfully. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2694) Support for Blob Input in Teiid REST services

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2694?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2694: ------------------------------------- https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB The summary is the previous POST methods continue to work as is, unless procedure contains a BLOB/CLOB/XML or VARBINARY as one of the parameters. If yes, then "mutlipart" will b used. > Support for Blob Input in Teiid REST services > --------------------------------------------- > > Key: TEIID-2694 > URL: https://issues.jboss.org/browse/TEIID-2694 > Project: Teiid > Issue Type: Enhancement > Affects Versions: 8.5 > Environment: EAP 6.1 Alpha , Teiid 8.5 > Reporter: Madhu Garimilla > Assignee: Ramesh Reddy > Labels: Final > Fix For: 8.10 > > > We are trying to upload large files as Blobs using Teiid REST service through VDB. Though we are writing the Blob objects to HttpUrlConnection object, it is not received on REST method. As per the conversation in the thread "https://community.jboss.org/thread/232840" Current parameter handling is done through strings and needs be enhanced to support Blob objects. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2694) Support for Blob Input in Teiid REST services

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2694?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2694: ------------------------------------- thanks. got it. I will update documentation accordingly > Support for Blob Input in Teiid REST services > --------------------------------------------- > > Key: TEIID-2694 > URL: https://issues.jboss.org/browse/TEIID-2694 > Project: Teiid > Issue Type: Enhancement > Affects Versions: 8.5 > Environment: EAP 6.1 Alpha , Teiid 8.5 > Reporter: Madhu Garimilla > Assignee: Ramesh Reddy > Labels: Final > Fix For: 8.10 > > > We are trying to upload large files as Blobs using Teiid REST service through VDB. Though we are writing the Blob objects to HttpUrlConnection object, it is not received on REST method. As per the conversation in the thread "https://community.jboss.org/thread/232840" Current parameter handling is done through strings and needs be enhanced to support Blob objects. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 3 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2015