10 Replies Latest reply on May 31, 2017 8:09 PM by Steven Hawkins

    Teiid cancel exception for insert query

    Mark Tawk Novice

      i'm using Teiid 9 with oracle translator.

      i'm executing a query insert into select, that writes around 5 million records.

      After randomly around10-20 minutes and around 2 millions records inserted, Teiid is returning a query cancelled exception.

      After inspection i find out that the insertion is continuing at Oracle level and the table is locked till the insertion finishes.

      What could be the cause of such an exception and is there anything that can be done to prevent such exceptions?