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, tools, and much more.