DataFlow is getting stuck

Legacy Contributor

Hi everyone, 

 

I'm developing a dataflow which move data from local SQL Server to Azure SQL Server, these are the steps:

1.- Read the information through a Stored Procedure from SQL Server.  <--- OK

2.- Send the information to destiny (Stored Procedure SQL on Azure). <--- OK

3.- Getting the acknowledgment/response from azure (OK or Error message). <--- OK

4.- Update the local database with incomming Azure data response. (OK or Error message). <--- It's stuck here

But, unfortunately the last step is not running, its getting on queue, and its never end.

Do you know what I'm doing wrong?, I'll really appreciate your help or suggestions. Thanks.

Legacy Contributor

Hello:

Can you please share the document configuration (in the connection points ->documents tab) that is responsible for sending the response of "Insert DB Azure" to the "Update DB local" step? 

Are you using a "request/reply" scenario (type 2 in the below pic) or a trigger scenario (type 4 in the below pic)? 

Best Regards

Vignesh