SUCCESS_WITH_INFO [01004] Fetched item was truncated error message - Mailing list pgsql-odbc
| From | Dmitry Pogorelov |
|---|---|
| Subject | SUCCESS_WITH_INFO [01004] Fetched item was truncated error message |
| Date | |
| Msg-id | CAKELO4jaXtA95hjtKhgPatDJ55OcthkWbEFrVM_3vpbuLfoK0Q@mail.gmail.com Whole thread Raw |
| List | pgsql-odbc |
Hi,
I've got Microsoft Power BI (64 bit) installed on windows 7 64 bit and the latest PostgreSQL ODBC Driver 09.05.0100-x64 version. If you try to create the following table:
create table testpower_odbc_512
as select 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx';
and try to get data from the table via odbc connection in the Power BI you'll get the following error message:
DataSource.Error: ODBC: SUCCESS_WITH_INFO [01004] Fetched item was truncated.
instead of real data.
From mylog I could get the following info:
[5292-0.163]PARSE: searchColInfo by attnum=1
[5292-0.163]colAttr: col 0 field_type=705 fi,ti=000000001AC75E80,000000000056A1F0
[5292-0.163]COLUMN_TYPE=12
[5292-0.167][[SQLColAttribute]][5292-0.167]PGAPI_ColAttributes: entering..col=1 1011 len=2048.
[5292-0.167]colAttr: col 0 field_type=705 fi,ti=000000001AC75E80,000000000056A1F0
[5292-0.168]PGAPI_ColAttributes: COLUMN_NAME = '?column?'
[5292-0.169][[SQLColAttribute]][5292-0.169]PGAPI_ColAttributes: entering..col=1 1008 len=0.
[5292-0.169]colAttr: col 0 field_type=705 fi,ti=000000001AC75E80,000000000056A1F0
[5292-0.170][[SQLColAttribute]][5292-0.170]PGAPI_ColAttributes: entering..col=1 14 len=2048.
[5292-0.170]colAttr: col 0 field_type=705 fi,ti=000000001AC75E80,000000000056A1F0
[5292-0.170][[SQLColAttribute]][5292-0.170]PGAPI_ColAttributes: entering..col=1 1003 len=0.
[5292-0.170]colAttr: col 0 field_type=705 fi,ti=000000001AC75E80,000000000056A1F0
[5292-0.171]PGAPI_ColAttributes: col 0, desc_length = 255
[5292-0.171][[SQLColAttribute]][5292-0.171]PGAPI_ColAttributes: entering..col=1 32 len=0.
[5292-0.171]colAttr: col 0 field_type=705 fi,ti=000000001AC75E80,000000000056A1F0
[5292-0.172][[SQLColAttribute]][5292-0.172]PGAPI_ColAttributes: entering..col=1 1006 len=0.
[5292-0.172]colAttr: col 0 field_type=705 fi,ti=000000001AC75E80,000000000056A1F0
[5292-0.172][[SQLColAttribute]][5292-0.172]PGAPI_ColAttributes: entering..col=1 1013 len=0.
[5292-0.172]colAttr: col 0 field_type=705 fi,ti=000000001AC75E80,000000000056A1F0
[5292-0.173]PGAPI_ColAttributes: col 0, octet_length = 255
[5292-0.208][SQLBindCol][5292-0.208]PGAPI_BindCol: entering...
[5292-0.208]**** PGAPI_BindCol: stmt = 000000001AC7CD60, icol = 1
[5292-0.208]**** : fCType=1 rgb=0000000012832F68 valusMax=512 pcb=0000000002C04860
[5292-0.208]extend_getdata_info: entering ... self=000000001AC7CFF8, gdata_allocated=0, num_columns=1
[5292-0.208]exit extend_gdata_info=000000001AD21EC0
[5292-0.208] bound buffer[0] = 0000000012832F68
[5292-0.208][[SQLSetStmtAttr]] Handle=000000001AC7CD60 26,46094192
[5292-0.208]PGAPI_SetStmtAttr Handle=000000001AC7CD60 26,46094192(0000000002BF5770)
[5292-0.208][[SQLSetStmtAttr]] Handle=000000001AC7CD60 27,200
[5292-0.208]PGAPI_SetStmtAttr Handle=000000001AC7CD60 27,200(00000000000000C8)
[5292-0.208][[SQLFetch]][5292-0.208]PGAPI_ExtendedFetch: stmt=000000001AC7CD60 rowsetSize=200
[5292-0.208]SQL_FETCH_NEXT: num_tuples=1, currtuple=-1, rowst=-1
[5292-0.208]PGAPI_ExtendedFetch: new currTuple = -1
[5292-0.208]fetch_cursor=0, 000000001AC831E0->total_read=1
[5292-0.208]**** SC_fetch: non-cursor_result
[5292-0.208]fetch: cols=1, lf=0, opts = 000000001AC7CE40, opts->bindings = 000000001AD22070, buffer[] = 0000000012832F68
[5292-0.208]type = 705, atttypmod = -1
[5292-0.208]value = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
[5292-0.208]copy_and_convert: field_type = 705, fctype = 1, value = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxx', cbValueMax=512
[5292-0.208]DEFAULT: len = 512, ptr = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
[5292-0.218] SQL_C_CHAR, default: len = 512, cbValueMax = 512, rgbValueBindRow = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxx'
[5292-0.218]copy_and_convert: retval = 3
[5292-0.218]STATEMENT WARNING: func=SC_fetch, desc='', errnum=-2, errmsg='Fetched item was truncated.'
[5292-0.218]fetch_cursor=0, 000000001AC831E0->total_read=1
[5292-0.218][[SQLGetDiagField]] Handle=(3,000000001AC7CD60) Rec=1 Id=4 info=(0000000000A3B7A0,12)
[5292-0.218]PGAPI_GetDiagField entering rec=1[5292-0.218]ER_ReturnError: status = -2, msg = #Fetched item was truncated.#
[5292-0.228] szSqlState = '01004',len=27, szError='(null)'
[5292-0.228]PGAPI_GetDiagField exiting 0
[5292-0.228][[SQLGetDiagField]] Handle=(3,000000001AC7CD60) Rec=1 Id=-1248 info=(000000000045DC68,0)
[5292-0.228]PGAPI_GetDiagField entering rec=1[5292-0.228]PGAPI_GetDiagField exiting 0
[5292-0.228][[SQLGetDiagField]] Handle=(3,000000001AC7CD60) Rec=1 Id=-1247 info=(000000000045DBF0,0)
[5292-0.228]PGAPI_GetDiagField entering rec=1[5292-0.228]PGAPI_GetDiagField exiting 0
[5292-0.228][[SQLGetDiagRec]]
[5292-0.228]PGAPI_GetDiagRec entering type=3 rec=1
[5292-0.228]ER_ReturnError: status = -2, msg = #Fetched item was truncated.#
[5292-0.228] szSqlState = '01004',len=27, szError='Fetched item was truncated.'
[5292-0.228]PGAPI_GetDiagRec exiting 0
[5292-0.228][[SQLGetDiagField]] Handle=(3,000000001AC7CD60) Rec=2 Id=4 info=(0000000000A3B7A0,12)
[5292-0.228]PGAPI_GetDiagField entering rec=2[5292-0.228]ER_ReturnError: status = -2, msg = #Fetched item was truncated.#
[5292-0.228]PGAPI_GetDiagField exiting 100
If I try to create the same table in MySQL and use their ODBC driver via Power BI everything will be OK. Please tell me - is such behavior OK for current PostgreSQL ODBC driver?
Thank you.
Best Regards
Dmitry Pogorelov
pgsql-odbc by date: