3 Replies Latest reply: Jul 25, 2013 6:18 PM by Ayush Ganeriwal-Oracle RSS

    1100 : HY000 : org.netezza.error.NzSQLException: The connection object is in auto-commit mode

    801667

      Hi,

      We have an ODI which transfers data from oracle DB to Netezza DB.

      I have two ODI agents Agent A and Agent B (both are residing on unix).

      When I use Agent A for running the ODI, when i try to truncate the target table on target (netezza DB), I get the below error message.

      "1100 : HY000 : org.netezza.error.NzSQLException: The connection object is in auto-commit mode"

       

      But when I use Agent B, my interface is getting executed successfully.

      Please help if I need to tweak any agent/odi params files to resolve this error using agent A.

       

      Thanks,

      Naveen Kumar T.