This content has been marked as final. Show 2 replies
This should be due to data issues. And the error message is due to data truncation issues.
Please check your payload that you are trying to insert into the SQL server table.
One or more fields might have a data that is exceeding its defined length with respect to the table definitions.
Problem with using SQL server is that while inserting, you will not be pointed towards which field or column is causing the error.
You have to take the pain of searching through the entire payload to find the problem causing ones.
inserting data using DB adapter in MS SQL Server. Some times I get below errorSome field is exceeding the maximum length defined in the database... Check the data that's being sent, you will either truncate the data before sending to DbAdapter or to increase the size of the filed in the database...