System. Data. sqlclient. sqlexception: truncates string or binary data.

System. Data. sqlclient. sqlexception
The string or binary data is truncated.
The statement has been terminated.

 

This problem occurs because the field size of the temporary table that will be truncated during table creation. Then, when the row is inserted, it exceeds the size of this field. Dedicated,DbspsreportingThe following stored procedures in the database are caused by this problem:

• Usp_insert_factfilestorageA Stored Procedure namedTbltempfilestorage_tofactstorageTemporary table. This tableFiletypeThe field is incorrectly defined as nvarchar (25 ). Instead,FiletypeThe field must be inDbspsreporting. DBO. tbldocsTableDoctypeField match.
• Usp_insert_factwssA Stored Procedure namedTbltempwss_tofactloadTemporary table. The following fields are incorrectly defined in this table:
  • Wssdate
  • Wssuser
  • Wssdoc

  These fields must matchDbspsreportingstaging. DBO. tblwsslogdataCorresponding fields in the table.

Check the database and find that the field definition is too small. varchar (200) has been exceeded. Change to varchar (2000)

Error Correction!