<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>article Qlik Replicate and Google Cloud Storage: Failed to convert file from csv to parquet in Official Support Articles</title>
    <link>https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-and-Google-Cloud-Storage-Failed-to-convert-file/ta-p/2539198</link>
    <description>&lt;P&gt;When using &lt;STRONG&gt;&lt;FONT color="#339966"&gt;Google Cloud Storage&lt;/FONT&gt;&lt;/STRONG&gt; as a target in &lt;STRONG&gt;&lt;FONT color="#339966"&gt;Qlik Replicate&lt;/FONT&gt;&lt;/STRONG&gt;, and the target &lt;STRONG&gt;&lt;FONT color="#339966"&gt;File Format&lt;/FONT&gt;&lt;/STRONG&gt; is set to &lt;FONT color="#339966"&gt;&lt;STRONG&gt;Parquet&lt;/STRONG&gt;&lt;/FONT&gt;, an error may occur if the incoming data contains invalid values.&lt;/P&gt;
&lt;P&gt;This happens because the Parquet writer validates data during the CSV-to-Parquet conversion. A typical error looks like:&lt;/P&gt;
&lt;P class="lia-indent-padding-left-30px"&gt;&lt;FONT face="courier new,courier"&gt;&lt;SPAN&gt;[TARGET_LOAD &amp;nbsp; &amp;nbsp; ]E: &amp;nbsp;Failed to convert file from csv to parquet&lt;BR /&gt;&lt;/SPAN&gt;&lt;SPAN&gt;Error:: failed to read csv temp file&lt;BR /&gt;&lt;/SPAN&gt;&lt;SPAN&gt;Error:: std::exception [1024902] &amp;nbsp;(file_utils.c:899)&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;H3&gt;&lt;STRONG&gt;&lt;FONT color="#339966"&gt;Environment&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/H3&gt;
&lt;UL class="lia-list-style-type-circle"&gt;
&lt;LI&gt;Qlik Replicate all versions&lt;/LI&gt;
&lt;LI&gt;Google Cloud Storage all versions&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;H3&gt;&lt;FONT color="#339966"&gt;&lt;STRONG&gt;Resolution&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/H3&gt;
&lt;P&gt;There are two possible solutions:&lt;/P&gt;
&lt;UL class="lia-list-style-type-circle"&gt;
&lt;LI&gt;Clean up or remove the incorrect records in the source databases&lt;/LI&gt;
&lt;LI&gt;Or add a transformation to correct or replace invalid dates before they reach the target.&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;H3&gt;&lt;STRONG&gt;&lt;FONT color="#339966"&gt;Cause&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/H3&gt;
&lt;P&gt;In this case, the source is SAP Oracle, and a few rare rows contained invalid date values. Example:&amp;nbsp;&lt;FONT face="courier new,courier"&gt;2023-11-31&lt;/FONT&gt;.&lt;/P&gt;
&lt;P&gt;By enabling the internal parameters &lt;STRONG&gt;keepCSVFiles&lt;/STRONG&gt; and &lt;STRONG&gt;keepErrorFiles&lt;/STRONG&gt; in the target endpoint (both set to &lt;STRONG&gt;TRUE&lt;/STRONG&gt;), you can inspect the generated CSV files to identify which rows contain invalid data.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;H3&gt;&lt;FONT color="#339966"&gt;&lt;STRONG&gt;Internal Investigation ID(s)&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/H3&gt;
&lt;P class="lia-indent-padding-left-30px"&gt;00417320&lt;/P&gt;</description>
    <pubDate>Mon, 15 Dec 2025 06:00:43 GMT</pubDate>
    <dc:creator>john_wang</dc:creator>
    <dc:date>2025-12-15T06:00:43Z</dc:date>
    <item>
      <title>Qlik Replicate and Google Cloud Storage: Failed to convert file from csv to parquet</title>
      <link>https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-and-Google-Cloud-Storage-Failed-to-convert-file/ta-p/2539198</link>
      <description>&lt;P&gt;When using &lt;STRONG&gt;&lt;FONT color="#339966"&gt;Google Cloud Storage&lt;/FONT&gt;&lt;/STRONG&gt; as a target in &lt;STRONG&gt;&lt;FONT color="#339966"&gt;Qlik Replicate&lt;/FONT&gt;&lt;/STRONG&gt;, and the target &lt;STRONG&gt;&lt;FONT color="#339966"&gt;File Format&lt;/FONT&gt;&lt;/STRONG&gt; is set to &lt;FONT color="#339966"&gt;&lt;STRONG&gt;Parquet&lt;/STRONG&gt;&lt;/FONT&gt;, an error may occur if the incoming data contains invalid values.&lt;/P&gt;
&lt;P&gt;This happens because the Parquet writer validates data during the CSV-to-Parquet conversion. A typical error looks like:&lt;/P&gt;
&lt;P class="lia-indent-padding-left-30px"&gt;&lt;FONT face="courier new,courier"&gt;&lt;SPAN&gt;[TARGET_LOAD &amp;nbsp; &amp;nbsp; ]E: &amp;nbsp;Failed to convert file from csv to parquet&lt;BR /&gt;&lt;/SPAN&gt;&lt;SPAN&gt;Error:: failed to read csv temp file&lt;BR /&gt;&lt;/SPAN&gt;&lt;SPAN&gt;Error:: std::exception [1024902] &amp;nbsp;(file_utils.c:899)&lt;/SPAN&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;H3&gt;&lt;STRONG&gt;&lt;FONT color="#339966"&gt;Environment&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/H3&gt;
&lt;UL class="lia-list-style-type-circle"&gt;
&lt;LI&gt;Qlik Replicate all versions&lt;/LI&gt;
&lt;LI&gt;Google Cloud Storage all versions&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;H3&gt;&lt;FONT color="#339966"&gt;&lt;STRONG&gt;Resolution&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/H3&gt;
&lt;P&gt;There are two possible solutions:&lt;/P&gt;
&lt;UL class="lia-list-style-type-circle"&gt;
&lt;LI&gt;Clean up or remove the incorrect records in the source databases&lt;/LI&gt;
&lt;LI&gt;Or add a transformation to correct or replace invalid dates before they reach the target.&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;H3&gt;&lt;STRONG&gt;&lt;FONT color="#339966"&gt;Cause&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/H3&gt;
&lt;P&gt;In this case, the source is SAP Oracle, and a few rare rows contained invalid date values. Example:&amp;nbsp;&lt;FONT face="courier new,courier"&gt;2023-11-31&lt;/FONT&gt;.&lt;/P&gt;
&lt;P&gt;By enabling the internal parameters &lt;STRONG&gt;keepCSVFiles&lt;/STRONG&gt; and &lt;STRONG&gt;keepErrorFiles&lt;/STRONG&gt; in the target endpoint (both set to &lt;STRONG&gt;TRUE&lt;/STRONG&gt;), you can inspect the generated CSV files to identify which rows contain invalid data.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;H3&gt;&lt;FONT color="#339966"&gt;&lt;STRONG&gt;Internal Investigation ID(s)&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/H3&gt;
&lt;P class="lia-indent-padding-left-30px"&gt;00417320&lt;/P&gt;</description>
      <pubDate>Mon, 15 Dec 2025 06:00:43 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-and-Google-Cloud-Storage-Failed-to-convert-file/ta-p/2539198</guid>
      <dc:creator>john_wang</dc:creator>
      <dc:date>2025-12-15T06:00:43Z</dc:date>
    </item>
  </channel>
</rss>

