Re: ODBC error

On servers side logs
could not receive data from client connection timed out
//
(,'')> why?
<( )'
| |
,,_ _,,

чт, 12 окт. 2023 г. в 16:42, Dave Cramer <davecramer(at)postgres(dot)rocks>:

>
>
>
>
> On Thu, 12 Oct 2023 at 09:33, Victor K. <ptahin(at)gmail(dot)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
>
>>