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

Import invalid table fails but creates a view

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Blocker
    • fuse-7.4-GA
    • fuse-7.4-GA
    • Data Integration
    • None

    Description

      When I import postgresdb_winelist table from the default postgresdb, the import ends with an error message "Import data source failed for virtualization dv05vdb. Details: Internal Server Error". However, the view is create and it is incomplete. In the server log is a parsing error. In that case, the import should not be finished and should show some error message to a user why the import cannot be finished. Also, the incomplete view should not be created.

      Parsing error on Komodo server:

      2019-06-04 09:38:52.676 ERROR 1 --- [cher-3-thread-8] org.komodo.utils.KLog                    : Error while sequencing the Teiid SQL content: TEIID31100 Parsing error: Encountered "price, year[*],[*] gws," at line 1, column 62.
      Was expecting: "("
      org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "price, year[*],[*] gws," at line 1, column 62.
      Was expecting: "("
      	at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:249) ~[teiid-engine-12.2.0.jar!/:12.2.0]
      	at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:199) ~[teiid-engine-12.2.0.jar!/:12.2.0]
      	at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:178) ~[teiid-engine-12.2.0.jar!/:12.2.0]
      	at org.teiid.query.parser.QueryParser.parseDesignerCommand(QueryParser.java:174) ~[teiid-engine-12.2.0.jar!/:12.2.0]
      	at org.komodo.core.internal.sequencer.TeiidSqlSequencer.convertToJcr(TeiidSqlSequencer.java:79) ~[komodo-core-0.0.5-SNAPSHOT.jar!/:0.0.5-SNAPSHOT]
      	at org.komodo.core.internal.sequencer.TeiidSqlSequencer.execute(TeiidSqlSequencer.java:62) ~[komodo-core-0.0.5-SNAPSHOT.jar!/:0.0.5-SNAPSHOT]
      	at org.modeshape.jcr.JcrSession.sequence(JcrSession.java:2026) [modeshape-jcr-5.4.1.Final.jar!/:5.4.1.Final]
      	at org.komodo.core.internal.repository.KSequencers.sequence(KSequencers.java:455) [komodo-core-0.0.5-SNAPSHOT.jar!/:0.0.5-SNAPSHOT]
      	at org.komodo.core.internal.repository.KSequencers.sequence(KSequencers.java:517) [komodo-core-0.0.5-SNAPSHOT.jar!/:0.0.5-SNAPSHOT]
      	at org.komodo.core.internal.repository.KSequencers.onEvent(KSequencers.java:608) [komodo-core-0.0.5-SNAPSHOT.jar!/:0.0.5-SNAPSHOT]
      	at org.modeshape.jcr.JcrObservationManager$JcrListenerAdapter.notify(JcrObservationManager.java:294) [modeshape-jcr-5.4.1.Final.jar!/:5.4.1.Final]
      	at org.modeshape.jcr.bus.RepositoryChangeBus$ChangeSetListenerConsumerAdapter.consume(RepositoryChangeBus.java:207) [modeshape-jcr-5.4.1.Final.jar!/:5.4.1.Final]
      	at org.modeshape.jcr.bus.RepositoryChangeBus$ChangeSetListenerConsumerAdapter.consume(RepositoryChangeBus.java:201) [modeshape-jcr-5.4.1.Final.jar!/:5.4.1.Final]
      	at org.modeshape.common.collection.ring.RingBuffer$ConsumerRunner.run(RingBuffer.java:466) [modeshape-common-5.4.1.Final.jar!/:5.4.1.Final]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_201]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_201]
      	at java.lang.Thread.run(Thread.java:748) [na:1.8.0_201] [^import.mp4] 
      
      

      Attachments

        1. import.mp4
          459 kB
        2. PostgresDB.png
          PostgresDB.png
          33 kB

        Activity

          People

            mdrillin1@redhat.com Mark Drilling (Inactive)
            mkralik@redhat.com Matej Kralik
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: