Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-odbc-owner+archive@lists.postgresql.org>)
	id 1qqvxp-001l8L-Ap
	for pgsql-odbc@arkaria.postgresql.org; Thu, 12 Oct 2023 13:42:57 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-odbc-owner+archive@lists.postgresql.org>)
	id 1qqvxm-0075ZL-QJ
	for pgsql-odbc@arkaria.postgresql.org; Thu, 12 Oct 2023 13:42:55 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <davecramer@postgres.rocks>)
	id 1qqvxm-0075Xr-Ic
	for pgsql-odbc@lists.postgresql.org; Thu, 12 Oct 2023 13:42:55 +0000
Received: from pgintl.fastcrypt.com ([149.56.129.164])
	by makus.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <davecramer@postgres.rocks>)
	id 1qqvxk-0008QP-TQ
	for pgsql-odbc@postgresql.org; Thu, 12 Oct 2023 13:42:54 +0000
Received: from mail-ed1-f50.google.com (mail-ed1-f50.google.com
 [209.85.208.50])
	by pgintl.fastcrypt.com (Postfix) with ESMTPSA id 0A4C420172
	for <pgsql-odbc@postgresql.org>; Thu, 12 Oct 2023 09:42:50 -0400 (EDT)
Received: by mail-ed1-f50.google.com with SMTP id
 4fb4d7f45d1cf-53b8f8c6b1fso1796340a12.0
        for <pgsql-odbc@postgresql.org>; Thu, 12 Oct 2023 06:42:50 -0700 (PDT)
X-Gm-Message-State: AOJu0Yy1SLfrDRTw7hD9kV+pF72hkiLHsU7zV+nF4TlEV2XsLl47/4Vi
	UxckyW7Z52xqx7ySey8Qh1pcXhSbDxWZF/Kax2E=
X-Google-Smtp-Source: 
 AGHT+IFhyO3ee8Ax7ERfuHVeCBv2fVSC+prloqoUDxjMKPjfEm5RT9Y9+r7q8vQldrKvhPwIxWe5JhTpCnYp9bulYKo=
X-Received: by 2002:a17:906:e:b0:9b2:7492:70a0 with SMTP id
 14-20020a170906000e00b009b2749270a0mr20073514eja.27.1697118169860; Thu, 12
 Oct 2023 06:42:49 -0700 (PDT)
MIME-Version: 1.0
References: 
 <CAGkTcbeeGXvMuYR6p55PCicDWJh4Oh+M7+Yfy9veasSUtV=MVg@mail.gmail.com>
In-Reply-To: 
 <CAGkTcbeeGXvMuYR6p55PCicDWJh4Oh+M7+Yfy9veasSUtV=MVg@mail.gmail.com>
From: Dave Cramer <davecramer@postgres.rocks>
Date: Thu, 12 Oct 2023 09:42:33 -0400
X-Gmail-Original-Message-ID: 
 <CADK3HH+HoPCKjamYJeMQYDHhvSqRdEebR79SpRyKx3MHzJ4mEg@mail.gmail.com>
Message-ID: 
 <CADK3HH+HoPCKjamYJeMQYDHhvSqRdEebR79SpRyKx3MHzJ4mEg@mail.gmail.com>
Subject: Re: ODBC error
To: "Victor K." <ptahin@gmail.com>
Cc: pgsql-odbc@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a811a50607851d6f"
List-Id: <pgsql-odbc.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-odbc@lists.postgresql.org>
List-Owner: <mailto:pgsql-odbc-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-odbc>
Archived-At: 
 <https://www.postgresql.org/message-id/CADK3HH%2BHoPCKjamYJeMQYDHhvSqRdEebR79SpRyKx3MHzJ4mEg%40mail.gmail.com>
Precedence: bulk

--000000000000a811a50607851d6f
Content-Type: text/plain; charset="UTF-8"

On Thu, 12 Oct 2023 at 09:33, Victor K. <ptahin@gmail.com> wrote:

> Hello team
> We have error when trying to get data from big table (about 7 GB) directly
> to pivot table in MS Excel 2016 Pro Plus x64 over ODBC driver x64
> Postrge on linux ver 15
> ODBC psqlodbc_16_00_0000-x64
> Error
> OLE DB or ODBC error. An error occurred while processing table 'Query'.
> The current operation was cancelled because another operation in the
> transaction failed.
> and
> The commit or rollback request cannot be completed because there is no
> active transaction in this session.
> On small tables everything is okay
>

I would suggest looking at the server logs.
Dave Cramer
www.postgres.rocks

>

--000000000000a811a50607851d6f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><br clear=3D"all"><div><=
div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><br></div></div>=
</div><br></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gm=
ail_attr">On Thu, 12 Oct 2023 at 09:33, Victor K. &lt;<a href=3D"mailto:pta=
hin@gmail.com">ptahin@gmail.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div style=3D"color:rgb(0=
,0,0)">Hello team</div><div style=3D"color:rgb(0,0,0)">We have error=C2=A0w=
hen trying to get data from big table (about 7 GB) directly to pivot table =
in MS Excel 2016 Pro Plus x64 over ODBC driver x64</div><div style=3D"color=
:rgb(0,0,0)">Postrge=C2=A0on linux ver 15</div><div style=3D"color:rgb(0,0,=
0)">ODBC=C2=A0psqlodbc_16_00_0000-x64</div><div style=3D"color:rgb(0,0,0)">=
Error</div><div style=3D"color:rgb(0,0,0)">OLE DB or ODBC error. An error o=
ccurred while processing table &#39;Query&#39;. The current operation was c=
ancelled because another operation in the transaction failed.<br></div><div=
 style=3D"color:rgb(0,0,0)">and=C2=A0</div><div style=3D"color:rgb(0,0,0)">=
The commit or rollback request cannot be completed because there is no acti=
ve transaction in this session.<br></div><div style=3D"color:rgb(0,0,0)">On=
 small tables everything=C2=A0is okay</div></div></blockquote><div><br></di=
v><div>I would suggest looking at the server logs.=C2=A0</div>Dave Cramer<d=
iv>www.postgres.rocks</div><blockquote class=3D"gmail_quote" style=3D"margi=
n:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex=
">
</blockquote></div></div></div>

--000000000000a811a50607851d6f--