Ошибка при выполнении запроса в JBDS (Teiid)

Question

Ошибка при выполнении запроса в JBDS (Teiid)

Я использую JBDS 10.4 с WildFly 10,Teiid Designer 10. Успешно создал VDB, перейдя по ссылке: https://developer.jboss.org/wiki/SalesforceAsARESTServiceUsingDataVirtualization?_sscc=t

При запуске в браузере появляется необнаруженная ошибка (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

4

wildfly wildfly-10 teiid jboss-developer-studio

Источник

user7995124 11 сен '17 в 12:17

1 ответ

Другие вопросы по тегам wildfly wildfly-10 teiid jboss-developer-studio

user1772470 13 сен '17 в 14:06 2017-09-13 14:06 · Answer 1 · 2017-09-13 14:06

Я думаю, что с точки зрения базы данных вы используете старое соединение с VDB, и было другое развертывание VDB. При развертывании нового VDB любые старые сеансы завершаются на стороне сервера. Если вы уничтожите это соединение и переделаете новое, оно должно работать.