<?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>topic The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended. in Alteryx IO Discussions</title>
    <link>https://community.alteryx.com/t5/Alteryx-IO-Discussions/The-Designer-x64-reported-InboundNamedPipe-GetOverlappedResult/m-p/937305#M172</link>
    <description>&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Some context: we are building a custom tool for Alteryx Designer with the Platform SDK. We had an integration, but due to some issues with the first version of the Python SDK we have to migrate to V2. So currently we are in the process of manually migrating, this with the &lt;A title="Changes and Improvements to Python SDK in v2" href="https://help.alteryx.com/developer-help/changes-and-improvements-python-sdk-v2" target="_blank" rel="noopener"&gt;documentation.&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;One difference is writing to an output anchor. Previously this was done with RecordPackets and we could display some null values in the output table, as shown in following screenshot:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screenshot 2022-05-11 at 15.53.50.png" style="width: 999px;"&gt;&lt;img src="https://community.alteryx.com/t5/image/serverpage/image-id/234411i417FCBA858D65101/image-size/large?v=v2&amp;amp;px=999" role="button" title="Screenshot 2022-05-11 at 15.53.50.png" alt="Screenshot 2022-05-11 at 15.53.50.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Whilst migrating we had to transfer to use a pyarrow.Table instead. Converting to such table goes as expected. However when this table is written to an output anchor we get following error:&lt;/P&gt;&lt;P&gt;&lt;FONT color="#FF0000"&gt;The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT color="#000000"&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screenshot 2022-05-11 at 16.02.51.png" style="width: 999px;"&gt;&lt;img src="https://community.alteryx.com/t5/image/serverpage/image-id/234412i3F330D867190FD22/image-size/large?v=v2&amp;amp;px=999" role="button" title="Screenshot 2022-05-11 at 16.02.51.png" alt="Screenshot 2022-05-11 at 16.02.51.png" /&gt;&lt;/span&gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT color="#000000"&gt;By testing and searching what causes this issue, we found that this occurs when the table includes 'None' values. We managed to work around this by converting None values to strings 'None'. Following conversion is a workaround:&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="python"&gt;def convert_none_values(dictionary: Dict) -&amp;gt; Dict:
    return {key:value if value is not None else 'None' for (key, value) in dictionary.items()}&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2022-05-11 at 16.05.58.png" style="width: 999px;"&gt;&lt;img src="https://community.alteryx.com/t5/image/serverpage/image-id/234414i82055CE27E71DFDC/image-size/large?v=v2&amp;amp;px=999" role="button" title="Screenshot 2022-05-11 at 16.05.58.png" alt="Screenshot 2022-05-11 at 16.05.58.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;As you can see, updatedAt is now a string 'None' which we would like to be [null] as before, because once more: it is workaround we would like to get rid of ASAP.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;We think the 'InboundNamedPipe GetOverlappedResult: The pipe has been ended' is a bug in the first place.&lt;/P&gt;&lt;P&gt;We would love any feedback.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks in advance!&lt;/P&gt;&lt;P&gt;Mike&lt;/P&gt;</description>
    <pubDate>Wed, 11 May 2022 14:43:40 GMT</pubDate>
    <dc:creator>mikebijl</dc:creator>
    <dc:date>2022-05-11T14:43:40Z</dc:date>
    <item>
      <title>The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended.</title>
      <link>https://community.alteryx.com/t5/Alteryx-IO-Discussions/The-Designer-x64-reported-InboundNamedPipe-GetOverlappedResult/m-p/937305#M172</link>
      <description>&lt;P&gt;Hi all,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Some context: we are building a custom tool for Alteryx Designer with the Platform SDK. We had an integration, but due to some issues with the first version of the Python SDK we have to migrate to V2. So currently we are in the process of manually migrating, this with the &lt;A title="Changes and Improvements to Python SDK in v2" href="https://help.alteryx.com/developer-help/changes-and-improvements-python-sdk-v2" target="_blank" rel="noopener"&gt;documentation.&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;One difference is writing to an output anchor. Previously this was done with RecordPackets and we could display some null values in the output table, as shown in following screenshot:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screenshot 2022-05-11 at 15.53.50.png" style="width: 999px;"&gt;&lt;img src="https://community.alteryx.com/t5/image/serverpage/image-id/234411i417FCBA858D65101/image-size/large?v=v2&amp;amp;px=999" role="button" title="Screenshot 2022-05-11 at 15.53.50.png" alt="Screenshot 2022-05-11 at 15.53.50.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Whilst migrating we had to transfer to use a pyarrow.Table instead. Converting to such table goes as expected. However when this table is written to an output anchor we get following error:&lt;/P&gt;&lt;P&gt;&lt;FONT color="#FF0000"&gt;The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT color="#000000"&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screenshot 2022-05-11 at 16.02.51.png" style="width: 999px;"&gt;&lt;img src="https://community.alteryx.com/t5/image/serverpage/image-id/234412i3F330D867190FD22/image-size/large?v=v2&amp;amp;px=999" role="button" title="Screenshot 2022-05-11 at 16.02.51.png" alt="Screenshot 2022-05-11 at 16.02.51.png" /&gt;&lt;/span&gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;FONT color="#000000"&gt;By testing and searching what causes this issue, we found that this occurs when the table includes 'None' values. We managed to work around this by converting None values to strings 'None'. Following conversion is a workaround:&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="python"&gt;def convert_none_values(dictionary: Dict) -&amp;gt; Dict:
    return {key:value if value is not None else 'None' for (key, value) in dictionary.items()}&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2022-05-11 at 16.05.58.png" style="width: 999px;"&gt;&lt;img src="https://community.alteryx.com/t5/image/serverpage/image-id/234414i82055CE27E71DFDC/image-size/large?v=v2&amp;amp;px=999" role="button" title="Screenshot 2022-05-11 at 16.05.58.png" alt="Screenshot 2022-05-11 at 16.05.58.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;As you can see, updatedAt is now a string 'None' which we would like to be [null] as before, because once more: it is workaround we would like to get rid of ASAP.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;We think the 'InboundNamedPipe GetOverlappedResult: The pipe has been ended' is a bug in the first place.&lt;/P&gt;&lt;P&gt;We would love any feedback.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks in advance!&lt;/P&gt;&lt;P&gt;Mike&lt;/P&gt;</description>
      <pubDate>Wed, 11 May 2022 14:43:40 GMT</pubDate>
      <guid>https://community.alteryx.com/t5/Alteryx-IO-Discussions/The-Designer-x64-reported-InboundNamedPipe-GetOverlappedResult/m-p/937305#M172</guid>
      <dc:creator>mikebijl</dc:creator>
      <dc:date>2022-05-11T14:43:40Z</dc:date>
    </item>
  </channel>
</rss>

