Thread: ODBC error
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
Victor
//
(,'')> why?
<( )'
| |
,,_ _,,
//
(,'')> why?
<( )'
| |
,,_ _,,
On Thu, 12 Oct 2023 at 09:33, Victor K. <ptahin@gmail.com> wrote:
Hello teamWe 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 x64Postrge on linux ver 15ODBC psqlodbc_16_00_0000-x64ErrorOLE DB or ODBC error. An error occurred while processing table 'Query'. The current operation was cancelled because another operation in the transaction failed.andThe 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 Cramerwww.postgres.rocks
On servers side logs
could not receive data from client connection timed out
//
(,'')> why?
<( )'
| |
,,_ _,,
//
(,'')> why?
<( )'
| |
,,_ _,,
чт, 12 окт. 2023 г. в 16:42, Dave Cramer <davecramer@postgres.rocks>:
On Thu, 12 Oct 2023 at 09:33, Victor K. <ptahin@gmail.com> wrote:Hello teamWe 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 x64Postrge on linux ver 15ODBC psqlodbc_16_00_0000-x64ErrorOLE DB or ODBC error. An error occurred while processing table 'Query'. The current operation was cancelled because another operation in the transaction failed.andThe commit or rollback request cannot be completed because there is no active transaction in this session.On small tables everything is okayI would suggest looking at the server logs.Dave Cramerwww.postgres.rocks
On Oct 13, 2023 at 3:48 AM, Victor K. <ptahin@gmail.com> wrote:
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
On servers side logscould not receive data from client connection timed out
//
(,'')> why?
<( )'
| |
,,_ _,,Client side logs would probably be useful.Turm on through the DSN settings.Unless you specify a directory, they'll be in the users home dir.Remember to shut them off when finished as they gobble space quickly.Brad.