The Netezza Community: ERROR: 206 : Transaction required, but...

Skip navigation

Netezza.comThinking.Netezza.comBookmark This Site

Up to Discussions in TwinFin Talk

8225 Views 5 Replies Latest reply: Aug 17, 2010 7:55 AM by David Birmingham

lowradiation

7 posts since
Aug 16, 2010

Currently Being Moderated

Aug 16, 2010 10:49 AM

ERROR: 206 : Transaction required, but no transaction started...

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...

Like (0)

Tags: netezza, procedures, nzsql

James Karioki
47 posts since
Apr 7, 2009

Currently Being Moderated

1. Aug 16, 2010 10:59 AM (in response to lowradiation)
Re: ERROR: 206 : Transaction required, but no transaction started...

On what database version is this issue occurring?

James.

Report Abuse

Like (0)
lowradiation
7 posts since
Aug 16, 2010

Currently Being Moderated

2. Aug 16, 2010 11:36 AM (in response to James Karioki)
Re: ERROR: 206 : Transaction required, but no transaction started...

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.

Report Abuse

Like (0)
James Karioki
47 posts since
Apr 7, 2009

Currently Being Moderated

3. Aug 16, 2010 11:45 AM (in response to lowradiation)
Re: ERROR: 206 : Transaction required, but no transaction started...

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.

Report Abuse

Like (0)
lowradiation
7 posts since
Aug 16, 2010

Currently Being Moderated

4. Aug 17, 2010 2:07 AM (in response to James Karioki)
Re: ERROR: 206 : Transaction required, but no transaction started...

It would be really nice of some one can give a workaround to solve this issue other than upgradation with netezza patch updates.

Report Abuse

Like (0)
David Birmingham
426 posts since
Sep 24, 2007

Currently Being Moderated

5. Aug 17, 2010 7:55 AM (in response to lowradiation)
Re: ERROR: 206 : Transaction required, but no transaction started...

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.

Report Abuse

Like (0)

Go to original post

Legend

Correct Answers - 4 points
Helpful Answers - 2 points

Aug 16, 2010 10:49 AM

ERROR: 206 : Transaction required, but no transaction started...

Actions

More Like This

Bookmarked By (0)

Legend