error in writing value to a Database

A Score Level 1

An error occurred while trying to write to the entity “CLN_SGP_WORKFLOW” [id=94565833-f6e7-4b2d-9113-1ba58f0398ef@172826, type=CLN_SGP_WORKFLOW (id=8198)] (data store: APAC_DS). Details: org.hibernate.exception.DataException: could not insert: [CLNSGPWORKFLOWDT34973]: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated. Data: TypedValue[it=8198,v={<null>,20492,test_ah_user1,2019-10-14 10:20:53.01,2019-10-14 10:20:53.01,I,268547807,test_ah_user1,,In-country confirm sending cheque to correct address,,,ok comment,<null>}]

Parents
  • Based on the exception it seems that it is trying to insert any data in string (varchar,nvarchar,char,nchar) data type column which is more than size of the column. So you need to check the data size with respect to the column width and identify which column is creating problem.

Reply
  • Based on the exception it seems that it is trying to insert any data in string (varchar,nvarchar,char,nchar) data type column which is more than size of the column. So you need to check the data size with respect to the column width and identify which column is creating problem.

Children

 Discussion posts and replies are publicly visible