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

Question

Workflow completes successful but no data written to SQL

Workflow

Updated September 26, 2018

asked on September 21, 2018

Hi All

We have a workflow that must write data into a SQL table. When we do a search on the workflow, it shows that it completed successfully, but when we do a select statement from the SQL table, no data is written in.

Any ideas on where to look for this error

0 0

Replies

replied on September 26, 2018

Also did you use the "Insert Data" or the "Custom Query" task? Have you checked that the connection is pointing to the correct SQL server and table?

1 0

replied on September 21, 2018

For troubleshooting, have a look in the Windows Event Log of the server that is running workflow.

You can also check the SQL server logs via SSMS as well.

0 0

replied on September 21, 2018

How did you check whether your activity had any data to write?

Can you post screenshots of your workflow?

0 0

replied on September 26, 2018

Hi Miruna

I will have a look at the tokens used and will post some screenshots

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked September 21, 2018
Updated September 26, 2018
83 views