You are viewing limited content. For full access, please sign in.

Question

Question

String or binary data would be truncated. The statement has been terminated.

Workflow How To
Updated February 4, 2021
asked on January 28, 2021

I'm trying to insert values from a LF Form into a SQL table, but I continue to receive the message mentioned in the Title.  Not sure what I'm doing wrong.  

 

In workflow, I have a Retrieve Business Process Variables and Insert Data.  It's blowing up on the Insert Data action.  I've made sure I have nvarchar as my column values in my table and that they can have null values (just so there isn't an issue with bringing everything over).  Any guidance would be greatly appreciated.  Thank you!

0 0

Answer

SELECTED ANSWER
replied on January 28, 2021 • Show version history

The value you're putting into the column is too long for the column. Although you're using nvarchar, the length of the column data matters. If you didn't specify, the default is only 1.

Take a look at how many characters you could possibly get from your form field(s) and your column length should be at least that much or maybe a little more for safety.

3 0
replied on February 4, 2021

You were right.  I didn't have enough room on one of my columns.  Thank you for having me double check.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...