Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-14057

[DV] Invalid views cannot be fixed in Data Virtualization

XMLWordPrintable

      Certain steps on Views in data virtualization destroy them and they cannot be fixed (they can be deleted and create again).

      There are two problems which are connected to each other.

      • viewA is not in invalid state after adding string "x xx" at the end
      • Both views are destroyed after adding "aaa" at the start

      They cannot be edited and corrected. The only option is to delete them both and start creating/importing again.

      Stacktrace after steps in the video:

      20:01:51.332 [Catalina-utility-2] ERROR o.a.coyote.http11.Http11NioProtocol - Error processing async timeouts
      java.util.concurrent.ExecutionException: java.lang.AbstractMethodError: Method org/apache/tomcat/websocket/server/WsHttpUpgradeHandler.timeoutAsync(J)V is abstract
      	at java.util.concurrent.FutureTask.report(FutureTask.java:122)
      	at java.util.concurrent.FutureTask.get(FutureTask.java:192)
      	at org.apache.coyote.AbstractProtocol.startAsyncTimeout(AbstractProtocol.java:615)
      	at org.apache.coyote.AbstractProtocol$1.run(AbstractProtocol.java:598)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
      	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
      	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      	at java.lang.Thread.run(Thread.java:748)
      Caused by: java.lang.AbstractMethodError: Method org/apache/tomcat/websocket/server/WsHttpUpgradeHandler.timeoutAsync(J)V is abstract
      	at org.apache.tomcat.websocket.server.WsHttpUpgradeHandler.timeoutAsync(WsHttpUpgradeHandler.java)
      	at org.apache.coyote.http11.upgrade.UpgradeProcessorInternal.timeoutAsync(UpgradeProcessorInternal.java:78)
      	at org.apache.coyote.AbstractProtocol$2.run(AbstractProtocol.java:626)
      	... 8 common frames omitted
      20:02:03.621 [http-nio-8080-exec-1] INFO  i.s.dv.lsp.TeiidDdlWorkspaceService - Setting language server metadata scope to the virtualization: virt
      20:02:05.021 [http-nio-8080-exec-5] WARN  io.syndesis.dv.utils.KLog - Version was not specificed for view definition, the latest state may be overwritten
      20:02:10.335 [http-nio-8080-exec-10] INFO  o.teiid.RUNTIME.VDBLifeCycleListener - TEIID40120 VDB virtvdb.1 will be removed from the repository
      20:02:10.337 [http-nio-8080-exec-10] INFO  o.teiid.RUNTIME.VDBLifeCycleListener - TEIID40119 VDB virtvdb.1 removed from the repository
      20:02:10.338 [http-nio-8080-exec-10] INFO  o.teiid.RUNTIME.VDBLifeCycleListener - TEIID40118 VDB virtvdb.1 added to the repository
      20:02:10.338 [http-nio-8080-exec-10] INFO  org.teiid.RUNTIME - TEIID50029 VDB virtvdb.1 model "virt" metadata is currently being loaded. Start Time: 6/11/20 8:02 PM
      20:02:10.344 [http-nio-8080-exec-10] WARN  org.teiid.RUNTIME - TEIID50036 VDB virtvdb.1 model "virt" metadata failed to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "PostgresDB.contact AS t1x [*]xx[*]" at line 9, column 31.
      Was expecting: <EOF> | "create" | "cross" | "except" | "fetch" | "full" | "group" | "having" | "inner" | "intersect" ...
      org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "PostgresDB.contact AS t1x [*]xx[*]" at line 9, column 31.
      Was expecting: <EOF> | "create" | "cross" | "except" | "fetch" | "full" | "group" | "having" | "inner" | "intersect" ...
      	at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:534)
      	at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:516)
      	at org.teiid.metadata.MetadataFactory.parse(MetadataFactory.java:748)
      	at org.teiid.query.metadata.DDLMetadataRepository.loadMetadata(DDLMetadataRepository.java:36)
      	at org.teiid.runtime.AbstractVDBDeployer$MetadataRepositoryWrapper.loadMetadata(AbstractVDBDeployer.java:88)
      	at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:51)
      	at org.teiid.runtime.AbstractVDBDeployer$2.run(AbstractVDBDeployer.java:291)
      	at org.teiid.runtime.EmbeddedServer.runMetadataJob(EmbeddedServer.java:904)
      	at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:328)
      	at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:228)
      	at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:852)
      	at io.syndesis.dv.metadata.internal.TeiidServer.deployVDB(TeiidServer.java:76)
      	at io.syndesis.dv.metadata.internal.DefaultMetadataInstance.deploy(DefaultMetadataInstance.java:434)
      	at io.syndesis.dv.server.endpoint.MetadataService.lambda$updatePreviewVdb$0(MetadataService.java:228)
      	at io.syndesis.dv.repository.RepositoryManagerImpl.runInTransaction(RepositoryManagerImpl.java:83)
      	at io.syndesis.dv.server.endpoint.MetadataService.updatePreviewVdb(MetadataService.java:202)
      	at io.syndesis.dv.server.endpoint.DataVirtualizationService.createViewList(DataVirtualizationService.java:753)
      	at io.syndesis.dv.server.endpoint.DataVirtualizationService.lambda$getViewList$11(DataVirtualizationService.java:736)
      	at io.syndesis.dv.repository.RepositoryManagerImpl.runInTransaction(RepositoryManagerImpl.java:83)
      	at io.syndesis.dv.server.endpoint.DataVirtualizationService.getViewList(DataVirtualizationService.java:729)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
      	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
      	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
      	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
      	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
      	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
      	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
      	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
      	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
      	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
      	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
      	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at io.opentracing.contrib.web.servlet.filter.TracingFilter.doFilter(TracingFilter.java:174)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
      	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
      	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
      	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
      	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
      	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
      	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      	at java.lang.Thread.run(Thread.java:748)
      Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "PostgresDB.contact AS t1x [*]xx[*]" at line 9, column 31.
      Was expecting: <EOF> | "create" | "cross" | "except" | "fetch" | "full" | "group" | "having" | "inner" | "intersect" ...
      	at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:231)
      	... 65 common frames omitted
      

        1. ENTESB-14057-log.txt
          42 kB
        2. ENTESB-14057-log2.txt
          2 kB
        3. invalid.webm
          22.57 MB

            rhn-engineering-shawkins Steven Hawkins
            mmajerni@redhat.com Mario Majernik
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: