This content has been marked as final. Show 3 replies
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.
Naveen Kumar T.