Aug 16, 2010 10:49 AM
ERROR: 206 : Transaction required, but no transaction started...
-
Like (0)
Hey Guys,
I keep on getting this error message ERROR: 206 : Transaction required, but no transaction started..., when I am trying to execute the netezza stored procedure, I checked for the syntax, and the procedure which was executing yesterday, is throwing this error now. Can anyone help me solve this, if not the exact answer it would be really appreciated if you can give me some ideas of solving the error...
On what database version is this issue occurring?
James.
nzsql (Netezza SQL) Release 4.6 (P-6) [Build 9490]
contains history support
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996 Regents of the University of California
this the version info of my netezza box.
The issue is fixed in 4.6.2 P11+ and 4.6.6 so I would suggest you upgrade to the most recent available patch of these releases.
Thanks.
James.
It would be really nice of some one can give a workaround to solve this issue other than upgradation with netezza patch updates.
I respectfully disagree. Workarounds at this level don't turn out nicely.
Upgrading a Netezza machine is like upgrading an iPhone - it takes a short bit of time but the end is better than the beginning, and we don't lose anything.
It's painless. Go for it.

