Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MSSQL Server dbWriteTable fails without batch_row = nrow(value) #814

Closed
meztez opened this issue Jun 6, 2024 · 7 comments · Fixed by #816
Closed

MSSQL Server dbWriteTable fails without batch_row = nrow(value) #814

meztez opened this issue Jun 6, 2024 · 7 comments · Fixed by #816

Comments

@meztez
Copy link
Contributor

meztez commented Jun 6, 2024

MSSQL Server dbWriteTable fails without batch_row = nrow(value)

# Something to create a connexion
con <- ...
tb <- mtcars[rep(seq_len(nrow(mtcars)), 200),]
odbc::dbWriteTable(con, name = "#TMP_CARS", value = mtcars, overwrite = TRUE, immediate = TRUE)
odbc::dbWriteTable(con, name = "#TMP_XCARS", value = tb, overwrite = TRUE, immediate = TRUE)
#> Error in eval(expr, envir, enclos): nanodbc/nanodbc.cpp:1783: 00000
#> The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 2 (""): The supplied length is not valid for data type nvarchar(max). Check the source data for invalid lengths. An example of an invalid length is data of nchar type with an odd length in bytes.,
odbc::dbWriteTable(con, name = "#TMP_XCARS", value = tb, overwrite = TRUE, immediate = TRUE, batch_rows = nrow(tb))

Created on 2024-06-06 with reprex v2.1.0

Database 
> DBI::dbGetInfo(con)

$dbms.name
[1] "Microsoft SQL Server"

$db.version
[1] "14.00.3465"

$host
[1] ""

$port
[1] ""

$sourcename
[1] ""

$drivername
[1] "RStudio SQL Server ODBC Driver"

$odbc.version
[1] "03.52"

$driver.version
[1] "1.5.23.1024"

$odbcdriver.version
[1] "03.80"

$supports.transactions
[1] TRUE

$supports.catalogs
[1] TRUE

$supports.schema
[1] TRUE

$getdata.extensions.any_column
[1] TRUE

$getdata.extensions.any_order
[1] TRUE
Session Info 
> devtools::session_info() ─ Session info ─ Session info ─────────────────────────────────────────────────────────────────────────────────────────────
 setting  value
 version  R version 4.4.0 (2024-04-24)
 os       Ubuntu 22.04.4 LTS
 system   x86_64, linux-gnu
 ui       RStudio
 language (EN)
 collate  C.UTF-8
 ctype    C.UTF-8
 tz       America/Montreal
 date     2024-06-06
 rstudio  2024.04.0+735.pro3 Chocolate Cosmos (server)
 pandoc   3.1.12.3 @ /usr/bin/ (via rmarkdown)

─ Packages ─────────────────────────────────────────────────────────────────────────────────────────────────
 package     * version date (UTC) lib source
 askpass       1.2.0   2023-09-03 [2] CRAN (R 4.4.0)
 assertthat    0.2.1   2019-03-21 [2] CRAN (R 4.4.0)
 base64enc     0.1-3   2015-07-28 [2] CRAN (R 4.4.0)
 bigrquery     1.5.1   2024-03-14 [2] CRAN (R 4.4.0)
 bit           4.0.5   2022-11-15 [2] CRAN (R 4.4.0)
 bit64         4.0.5   2020-08-30 [2] CRAN (R 4.4.0)
 blob          1.2.4   2023-03-17 [2] CRAN (R 4.4.0)
 cachem        1.1.0   2024-05-16 [2] CRAN (R 4.4.0)
 callr         3.7.6   2024-03-25 [2] CRAN (R 4.4.0)
 cellranger    1.1.0   2016-07-27 [2] CRAN (R 4.4.0)
 cli           3.6.2   2023-12-11 [2] CRAN (R 4.4.0)
 cloud.cap     0.6.13  2024-05-01 [2] Custom
 connect.cap   0.4.14  2024-05-01 [2] Custom
 crayon        1.5.2   2022-09-29 [2] CRAN (R 4.4.0)
 curl          5.2.1   2024-03-01 [2] CRAN (R 4.4.0)
 data.table    1.15.4  2024-03-30 [2] CRAN (R 4.4.0)
 DBI           1.2.3   2024-06-02 [2] CRAN (R 4.4.0)
 devtools      2.4.5   2022-10-11 [2] CRAN (R 4.4.0)
 digest        0.6.35  2024-03-11 [2] CRAN (R 4.4.0)
 ellipsis      0.3.2   2021-04-29 [2] CRAN (R 4.4.0)
 evaluate      0.23    2023-11-01 [2] CRAN (R 4.4.0)
 extraw        1.15.25 2024-06-06 [2] local
 fansi         1.0.6   2023-12-08 [2] CRAN (R 4.4.0)
 fastmap       1.2.0   2024-05-15 [2] CRAN (R 4.4.0)
 fs            1.6.4   2024-04-25 [2] CRAN (R 4.4.0)
 gargle        1.5.2   2023-07-20 [2] CRAN (R 4.4.0)
 getPass       0.2-4   2023-12-10 [2] CRAN (R 4.4.0)
 glue          1.7.0   2024-01-09 [2] CRAN (R 4.4.0)
 hms           1.1.3   2023-03-21 [2] CRAN (R 4.4.0)
 htmltools     0.5.8.1 2024-04-04 [2] CRAN (R 4.4.0)
 htmlwidgets   1.6.4   2023-12-06 [2] CRAN (R 4.4.0)
 httpuv        1.6.15  2024-03-26 [2] CRAN (R 4.4.0)
 httr          1.4.7   2023-08-15 [2] CRAN (R 4.4.0)
 jsonlite      1.8.8   2023-12-04 [2] CRAN (R 4.4.0)
 keyring       1.3.2   2023-12-11 [2] CRAN (R 4.4.0)
 knitr         1.47    2024-05-29 [2] CRAN (R 4.4.0)
 later         1.3.2   2023-12-06 [2] CRAN (R 4.4.0)
 lifecycle     1.0.4   2023-11-07 [2] CRAN (R 4.4.0)
 magrittr      2.0.3   2022-03-30 [2] CRAN (R 4.4.0)
 memoise       2.0.1   2021-11-26 [2] CRAN (R 4.4.0)
 mime          0.12    2021-09-28 [2] CRAN (R 4.4.0)
 miniUI        0.1.1.1 2018-05-18 [2] CRAN (R 4.4.0)
 odbc          1.5.0   2024-06-05 [2] CRAN (R 4.4.0)
 openssl       2.2.0   2024-05-16 [2] CRAN (R 4.4.0)
 pillar        1.9.0   2023-03-22 [2] CRAN (R 4.4.0)
 pkgbuild      1.4.4   2024-03-17 [2] CRAN (R 4.4.0)
 pkgconfig     2.0.3   2019-09-22 [2] CRAN (R 4.4.0)
 pkgload       1.3.4   2024-01-16 [2] CRAN (R 4.4.0)
 processx      3.8.4   2024-03-16 [2] CRAN (R 4.4.0)
 profvis       0.3.8   2023-05-02 [2] CRAN (R 4.4.0)
 promises      1.3.0   2024-04-05 [2] CRAN (R 4.4.0)
 ps            1.7.6   2024-01-18 [2] CRAN (R 4.4.0)
 purrr         1.0.2   2023-08-10 [2] CRAN (R 4.4.0)
 R.cache       0.16.0  2022-07-21 [2] CRAN (R 4.4.0)
 R.methodsS3   1.8.2   2022-06-13 [2] CRAN (R 4.4.0)
 R.oo          1.26.0  2024-01-24 [2] CRAN (R 4.4.0)
 R.utils       2.12.3  2023-11-18 [2] CRAN (R 4.4.0)
 R6            2.5.1   2021-08-19 [2] CRAN (R 4.4.0)
 rappdirs      0.3.3   2021-01-31 [2] CRAN (R 4.4.0)
 Rcpp          1.0.12  2024-01-09 [2] CRAN (R 4.4.0)
 readxl        1.4.3   2023-07-06 [2] CRAN (R 4.4.0)
 remotes       2.5.0   2024-03-17 [2] CRAN (R 4.4.0)
 reprex        2.1.0   2024-01-11 [2] CRAN (R 4.4.0)
 rlang         1.1.4   2024-06-04 [2] CRAN (R 4.4.0)
 rmarkdown     2.27    2024-05-17 [2] CRAN (R 4.4.0)
 rstudioapi    0.16.0  2024-03-24 [2] CRAN (R 4.4.0)
 sessioninfo   1.2.2   2021-12-06 [2] CRAN (R 4.4.0)
 shiny         1.8.1.1 2024-04-02 [2] CRAN (R 4.4.0)
 stringi       1.8.4   2024-05-06 [2] CRAN (R 4.4.0)
 stringr       1.5.1   2023-11-14 [2] CRAN (R 4.4.0)
 styler        1.10.3  2024-04-07 [2] CRAN (R 4.4.0)
 tibble        3.2.1   2023-03-20 [2] CRAN (R 4.4.0)
 urlchecker    1.0.1   2021-11-30 [2] CRAN (R 4.4.0)
 usethis       2.2.3   2024-02-19 [2] CRAN (R 4.4.0)
 utf8          1.2.4   2023-10-22 [2] CRAN (R 4.4.0)
 utils.cap     1.4.46  2024-05-01 [2] Custom
 vctrs         0.6.5   2023-12-01 [2] CRAN (R 4.4.0)
 withr         3.0.0   2024-01-16 [2] CRAN (R 4.4.0)
 xfun          0.44    2024-05-15 [2] CRAN (R 4.4.0)
 xml2          1.3.6   2023-12-04 [2] CRAN (R 4.4.0)
 xtable        1.8-4   2019-04-21 [2] CRAN (R 4.4.0)
 yaml          2.3.8   2023-12-11 [2] CRAN (R 4.4.0)
@meztez
Copy link
Contributor Author

meztez commented Jun 6, 2024 •
edited by simonpcouch
Loading 

odbc::dbWriteTable(con, name = "#TEST", value = data.frame(A = 1:2), overwrite = TRUE, immediate = TRUE, batch_rows = 1)
EDIT from Simon: drop output into collapsible 
> odbc::dbWriteTable(con, name = "#TEST", value = data.frame(A = 1:2), batch_rows = 1, overwrite = TRUE)
nanodbc/nanodbc.cpp:1472 SQLAllocHandle(SQL_HANDLE_STMT, conn.native_dbc_handle(), &stmt_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1707 SQLSetStmtAttr(stmt_, SQL_ATTR_PARAMSET_SIZE, (SQLPOINTER)(std::intptr_t)batch_operations, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1550 SQLSetStmtAttr(stmt_, SQL_ATTR_QUERY_TIMEOUT, (SQLPOINTER)(std::intptr_t)timeout, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1719 SQLExecDirect(stmt_, (NANODBC_SQLCHAR*)query.c_str(), SQL_NTS)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2361 SQLSetStmtAttr(stmt_.native_statement_handle(), SQL_ATTR_ROW_ARRAY_SIZE, (SQLPOINTER)(std::intptr_t)rowset_size_, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2371 SQLSetStmtAttr(stmt_.native_statement_handle(), SQL_ATTR_ROWS_FETCHED_PTR, &row_count_, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1842 SQLNumResultCols(stmt_, &cols)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1842 SQLNumResultCols(stmt_, &cols)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1249 SQLGetInfo(dbc_, info_type, value, sizeof(value) / sizeof(NANODBC_SQLCHAR), &length)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1249 SQLGetInfo(dbc_, info_type, value, sizeof(value) / sizeof(NANODBC_SQLCHAR), &length)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
nanodbc/nanodbc.cpp:2629 SQLMoreResults(stmt_.native_statement_handle())
nanodbc/nanodbc.cpp:1509 SQLCancel(stmt_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1462 SQLCancel(stmt_)
nanodbc/nanodbc.cpp:1851 SQLFreeStmt(stmt_, SQL_RESET_PARAMS)
nanodbc/nanodbc.cpp:746 SQLFreeHandle(handle_type, handle)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1472 SQLAllocHandle(SQL_HANDLE_STMT, conn.native_dbc_handle(), &stmt_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1707 SQLSetStmtAttr(stmt_, SQL_ATTR_PARAMSET_SIZE, (SQLPOINTER)(std::intptr_t)batch_operations, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1550 SQLSetStmtAttr(stmt_, SQL_ATTR_QUERY_TIMEOUT, (SQLPOINTER)(std::intptr_t)timeout, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1719 SQLExecDirect(stmt_, (NANODBC_SQLCHAR*)query.c_str(), SQL_NTS)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2361 SQLSetStmtAttr(stmt_.native_statement_handle(), SQL_ATTR_ROW_ARRAY_SIZE, (SQLPOINTER)(std::intptr_t)rowset_size_, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2371 SQLSetStmtAttr(stmt_.native_statement_handle(), SQL_ATTR_ROWS_FETCHED_PTR, &row_count_, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1842 SQLNumResultCols(stmt_, &cols)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1842 SQLNumResultCols(stmt_, &cols)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1826 SQLRowCount(stmt_, &rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1509 SQLCancel(stmt_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1462 SQLCancel(stmt_)
nanodbc/nanodbc.cpp:1851 SQLFreeStmt(stmt_, SQL_RESET_PARAMS)
nanodbc/nanodbc.cpp:746 SQLFreeHandle(handle_type, handle)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1472 SQLAllocHandle(SQL_HANDLE_STMT, conn.native_dbc_handle(), &stmt_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1707 SQLSetStmtAttr(stmt_, SQL_ATTR_PARAMSET_SIZE, (SQLPOINTER)(std::intptr_t)batch_operations, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1550 SQLSetStmtAttr(stmt_, SQL_ATTR_QUERY_TIMEOUT, (SQLPOINTER)(std::intptr_t)timeout, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1719 SQLExecDirect(stmt_, (NANODBC_SQLCHAR*)query.c_str(), SQL_NTS)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2361 SQLSetStmtAttr(stmt_.native_statement_handle(), SQL_ATTR_ROW_ARRAY_SIZE, (SQLPOINTER)(std::intptr_t)rowset_size_, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2371 SQLSetStmtAttr(stmt_.native_statement_handle(), SQL_ATTR_ROWS_FETCHED_PTR, &row_count_, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1842 SQLNumResultCols(stmt_, &cols)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1842 SQLNumResultCols(stmt_, &cols)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1826 SQLRowCount(stmt_, &rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1509 SQLCancel(stmt_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1462 SQLCancel(stmt_)
nanodbc/nanodbc.cpp:1851 SQLFreeStmt(stmt_, SQL_RESET_PARAMS)
nanodbc/nanodbc.cpp:746 SQLFreeHandle(handle_type, handle)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1472 SQLAllocHandle(SQL_HANDLE_STMT, conn.native_dbc_handle(), &stmt_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:4674 SQLColumns(stmt.native_statement_handle(), (NANODBC_SQLCHAR*)(catalog), (catalog == nullptr ? 0 : SQL_NTS), (NANODBC_SQLCHAR*)(schema), (schema == nullptr ? 0 : SQL_NTS), (NANODBC_SQLCHAR*)(table), (table == nullptr ? 0 : SQL_NTS), (NANODBC_SQLCHAR*)(column), (column == nullptr ? 0 : SQL_NTS))
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2361 SQLSetStmtAttr(stmt_.native_statement_handle(), SQL_ATTR_ROW_ARRAY_SIZE, (SQLPOINTER)(std::intptr_t)rowset_size_, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2371 SQLSetStmtAttr(stmt_.native_statement_handle(), SQL_ATTR_ROWS_FETCHED_PTR, &row_count_, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1842 SQLNumResultCols(stmt_, &cols)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
nanodbc/nanodbc.cpp:1462 SQLCancel(stmt_)
nanodbc/nanodbc.cpp:1851 SQLFreeStmt(stmt_, SQL_RESET_PARAMS)
nanodbc/nanodbc.cpp:746 SQLFreeHandle(handle_type, handle)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1472 SQLAllocHandle(SQL_HANDLE_STMT, conn.native_dbc_handle(), &stmt_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1533 SQLPrepare(stmt_, (NANODBC_SQLCHAR*)query.c_str(), (SQLINTEGER)query.size())
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1550 SQLSetStmtAttr(stmt_, SQL_ATTR_QUERY_TIMEOUT, (SQLPOINTER)(std::intptr_t)timeout, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1863 SQLNumParams(stmt_, &params)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1863 SQLNumParams(stmt_, &params)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1863 SQLNumParams(stmt_, &params)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1237 SQLGetInfo(dbc_, info_type, &value, 0, nullptr)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1319 SQLSetConnectAttr(conn_.native_dbc_handle(), SQL_ATTR_AUTOCOMMIT, (SQLPOINTER)SQL_AUTOCOMMIT_OFF, SQL_IS_UINTEGER)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1935 SQLDescribeParam(stmt_, param_index + 1, &param.type_, &param.size_, &param.scale_, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1985 SQLBindParameter(stmt_, param.index_ + 1, param.iotype_, sql_ctype<T>::value, param.type_, param.size_, param.scale_, (SQLPOINTER)buffer.values_, buffer_size, bind_len_or_null_[param.index_].data())
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1757 SQLFreeStmt(stmt_, SQL_CLOSE)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1769 SQLSetStmtAttr(stmt_, SQL_ATTR_PARAMSET_SIZE, (SQLPOINTER)(std::intptr_t)batch_operations, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1550 SQLSetStmtAttr(stmt_, SQL_ATTR_QUERY_TIMEOUT, (SQLPOINTER)(std::intptr_t)timeout, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1781 SQLExecute(stmt_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2361 SQLSetStmtAttr(stmt_.native_statement_handle(), SQL_ATTR_ROW_ARRAY_SIZE, (SQLPOINTER)(std::intptr_t)rowset_size_, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2371 SQLSetStmtAttr(stmt_.native_statement_handle(), SQL_ATTR_ROWS_FETCHED_PTR, &row_count_, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1842 SQLNumResultCols(stmt_, &cols)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1842 SQLNumResultCols(stmt_, &cols)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1935 SQLDescribeParam(stmt_, param_index + 1, &param.type_, &param.size_, &param.scale_, &nullable)
<-- rc: SQL_ERROR | 
nanodbc/nanodbc.cpp:1985 SQLBindParameter(stmt_, param.index_ + 1, param.iotype_, sql_ctype<T>::value, param.type_, param.size_, param.scale_, (SQLPOINTER)buffer.values_, buffer_size, bind_len_or_null_[param.index_].data())
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1757 SQLFreeStmt(stmt_, SQL_CLOSE)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1769 SQLSetStmtAttr(stmt_, SQL_ATTR_PARAMSET_SIZE, (SQLPOINTER)(std::intptr_t)batch_operations, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1550 SQLSetStmtAttr(stmt_, SQL_ATTR_QUERY_TIMEOUT, (SQLPOINTER)(std::intptr_t)timeout, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1781 SQLExecute(stmt_)
<-- rc: SQL_ERROR | 
nanodbc/nanodbc.cpp:381 SQLGetDiagRec(handle_type, handle, (SQLSMALLINT)i, sql_state, &native_error, 0, 0, &total_bytes)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:399 SQLGetDiagRec(handle_type, handle, (SQLSMALLINT)i, sql_state, &native_error, sql_message.data(), (SQLSMALLINT)sql_message.size(), &total_bytes)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:381 SQLGetDiagRec(handle_type, handle, (SQLSMALLINT)i, sql_state, &native_error, 0, 0, &total_bytes)
<-- rc: SQL_NO_DATA | 
nanodbc/nanodbc.cpp:1344 SQLEndTran(SQL_HANDLE_DBC, conn_.native_dbc_handle(), SQL_ROLLBACK)
nanodbc/nanodbc.cpp:1348 SQLSetConnectAttr(conn_.native_dbc_handle(), SQL_ATTR_AUTOCOMMIT, (SQLPOINTER)SQL_AUTOCOMMIT_ON, SQL_IS_UINTEGER)
Error:
! nanodbc/nanodbc.cpp:1783: 00000
The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""): The supplied length is not valid for data type nvarchar(max). Check the source data for invalid lengths. An example of an invalid length is data of nchar type with an odd length in bytes.,  
Run `rlang::last_trace()` to see where the error occurred.
Called from: signal_abort(cnd)
nanodbc/nanodbc.cpp:1472 SQLAllocHandle(SQL_HANDLE_STMT, conn.native_dbc_handle(), &stmt_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:4725 SQLTables(stmt.native_statement_handle(), (NANODBC_SQLCHAR*)SQL_ALL_CATALOGS, 1, (NANODBC_SQLCHAR*)NANODBC_TEXT(""), 0, (NANODBC_SQLCHAR*)NANODBC_TEXT(""), 0, (NANODBC_SQLCHAR*)NANODBC_TEXT(""), 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2361 SQLSetStmtAttr(stmt_.native_statement_handle(), SQL_ATTR_ROW_ARRAY_SIZE, (SQLPOINTER)(std::intptr_t)rowset_size_, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2371 SQLSetStmtAttr(stmt_.native_statement_handle(), SQL_ATTR_ROWS_FETCHED_PTR, &row_count_, 0)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1842 SQLNumResultCols(stmt_, &cols)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2851 SQLDescribeCol(stmt_.native_statement_handle(), i + 1, (NANODBC_SQLCHAR*)column_name, sizeof(column_name) / sizeof(NANODBC_SQLCHAR), &len, &sqltype, &sqlsize, &scale, &nullable)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2979 SQLBindCol(stmt_.native_statement_handle(), i + 1, col.ctype_, col.pdata_, col.clen_, col.cbdata_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:2812 SQLFetchScroll(stmt_.native_statement_handle(), orientation, rows)
nanodbc/nanodbc.cpp:1462 SQLCancel(stmt_)
nanodbc/nanodbc.cpp:1851 SQLFreeStmt(stmt_, SQL_RESET_PARAMS)
nanodbc/nanodbc.cpp:746 SQLFreeHandle(handle_type, handle)
<-- rc: SQL_SUCCESS | 
Browse[1]> c
nanodbc/nanodbc.cpp:1509 SQLCancel(stmt_)
<-- rc: SQL_SUCCESS | 
nanodbc/nanodbc.cpp:1462 SQLCancel(stmt_)
nanodbc/nanodbc.cpp:1851 SQLFreeStmt(stmt_, SQL_RESET_PARAMS)
nanodbc/nanodbc.cpp:746 SQLFreeHandle(handle_type, handle)
<-- rc: SQL_SUCCESS |

Will update as I find out more about the issue.

@simonpcouch
Copy link
Collaborator

simonpcouch commented Jun 6, 2024 •
edited
Loading

Possibly related to #813, both of which I'd hypothesize are an outcome of #774.

Hypothesized issue, tested and does not resolve One thing I observe when I look through [the diff there](https://github.com//pull/774/files#diff-af2d02b6a9ed515dc1d95e050d0a6415f52350bd36dff64245f83f1b7b7413c8R153-R159)... in:

odbc/R/dbi-table.R

Lines 153 to 159 in 559718b

values <- sqlData(conn, row.names = row.names, value[, , drop = FALSE])
if (is.na(batch_rows)) {
batch_rows <- NROW(value)
if (batch_rows == 0) {
batch_rows <- 1
}
batch_rows <- min(1024, batch_rows)

#691 set batch_rows based on value rather than values, the variable created just before then—should that read NROW(values) instead?

The changes from #691 had made it to CRAN before 1.5.0, so if NROW(values) is the needed change, it hadn't been an issue by itself.

@simonpcouch
Copy link
Collaborator

I can't replicate with Microsoft's driver, but can do so with the Pro driver.

@simonpcouch
Copy link
Collaborator

In the above, 1024 is indeed the value passed for batch_rows in:

odbc/R/dbi-table.R

Line 174 in d7b2351

result_insert_dataframe(rs@ptr, values, batch_rows),

Sounds like some drivers don't support batch_rows values other than the size of the data. It had been my sense that some drivers just didn't support batch_rows values greater than the size of the data. This didn't come up in related issue threads, but I see this commit message does call that out.

@simonpcouch simonpcouch mentioned this issue Jun 6, 2024
Closed
@detule detule mentioned this issue Jun 11, 2024
Merged
@detule
Copy link
Collaborator

detule commented Jun 11, 2024

@meztez Thanks for the report and the good investigation.

Can you test #816 to see if it helps with the issue?

Thanks again

@meztez
Copy link
Contributor Author

meztez commented Jun 11, 2024

It goes through without any errors, of course, you fixed it!

Thanks

@nclsbarreto
Copy link

my apologies, but regex is not quite working (for some reason) with copy_to() that i am working with. I am still having a similar issue where dates are not working, but datetimes are. can just convert to datetime, but would like it i could avoid that step.

the following is my current system.

R version 4.3.3 (2024-02-29 ucrt)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 19045)

Matrix products: default


locale:
[1] LC_COLLATE=English_United States.utf8  LC_CTYPE=English_United States.utf8    LC_MONETARY=English_United States.utf8 LC_NUMERIC=C                          
[5] LC_TIME=English_United States.utf8    

time zone: America/Los_Angeles
tzcode source: internal

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
 [1] gtsummary_2.0.4     ggtext_0.1.2        plotly_4.10.4       ggthemes_5.1.0      rvest_1.0.4         RPostgreSQL_0.7-7   tmap_3.3-4         
 [8] odbc_1.6.0          logger_0.4.0        DBI_1.2.3           glue_1.8.0          lubridate_1.9.4     forcats_1.0.0       stringr_1.5.1      
[15] dplyr_1.1.4         purrr_1.0.2         readr_2.1.5         tidyr_1.3.1         tibble_3.2.1        ggplot2_3.5.1       tidyverse_2.0.0    
[22] gt_0.11.1           qualtRics_3.2.1     shadowtext_0.1.4    patchwork_1.3.0     RColorBrewer_1.1-3  Microsoft365R_2.4.0 psych_2.4.6.26     
[29] dbplyr_2.5.0        magrittr_2.0.3      readxl_1.4.3        pacman_0.5.1       

loaded via a namespace (and not attached):
 [1] rstudioapi_0.17.1  jsonlite_1.8.9     farver_2.1.2       rmarkdown_2.29     fs_1.6.5           vctrs_0.6.5        base64enc_0.1-3    terra_1.8-5       
 [9] janitor_2.2.0      htmltools_0.5.8.1  leafsync_0.1.0     curl_6.2.0         haven_2.5.4        tictoc_1.2.1       raster_3.6-30      cellranger_1.1.0  
[17] KernSmooth_2.23-22 htmlwidgets_1.6.4  stars_0.6-7        lifecycle_1.0.4    pkgconfig_2.0.3    sjlabelled_1.2.0   R6_2.5.1           fastmap_1.2.0     
[25] snakecase_0.11.1   digest_0.6.37      AzureAuth_1.3.3    colorspace_2.1-1   ps_1.8.1           leafem_0.2.3       crosstalk_1.2.1    lwgeom_0.2-14     
[33] fansi_1.0.6        timechange_0.3.0   httr_1.4.7         abind_1.4-8        compiler_4.3.3     proxy_0.4-27       bit64_4.5.2        withr_3.0.2       
[41] AzureGraph_1.3.4   rappdirs_0.3.3     tmaptools_3.1-1    leaflet_2.2.2      classInt_0.4-10    tools_4.3.3        chromote_0.3.1     units_0.8-5       
[49] clipr_0.8.0        callr_3.7.6        nlme_3.1-164       promises_1.3.2     gridtext_0.1.5     grid_4.3.3         sf_1.0-19          generics_0.1.3    
[57] gtable_0.3.6       tzdb_0.4.0         class_7.3-22       websocket_1.4.2    data.table_1.16.4  hms_1.1.3          sp_2.1-4           xml2_1.3.6        
[65] utf8_1.2.4         pillar_1.9.0       vroom_1.6.5        later_1.4.1        lattice_0.22-5     bit_4.5.0.1        tidyselect_1.2.1   diffdf_1.1.1      
[73] knitr_1.49         xfun_0.49          stringi_1.8.4      lazyeval_0.2.2     yaml_2.3.10        evaluate_1.0.1     codetools_0.2-19   archive_1.1.10    
[81] cli_3.6.3          munsell_0.5.1      processx_3.8.4     dichromat_2.0-0.1  Rcpp_1.0.13-1      png_0.1-8          XML_3.99-0.17      parallel_4.3.3    
[89] blob_1.2.4         reprex_2.1.1       viridisLite_0.4.2  scales_1.3.0       e1071_1.7-16       insight_1.0.1      crayon_1.5.3       rlang_1.1.4       
[97] mnormt_2.1.1

and below are the sample code i am using to test out different date formats

a_datetime_v1 <- "24Mar2025 0:00:00"
dt_1000_tbl_v1 <- tibble(INDEX_DATE_DT = rep(lubridate::dmy_hms(a_datetime_v1), 1000))
a_datetime_v2 <- "2025-03-24"
dt_1000_tbl_v2 <- tibble(INDEX_DATE_DT = rep(as.Date(a_datetime_v2), 1000))
a_datetime_v3 <- "2025-03-24"
dt_1000_tbl_v3 <- tibble(INDEX_DATE_DT = rep(lubridate::ymd(a_datetime_v3), 1000))
a_datetime_v4 <- "2025-03-24"
dt_1000_tbl_v4 <- tibble(INDEX_DATE_DT = rep(as_datetime(a_datetime_v2), 1000))

v1 and v4 work (i.e. the ones with datetimes)

the error i get for v2 and v3 is below

Error in `db_copy_to()`:
! Can't copy data to table NC_GROUP_ISCT.TEST.
Caused by error in `dplyr::db_write_table()`:
! Can't write table table NC_GROUP_ISCT.TEST.
Caused by error:
! nanodbc/nanodbc.cpp:1787: HY000
[Oracle][ODBC]Numeric value out of range. 
[Oracle][ODBC]General error. 
Run `rlang::last_trace()` to see where the error occurred.

again. apologies if this is not the place to report this issue, and the lack of regex (trying to get regex package to work i get this "#> Error in UseMethod("copy_to"): no applicable method for 'copy_to' applied to an object of class "list"" in the regex....

I am trying to save to Oracle19.

thank you.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
4 participants
@detule @meztez @simonpcouch @nclsbarreto