title: AWS DMS - Oracle to PG RDS full load operation error - failed to load data from csv file
body: <p>I am trying to move data from a oracle instance to postgres RDS using DMS. I am only doing a full load operation and I have disabled all the foreign keys on the target. I also made sure that the datatypes are not mismatched between columns for the same tables. I tried both 'Do Nothing' and 'Truncate' for the Target Table preparation mode and when I run the task, several tables are failing with below error messages:</p>
  
  <pre><code>[TARGET_LOAD ]E: Command failed to load data with exit error code 1, Command output: &lt;truncated&gt; [1020403] (csv_target.c:981)
  [TARGET_LOAD ]E: Failed to wait for previous run [1020403] (csv_target.c:1578)
  [TARGET_LOAD ]E: Failed to load data from csv file. [1020403] (odbc_endpoint_imp.c:5648)
  [TARGET_LOAD ]E: Handling End of table 'public'.'SKEWED_VALUES' loading failed by subtask 6 thread 1 [1020403] (endpointshell.c:2416)
  </code></pre>
  
  <p>DMS doesn't give the correct error information and I am not able to understand what the above error messages mean. </p>
  
  <p>When I use 'Drop tables on target' for the Target table preparation mode, it works but it creates the datatypes of the columns in a different way which I don't want.</p>
  
  <p>Any help would be appreciated.</p>