3 Replies Latest reply on Jan 3, 2017 9:00 AM by Ramesh Reddy

    Not able to insert data into oracle database using teiid api, throws exception : TEIID30160 The request 1C7sZp/i3dJ6.4 has been cancelled

    Kulbhushan Chaskar Master

      Hi,

       

      I am using teiid admin api to perform sql operations.

       

      I am able to insert data into MYSQL ,SQL SERVER but unable to insert data into ORACLE database in following scenario.

       

      Scenario :

      STEP 1: Insert 10 rows in table, it will be inserted in database as expected.

      STEP 2: Delete 1 or more row from the table.

      STEP 3: Try to insert same row which we have deleted in STEP 2, it will throw an exception

      • org.teiid.jdbc.TeiidSQLException: 57014 TEIID30160 The request 1C7sZp/i3dJ6.4 has been cancelled

      and fail to insert row into the table.

       

      But same row will be inserted successfully to the table if I DROP the TABLE from database and re-create it.

       

       

       

      Thanks,

      Kulbhushan Chaskar.