title: COPY command runs but no data being copied from Teradata (on-prem)
body: <p>I am running into an issue where I have a set up a pipeline that gets a list of tables from Teradata using a Lookup activity and then passes those items to a ForEach activity that then copies the data in parallel and saves them as a gzipped file. The requirement is to essentially archive some tables that are no longer being used.</p>
  
  <p>For this pipeline I am not using any partition options as most of the tables are small and I kept it to be flexible.</p>
  
  <p><strong>Pipeline</strong></p>
  
  <p><a href="https://i.stack.imgur.com/V9Zfs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/V9Zfs.png" alt="enter image description here"></a></p>
  
  <p><strong>COPY activity within ForEach activity</strong>
  <a href="https://i.stack.imgur.com/wBii7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wBii7.png" alt="enter image description here"></a></p>
  
  <p>99% of the tables ran without issues and were copied as gz files into blob storage, but two tables in particular run for long time (apprx 4 to 6 hours) without any of the data being written into a blob storage account.</p>
  
  <p><a href="https://i.stack.imgur.com/Ib5RF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ib5RF.png" alt="image"></a></p>
  
  <p>Note that the image above says "Cancelled", but that was done by me. Before that I had a run time as described above, but still no data being written. This is affecting only 2 tables.</p>
  
  <p>I checked with our Teradata team and those tables are not being used by any one (hence its not locked). I also looked at "Teradata Viewpoint" (admin tool) and looked at the query monitor and saw that the query was running on Teradata without issues.</p>
  
  <p>Any insight would be greatly apreciated.</p>