JSON Parse issue from PostgreSQL Table

[Mathavadoss]

Hello Experts seeking help for JSON object ( Postgres table ) Parser issue   

Background 

 Source : PostgreSQL  

input Data tool - SQL Editor for data extract 

Extracting data from Postgres table to load in to another Postgres table 

Issue : 

 Alteryx workflow is running fine and extracting JSON objects for first time and from next run  erroring out as parser automatically adding some additional  space in-between 

Example SQL Query using in SQL Editor 

 Select 

  Column1 , 

   JSONOBject ->> " Column2"  from Postgretable ;

After first run completed successfully  SQL Editor has below changes ( Space added between   -   >   >    ) 

 Select 

  Column1 , 

   JSONOBject - > > " Column2"  from Postgretable ;

How to fix this issue ? 

Thanks ..

[JoeS]

My guess here is it's due to the conversion of the SQL to XML (this is how workflows are stored) and then back to SQL and it's a mishap there.

What version of Alteryx are you using?

[Mathavadoss]

we are using Version 2020.1.5.x