Querying External table in SSMS

Kman 46

We have a CDATA and PolyBase configured in our sql 2019 server. Many of the external tables pull data from Mongodb and all are working fine. But there is one that is erroring out with the below message. User's image

Kman 46 Reputation points

2023-04-19T16:38:42.8+00:00

here is the error Msg 105082, Level 16, State 1, Line 1 105082;Generic ODBC error: OdbcBufferReader.ReadBuffer, error in OdbcReadBuffer: SqlState: HY009, NativeError: -1, 'Error calling: SQLFetch(this->GetHstmt()), SQL return code: -1 | SQL Error Info: SrvrMsgState: 0, SrvrSeverity: 0,
Error <1>: ErrorMsg: Invalid use of null pointer | Error calling: pReadConn->ReadBcpBuffer(pBuffer, bufferOffset, bufferLength, pBytesRead, pRowsRead, pFirstCompleteRowStartOffset, pLastCompeleteRowEndOffset) | state: FFFF, number: 6109, active connections: 9', Connection String: Dsn=XXXXXXXX-prod;server=XXXX.teainc.org;port=XXXX;database=xxx. OLE DB provider "MSOLEDBSQL" for linked server "(null)" returned message "Unspecified error". Msg 7421, Level 16, State 2, Line 2 Cannot fetch the rowset from OLE DB provider "MSOLEDBSQL" for linked server "(null)". .
LiHongMSFT-4306 25,651 Reputation points

2023-04-20T06:57:37.0733333+00:00

Hi @Kman

Many of the external tables pull data from Mongodb and all are working fine. But there is one that is erroring out with the below message.

It seems like sort of buffer issue, maybe you are getting an internal buffer limitation within polybase.
Kman 46 Reputation points

2023-04-26T14:04:37.8933333+00:00

So what how can i fix that? Thanks

Share via

Querying External table in SSMS