在JBDS (Teiid)中执行查询时出错

Question

我正在使用JBDS10.4和WildFly 10，Teiid Designer 10。通过以下链接成功地制作了VDB：https://developer.jboss.org/wiki/SalesforceAsARESTServiceUsingDataVirtualization?_sscc=t

在浏览器上运行时，出现notfound错误(404)。尝试执行VDB，然后打开Database Development透视图，在执行查询时，它启动且未完成(未从0%更改)。我没有收到任何错误，但收到以下警告：

[org.teiid.SECURITY] (NIO6)  TEIID40011 Processing exception 'TEIID40042 Invalid Session +tJUxJdXtP8C. Session may have already been terminated.' for session null.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347).

编辑(优化完成后的错误日志:处理器计划：)：

2017-09-09 09:31:44,173 WARN  [org.teiid.SECURITY] (NIO1)  TEIID40011 Processing exception 'TEIID40042 Invalid Session HWYX7pgSwHa1. Session may have already been terminated.' for session null.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:31:44,175 WARN  [org.teiid.SECURITY] (NIO1)  TEIID40011 Processing exception 'TEIID40042 Invalid Session LopCxnhFRcHx. Session may have already been terminated.' for session null.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:31:44,176 WARN  [org.teiid.SECURITY] (NIO1)  TEIID40011 Processing exception 'TEIID40042 Invalid Session IYgbw2oe1pvT. Session may have already been terminated.' for session null.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:31:44,178 WARN  [org.teiid.SECURITY] (NIO1)  TEIID40011 Processing exception 'TEIID40042 Invalid Session Cm59XEg1MrlD. Session may have already been terminated.' for session null.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:31:44,180 WARN  [org.teiid.SECURITY] (NIO1)  TEIID40011 Processing exception 'TEIID40042 Invalid Session 9/F8cj7wPFXz. Session may have already been terminated.' for session null.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:31:44,181 WARN  [org.teiid.SECURITY] (NIO1)  TEIID40011 Processing exception 'TEIID40042 Invalid Session XPa5O+m/MYsS. Session may have already been terminated.' for session null.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:31:44,182 WARN  [org.teiid.SECURITY] (NIO1)  TEIID40011 Processing exception 'TEIID40042 Invalid Session omRcugzE9ky1. Session may have already been terminated.' for session null.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:31:44,184 WARN  [org.teiid.SECURITY] (NIO1)  TEIID40011 Processing exception 'TEIID40042 Invalid Session sP1SduL77Vb2. Session may have already been terminated.' for session null.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:31:44,193 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session i1nbdnUCs369. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:31:44,194 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session jR9QR129cvj4. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:31:44,205 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session OTQr9BXiXZeL. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:31:44,207 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session t8rpRYgRD7XT. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:31:44,211 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session /vnJ1FMRlvXB. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:33:44,082 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session HWYX7pgSwHa1. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:33:44,083 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session LopCxnhFRcHx. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:33:44,087 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session IYgbw2oe1pvT. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:33:44,089 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session Cm59XEg1MrlD. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:33:44,094 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session 9/F8cj7wPFXz. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:33:44,096 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session XPa5O+m/MYsS. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:33:44,108 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session omRcugzE9ky1. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:33:44,111 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session sP1SduL77Vb2. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:33:44,126 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session i1nbdnUCs369. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:33:44,127 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session jR9QR129cvj4. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:33:44,129 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session OTQr9BXiXZeL. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:33:44,131 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session t8rpRYgRD7XT. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:33:44,132 WARN  [org.teiid.SECURITY] (NIO1) /Y9Sh40s5Ij9 TEIID40011 Processing exception 'TEIID40042 Invalid Session /vnJ1FMRlvXB. Session may have already been terminated.' for session /Y9Sh40s5Ij9.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:347). Enable more detailed logging to see the entire stacktrace.
2017-09-09 09:35:13,349 INFO  [org.teiid.PLANNER] (Worker8_QueryProcessorQueue40) e8o2iiRgWK4H

Answer 1

我认为从数据库的角度来看，您正在使用到VDB的旧连接，并且已经有了VDB的另一个部署。当部署一个新的VDB时，任何旧的会话都会在服务器端终止。如果您终止该连接并重新创建一个新连接，它应该可以工作。