String data, right truncation

[Addy2020]

While Uploading dataset to SQL Server using R getting following error:

"nanodbc/nanodbc.cpp:1655: 22001: [Microsoft][ODBC SQL Server Driver]String data, right truncation "

It seems to be column width issue but this error is not pointing me to any column. I have done upload of different PBI datasets many times though R getting this error for the first time.

Kindly help.

[v-xiaoyan-msft]

Hi @Addy2020 ,

Have you updated your SQL Server to the latest version?

We have found that inappropriate versions can also cause this problem.
I am not good at this, but I can confirm that the problem is with SQL Server, as your error port is [Microsoft][ODBC SQL Server Driver].
Please refer to the following two links to see if they help you.

sql-create-table-from-r-string-data-right-truncation 

KB2996629 - FIX: "String data, right truncation" error when you do bulk copy on DBCS by using ODBC D... 

Hope it helps,

Community Support Team _ Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Addy2020]

Hi @v-xiaoyan-msft 

1st link talks about this issue fixed in SQL Server 2014. Mine is 2017 so it must contain that fix.

2nd link - in this case user had only 1 column so easy to apply fix in my case i have 84 columns so difficult to find out which column has size issue.

[v-xiaoyan-msft]

Hi @Addy2020 ,

Sorry for not being able to provide a specific solution, but in order to better solve your problem, we recommend that you visit the SQL forum here for more professional support.

Hope it helps,

Community Support Team _ Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Addy2020 , seem more related sql server,

refer to this  type of error in this past

https://stackoverflow.com/questions/183488/what-does-the-sql-server-error-string-data-right-truncati...

[Addy2020]

Hi @amitchandak 

The link you shared has error which referes probelamatic column while in my case error doesn't mentions problematic column in the absence of which its difficult to find column with problem.