March 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4040) Representation of OData error does not contain error code.

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4040?page=com.atlassian.jira.plugin... ] Work on TEIID-4040 started by Ramesh Reddy. ------------------------------------------- > Representation of OData error does not contain error code. > ---------------------------------------------------------- > > Key: TEIID-4040 > URL: https://issues.jboss.org/browse/TEIID-4040 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > JSON: > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* \{"error":\{"code":null,"message":"TEIID30492 Non-comparable expression of type object cannot be used in comparison: g4.clobval = ?."\}\} > *Expected result:* "code":30492 > XML (in this case OData returns HTTP status code instead of error code): > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Result:* > {code:xml} > <error> > <code>500</code> > <message>TEIID30492 Non-comparable expression of type object cannot be used in comparison: g1.clobval = ?.</message> > </error> > {code} > *Expected result:* > {code:xml}<code>:30492</code>{code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4040) Representation of OData error does not contain error code.

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4040?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4040: ------------------------------------- This requires a upstream change opened at https://issues.apache.org/jira/browse/OLINGO-906 > Representation of OData error does not contain error code. > ---------------------------------------------------------- > > Key: TEIID-4040 > URL: https://issues.jboss.org/browse/TEIID-4040 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > JSON: > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* \{"error":\{"code":null,"message":"TEIID30492 Non-comparable expression of type object cannot be used in comparison: g4.clobval = ?."\}\} > *Expected result:* "code":30492 > XML (in this case OData returns HTTP status code instead of error code): > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Result:* > {code:xml} > <error> > <code>500</code> > <message>TEIID30492 Non-comparable expression of type object cannot be used in comparison: g1.clobval = ?.</message> > </error> > {code} > *Expected result:* > {code:xml}<code>:30492</code>{code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4013) ODBC sessions never release

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4013?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4013: --------------------------------------- If it is being caused by TEIID-4012, then this is somewhat of a client issue - they are not accounting for the possibility of an error response when looking for pg_prepared_xacts. If this is reproducible, then it could be tested against a vdb that has pg_prepared_xacts defined - http://www.postgresql.org/docs/8.4/static/view-pg-prepared-xacts.html Just create a view matching the name/columns and select use a query such as "select null, null ... from (select 1) x where 1=0" as the view definition query expression. > ODBC sessions never release > --------------------------- > > Key: TEIID-4013 > URL: https://issues.jboss.org/browse/TEIID-4013 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP6.4.0 patched to version 6.4.5, > JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157 > 64-bit Windows 7 environment > Reporter: Steve Tran > Assignee: Steven Hawkins > Attachments: Capture.PNG, Capture2.PNG, Capture3.PNG > > > I have 3 ODBC System DSNs on a Windows server. When I'm viewing the Deployed VDBs and looking at the Sessions tab, the ODBC connections never seem to time out or release. Not really sure if/when they should release, but they continue to multiply. See screenshots. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4013) ODBC sessions never release

by Steve Tran (JIRA)

[ https://issues.jboss.org/browse/TEIID-4013?page=com.atlassian.jira.plugin... ] Steve Tran commented on TEIID-4013: ----------------------------------- The ODBC connections are being established from a Windows NT server, that has 3 DSNs. SQL Server Management Studio is the tool being used, and Linked Servers are being created/used. > ODBC sessions never release > --------------------------- > > Key: TEIID-4013 > URL: https://issues.jboss.org/browse/TEIID-4013 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP6.4.0 patched to version 6.4.5, > JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157 > 64-bit Windows 7 environment > Reporter: Steve Tran > Assignee: Steven Hawkins > Attachments: Capture.PNG, Capture2.PNG, Capture3.PNG > > > I have 3 ODBC System DSNs on a Windows server. When I'm viewing the Deployed VDBs and looking at the Sessions tab, the ODBC connections never seem to time out or release. Not really sure if/when they should release, but they continue to multiply. See screenshots. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4013) ODBC sessions never release

by Steve Tran (JIRA)

[ https://issues.jboss.org/browse/TEIID-4013?page=com.atlassian.jira.plugin... ] Steve Tran commented on TEIID-4013: ----------------------------------- I know this ticket is closed, but here's more info. It looks like it creates new 3 new sessions (3 might be specific to my environment only because I have 3 DSN configured) whenever I see this error message. {code} [Server:cdtssoa126d-jdv-one] 11:32:21,042 TRACE [org.teiid.ODBC] (New I/O worker #7) invoking client method: authenticationSucess [-1109727455, -1109727455] [Server:cdtssoa126d-jdv-one] 11:32:21,042 TRACE [org.teiid.ODBC] (New I/O worker #7) invoking client method: ready [false, false] [Server:cdtssoa126d-jdv-one] 11:32:21,098 TRACE [org.teiid.ODBC] (New I/O worker #7) invoking server method: executeQuery [select oid, typbasetype from pg_type where typname = 'lo'] [Server:cdtssoa126d-jdv-one] 11:32:21,102 TRACE [org.teiid.ODBC] (Worker24_QueryProcessorQueue9290) invoking client method: sendResults [select oid, typbasetype from pg_type where typname = 'lo', org.teiid.jdbc.ResultSetImpl@481ee1ea, [org.teiid.odbc.PGUtil$PgColInfo@6381eea3, org.teiid.odbc.PGUtil$PgColInfo@675a425e], org.teiid.client.util.ResultsFuture@56bb5e54, -1, true] [Server:cdtssoa126d-jdv-one] 11:32:21,104 TRACE [org.teiid.ODBC] (Worker24_QueryProcessorQueue9290) invoking client method: ready [false, false] [Server:cdtssoa126d-jdv-one] 11:32:21,167 TRACE [org.teiid.ODBC] (New I/O worker #7) invoking server method: executeQuery [select gid from pg_prepared_xacts] [Server:cdtssoa126d-jdv-one] 11:32:21,168 WARN [org.teiid.PROCESSOR] (Worker24_QueryProcessorQueue9291) TEIID30020 Processing exception for request wNNOm0Bs6pFa.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace. [Server:cdtssoa126d-jdv-one] 11:32:21,168 TRACE [org.teiid.ODBC] (Worker24_QueryProcessorQueue9291) invoking client method: errorOccurred [org.teiid.jdbc.TeiidSQLException: Group does not exist: pg_prepared_xacts] [Server:cdtssoa126d-jdv-one] 11:32:21,169 WARN [org.teiid.ODBC] (Worker24_QueryProcessorQueue9291) TEIID40020 Error occurred: org.teiid.jdbc.TeiidSQLException: Group does not exist: pg_prepared_xacts [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:667) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:63) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:515) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1001) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:556) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:352) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75] [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75] [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75] [Server:cdtssoa126d-jdv-one] Caused by: org.teiid.api.exception.query.QueryResolverException: Group does not exist: pg_prepared_xacts [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.util.ResolverUtil.handleUnresolvedGroup(ResolverUtil.java:814) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.util.ResolverUtil.resolveGroup(ResolverUtil.java:893) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.isXMLQuery(QueryResolver.java:349) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.chooseResolver(QueryResolver.java:294) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:268) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:124) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:260) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:369) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:435) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:613) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] ... 8 more [Server:cdtssoa126d-jdv-one] [Server:cdtssoa126d-jdv-one] 11:32:21,170 TRACE [org.teiid.ODBC] (Worker24_QueryProcessorQueue9291) invoking client method: ready [false, false] [Server:cdtssoa126d-jdv-one] 11:32:47,169 TRACE [org.teiid.ODBC] (New I/O worker #3) StartupMessage version 196608 ( 3 . 0 ) [Server:cdtssoa126d-jdv-one] 11:32:47,169 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking server method: initialize [{client_encoding=UTF8, extra_float_digits=2, user=teiidUser, default_transaction_isolation=read committed, version=196608, TimeZone=Eastern Standard Time, DateStyle=ISO, database=HSI, geqo=on}] [Server:cdtssoa126d-jdv-one] 11:32:47,170 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking client method: initialized [{client_encoding=UTF8, extra_float_digits=2, user=teiidUser, default_transaction_isolation=read committed, version=196608, TimeZone=Eastern Standard Time, DateStyle=ISO, database=HSI, geqo=on}] [Server:cdtssoa126d-jdv-one] 11:32:47,170 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking client method: useClearTextAuthentication null [Server:cdtssoa126d-jdv-one] 11:32:47,171 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking server method: logon [HSI, teiidUser, org.teiid.transport.PgFrontendProtocol$NullTerminatedStringDataInputStream@6d971c54, /162.44.148.158:56363] [Server:cdtssoa126d-jdv-one] 11:32:47,208 DEBUG [org.teiid.SECURITY] (New I/O worker #3) closeSession null [Server:cdtssoa126d-jdv-one] 11:32:47,209 DEBUG [org.teiid.SECURITY] (New I/O worker #3) authenticateUser teiidUser ODBC [Server:cdtssoa126d-jdv-one] 11:32:47,209 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Logon successful for " teiidUser " in security domain teiid-security [Server:cdtssoa126d-jdv-one] 11:32:47,209 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Logon successful, created session: sessionid=pzkND8mfq/FP; userName=teiidUser@teiid-security; vdbName=HSI; vdbVersion=1; createdTime=Tue Mar 15 11:32:47 EDT 2016; applicationName=ODBC; clientHostName=162.44.148.158; clientHardwareAddress=null; IPAddress=162.44.148.158; securityDomain=teiid-security; lastPingTime=Tue Mar 15 11:32:47 EDT 2016 [Server:cdtssoa126d-jdv-one] 11:32:47,210 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking client method: authenticationSucess [-2076166782, -2076166782] [Server:cdtssoa126d-jdv-one] 11:32:47,211 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking client method: ready [false, false] [Server:cdtssoa126d-jdv-one] 11:32:47,266 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking server method: executeQuery [select oid, typbasetype from pg_type where typname = 'lo'] [Server:cdtssoa126d-jdv-one] 11:32:47,272 TRACE [org.teiid.ODBC] (Worker24_QueryProcessorQueue9292) invoking client method: sendResults [select oid, typbasetype from pg_type where typname = 'lo', org.teiid.jdbc.ResultSetImpl@414fb377, [org.teiid.odbc.PGUtil$PgColInfo@578f6b20, org.teiid.odbc.PGUtil$PgColInfo@8c22ec9], org.teiid.client.util.ResultsFuture@48d929d, -1, true] [Server:cdtssoa126d-jdv-one] 11:32:47,273 TRACE [org.teiid.ODBC] (Worker24_QueryProcessorQueue9292) invoking client method: ready [false, false] [Server:cdtssoa126d-jdv-one] 11:32:47,336 TRACE [org.teiid.ODBC] (New I/O worker #3) invoking server method: executeQuery [select gid from pg_prepared_xacts] [Server:cdtssoa126d-jdv-one] 11:32:47,338 WARN [org.teiid.PROCESSOR] (Worker24_QueryProcessorQueue9293) TEIID30020 Processing exception for request pzkND8mfq/FP.4 'Group does not exist: pg_prepared_xacts'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace. [Server:cdtssoa126d-jdv-one] 11:32:47,338 TRACE [org.teiid.ODBC] (Worker24_QueryProcessorQueue9293) invoking client method: errorOccurred [org.teiid.jdbc.TeiidSQLException: Group does not exist: pg_prepared_xacts] [Server:cdtssoa126d-jdv-one] 11:32:47,338 WARN [org.teiid.ODBC] (Worker24_QueryProcessorQueue9293) TEIID40020 Error occurred: org.teiid.jdbc.TeiidSQLException: Group does not exist: pg_prepared_xacts [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:667) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:63) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:515) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) [teiid-client-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1001) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:556) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:352) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_75] [Server:cdtssoa126d-jdv-one] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_75] [Server:cdtssoa126d-jdv-one] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_75] [Server:cdtssoa126d-jdv-one] Caused by: org.teiid.api.exception.query.QueryResolverException: Group does not exist: pg_prepared_xacts [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.util.ResolverUtil.handleUnresolvedGroup(ResolverUtil.java:814) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.util.ResolverUtil.resolveGroup(ResolverUtil.java:893) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.isXMLQuery(QueryResolver.java:349) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.chooseResolver(QueryResolver.java:294) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:268) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:124) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:260) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:369) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:435) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:613) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315) [teiid-engine-8.7.3.6_2-redhat-1.jar:8.7.3.6_2-redhat-1] [Server:cdtssoa126d-jdv-one] ... 8 more {code} > ODBC sessions never release > --------------------------- > > Key: TEIID-4013 > URL: https://issues.jboss.org/browse/TEIID-4013 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP6.4.0 patched to version 6.4.5, > JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157 > 64-bit Windows 7 environment > Reporter: Steve Tran > Assignee: Steven Hawkins > Attachments: Capture.PNG, Capture2.PNG, Capture3.PNG > > > I have 3 ODBC System DSNs on a Windows server. When I'm viewing the Deployed VDBs and looking at the Sessions tab, the ODBC connections never seem to time out or release. Not really sure if/when they should release, but they continue to multiply. See screenshots. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4047) OData - $top with negative value return status code 500

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4047?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4047: ------------------------------------- currently I have like below, but once I check in we can fine tune it. {code} @Override public void processError(ODataServerError error, ErrorResponse response) { error.getException().printStackTrace(); //TODO: remove this LogManager.logDetail(LogConstants.CTX_ODATA, error.getException()); Throwable ex = getRoot(error.getException()); if (ex instanceof TeiidProcessingException) { error.setException((TeiidProcessingException)ex); error.setCode(((TeiidProcessingException)ex).getCode()); error.setStatusCode(400); } else if (ex instanceof TeiidException) { error.setException((TeiidException)ex); error.setCode(((TeiidException)ex).getCode()); error.setStatusCode(500); } else if (ex instanceof TeiidRuntimeException) { error.setException((TeiidRuntimeException)ex); error.setCode(((TeiidRuntimeException)ex).getCode()); error.setStatusCode(500); } response.writeError(error); } private Throwable getRoot(Throwable t) { if (t.getCause() != null && t.getCause() != t) { if (t.getCause() instanceof TeiidException || t.getCause() instanceof TeiidRuntimeException) { return t.getCause(); } return getRoot(t.getCause()); } return t; } (code} > OData - $top with negative value return status code 500 > ------------------------------------------------------- > > Key: TEIID-4047 > URL: https://issues.jboss.org/browse/TEIID-4047 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > OData request with query option $top with negative value returns status code 500. The root cause is SQLException. OData service should check passed value and return e.g. 400 instead. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$top=-1 > See http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4047) OData - $top with negative value return status code 500

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4047?page=com.atlassian.jira.plugin... ] Ramesh Reddy edited comment on TEIID-4047 at 3/15/16 11:24 AM: --------------------------------------------------------------- currently I have like below, but once I check in we can fine tune it. {code} @Override public void processError(ODataServerError error, ErrorResponse response) { error.getException().printStackTrace(); //TODO: remove this LogManager.logDetail(LogConstants.CTX_ODATA, error.getException()); Throwable ex = getRoot(error.getException()); if (ex instanceof TeiidProcessingException) { error.setException((TeiidProcessingException)ex); error.setCode(((TeiidProcessingException)ex).getCode()); error.setStatusCode(400); } else if (ex instanceof TeiidException) { error.setException((TeiidException)ex); error.setCode(((TeiidException)ex).getCode()); error.setStatusCode(500); } else if (ex instanceof TeiidRuntimeException) { error.setException((TeiidRuntimeException)ex); error.setCode(((TeiidRuntimeException)ex).getCode()); error.setStatusCode(500); } response.writeError(error); } private Throwable getRoot(Throwable t) { if (t.getCause() != null && t.getCause() != t) { if (t.getCause() instanceof TeiidException || t.getCause() instanceof TeiidRuntimeException) { return t.getCause(); } return getRoot(t.getCause()); } return t; } {code} was (Author: rareddy): currently I have like below, but once I check in we can fine tune it. {code} @Override public void processError(ODataServerError error, ErrorResponse response) { error.getException().printStackTrace(); //TODO: remove this LogManager.logDetail(LogConstants.CTX_ODATA, error.getException()); Throwable ex = getRoot(error.getException()); if (ex instanceof TeiidProcessingException) { error.setException((TeiidProcessingException)ex); error.setCode(((TeiidProcessingException)ex).getCode()); error.setStatusCode(400); } else if (ex instanceof TeiidException) { error.setException((TeiidException)ex); error.setCode(((TeiidException)ex).getCode()); error.setStatusCode(500); } else if (ex instanceof TeiidRuntimeException) { error.setException((TeiidRuntimeException)ex); error.setCode(((TeiidRuntimeException)ex).getCode()); error.setStatusCode(500); } response.writeError(error); } private Throwable getRoot(Throwable t) { if (t.getCause() != null && t.getCause() != t) { if (t.getCause() instanceof TeiidException || t.getCause() instanceof TeiidRuntimeException) { return t.getCause(); } return getRoot(t.getCause()); } return t; } (code} > OData - $top with negative value return status code 500 > ------------------------------------------------------- > > Key: TEIID-4047 > URL: https://issues.jboss.org/browse/TEIID-4047 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > OData request with query option $top with negative value returns status code 500. The root cause is SQLException. OData service should check passed value and return e.g. 400 instead. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$top=-1 > See http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4047) OData - $top with negative value return status code 500

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4047?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4047: --------------------------------------- The main thing would just to look for TeiidComponent vs. TeiidProcessing. Some of the logic we have is ExceptionUtil.getExceptionOfType, TeiidSQLException.findRootException, or in the engine RequestWorkItem.handleThrowable > OData - $top with negative value return status code 500 > ------------------------------------------------------- > > Key: TEIID-4047 > URL: https://issues.jboss.org/browse/TEIID-4047 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > OData request with query option $top with negative value returns status code 500. The root cause is SQLException. OData service should check passed value and return e.g. 400 instead. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$top=-1 > See http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4075) Netezza translator to support common table expressions

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4075?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4075: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1317943 Bugzilla Update: Perform > Netezza translator to support common table expressions > ------------------------------------------------------ > > Key: TEIID-4075 > URL: https://issues.jboss.org/browse/TEIID-4075 > Project: Teiid > Issue Type: Enhancement > Affects Versions: 8.7.5.6_2 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > > netezza translator is not marked as supporting common table expressions, but Netezza does support. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4075) Netezza translator to support common table expressions

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4075?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4075: --------------------------------- Summary: Netezza translator to support common table expressions (was: Netezza translater to support common table expressions) > Netezza translator to support common table expressions > ------------------------------------------------------ > > Key: TEIID-4075 > URL: https://issues.jboss.org/browse/TEIID-4075 > Project: Teiid > Issue Type: Enhancement > Affects Versions: 8.7.5.6_2 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > > netezza translator is not marked as supporting common table expressions, but Netezza does support. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2016