Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table suspend with error with the follwoing error in LR task, with target as SQL Managed instance.
could not see any issue /diiference in DDL on source and target.
RetCode: SQL_SUCCESS SqlState: 22001 NativeError: 0 Message: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation
Could you help to understand what causing the issue. On verbose could not fetch the exact column undergoing the truncation.
Hello @Kohila ,
This error message typically indicates that you are trying to insert or update data into a SQL Server table and the data you are trying to insert or update exceeds the maximum length of the column in the table.
Check the data types and lengths of the columns in the table you are trying to insert or update. Make sure that the data you are trying to insert or update matches the data type and length of the column. For example, if the column is of type varchar(10), make sure that the data you are trying to insert or update is 10 characters or less.
Check the length of the data you are trying to insert or update. If the data is longer than the maximum length of the column, you will need to truncate the data before inserting or updating it. You can use functions like LEFT or SUBSTRING in your SQL statement to truncate the data.