topic Re: Data truncation error in Talend Studio

Data truncation error

Rathesh — Fri, 15 Nov 2024 23:41:43 GMT

Hello,

I have created a job to load data from SQL Server on-prem to Azure SQL Server. Source table is having 25 million records. My job flow is tMSSQLInput-->tMap-->tFileOutputDelimited-->tAzureStoragePut-->tDBRow. I am using bulk load script inside tDBRow, which will fetch the data from blob storage and insert into DB. Source and Destination tables are having the same schema. While running the job in tDBRow, I am getting data truncation error. When I checked file(in tFileOutputDelimited), length is same. Source and Destination column size are NVarchar(120). While writing into a file it is string with length 60. How to resolve this?

Re: Data truncation error

Anonymous — Mon, 27 Sep 2021 01:27:01 GMT

Maybe the error occurs on another column, not the column whose size are NVarchar(120) you mentioned. I would suggest to do more debugging to find which column/records throws the error.

Regards

Shong

Re: Data truncation error

Rathesh — Tue, 12 Oct 2021 15:37:23 GMT

Thanks for your response. Issue is with the encoding. When i changed to UTF-8, it worked. Currently I am facing com.microsoft.sqlserver.jdbc.SQLServerException:Read timed out error. When anyone of the job failed due to this all the other jobs running in parallel are failing