title: ERROR: CANNOT PARALLELIZE AN UPDATE STATEMENT THAT UPDATES THE DISTRIBUTION COLUMNS
body: <p>When trying to copy data from source (MSSQLSERVER) TO target (greenplum database) using talend  ETL server.</p>
  <p>Description: When executing an UPDATE statement to GreenPlum, the mentioned error is thrown.</p>
  <p><strong>GIVEN</strong></p>
  <p>No of records fetching to target is  ~ 0.3 million</p>
  <p><strong>Update is failing with error</strong></p>
  <pre><code> ERROR: CANNOT PARALLELIZE AN UPDATE STATEMENT THAT UPDATES THE DISTRIBUTION COLUMNS current transaction is aborted, commands ignored until end of transaction block
  </code></pre>
  <p>Any help on it would be much appreciated</p>
  <p>Solution i tried :</p>
  <p>When ON_ERROR_ROLLBACK is enabled, psql will issue a SAVEPOINT before every command you send to greenplum</p>
  <pre><code>gpadmin=# \set ON_ERROR_ROLLBACK interactive
  </code></pre>
  <p>But after that we tried running the same Job and it did not solved the problem.</p>
  <p><a href="https://i.stack.imgur.com/wSVEe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wSVEe.png" alt="enter image description here" /></a></p>