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

Question

Question

sql error troubleshoot

Workflow
Updated July 8, 2016
asked on July 8, 2016

Hi,

I am trying to troubleshoot Insert Data error but i am having hard time pinpointing where error is being generated from.

My workflow has insert data activity with lots of fields but workflow is showing this generic error.

Error converting data type nvarchar to numeric.

Is there a way to find out which token value is causing the issue? I went to SQL error logs under Managment tab but i don't see anything related to this. Unfortunately i cant recreate the same error so i am not sure what to look for. Event viewer doesn't say anything as well. 

Do you guys know any way to find out which one caused the issue without going through each and every single one. I have decimal, Text, Datetime, varchar, and smallint Data Type in the SQL table. 

1 0

Answer

SELECTED ANSWER
replied on July 8, 2016

After going through each i was able to figure it out. Its the decimal that wont accept anything other than number or NULL if you choose. 

In my form i had a number field and i thought that blank value would be automatically converted to NULL, but unfortunately i was wrong. 

Solution, either assign a default value of 0 in the form or in the workflow check if it is empty, and if it is then assign it a zero or NULL value.

 

1 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 ...