DataSource access failes after TEIID40008 Expiring session
Issue
VDB access via Datasouce fails with the following messages when expiring session by Session Expiration Time Limit for JDBC Transport.
INFO [org.teiid.SECURITY] (SessionMonitor) TEIID40008 Expiring session XXXXXXXXXXXXXXX
SEVERE [org.teiid.soap] (http-/0.0.0.0:8080-1) Exception in executeDataservice: {0}: java.lang.Throwable: org.teiid.jdbc.TeiidSQLException: 57014 TEIID30160 The request XXXXXXXXXXXXXXX has been cancelled.
at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:175) [classes:]
at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:299) [classes:]
...
Caused by: org.teiid.core.TeiidProcessingException: TEIID30160 The request XXXXXXXXXXXXXXX has been cancelled.
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:146)
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159)
...
WARN [org.teiid.PROCESSOR] (New I/O worker #8) TEIID40011 Processing exception 'TEIID40042 Invalid Session YYYYYYYYYYYYYYY Session may have already been terminated.' for session YYYYYYYYYYYYYYY Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.jboss.TransportService$2.invoke(TransportService.java:224). Enable more detailed logging to see the entire stacktrace.
SEVERE [org.teiid.soap] (http-/127.0.0.1:8080-1) Exception in executeDataservice: {0}: java.lang.Throwable: org.teiid.jdbc.TeiidSQLException: TEIID40042 Invalid Session YYYYYYYYYYYYYYY Session may have already been terminated.
at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:175) [classes:]
at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:299) [classes:]
...
Caused by: org.teiid.jdbc.TeiidSQLException: TEIID40042 Invalid Session YYYYYYYYYYYYYYY Session may have already been terminated.
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:532
...
Environment
Red Hat JBoss Data Virtualization (DV) 6.2
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
