Alteryx Server error while doing 'Delete and Append'

Question

Hello All,

I am using Alteryx tool version is: 2019.3.5.17947

And Alteryx Server version is :2019.4.6.21113

And My database is Greenplum

In my Workflows am using ‘Generic ODBC’ file connection in ‘Connect IN-DB’ and ‘Write Data IN-DB’  then in the target I am doing ‘Delete and Append’ which is working as expected in the Alteryx tool but when I run workflow from the server it is giving Error: ‘Delete and Append is not Allowed on this connection’ and  if I change that option to ‘Drop and Insert’ instead of ‘Delete and Append’ it is working.

And I have another workflow where am using Input data Tool and Out data tool and using same connection with option ‘Delete and Append’, it is working as expected when I run in Alteryx Server.

Could you please suggest me what I can do to overcome this error message when am choosing ‘Delete and Append’ option in ‘In DB Connection’

Note: If I use ‘Greenplum’ connection instead of ‘Generic ODBC’ file connection in ‘Connect IN-DB’, It will not even allow me to save the workflow in the Alteryx Server gallery.

Thanks

Avanti.

Avanthi · Answer

Thank you for the reply Reychase, I can't do that because I am using 'Write data In-DB' since I have large data set I cant use 'output data' tool, it will minimize the performance.

Thanks

Avanti.

raychase · Answer

I have run into similar issues with the 'Delete and Append' option between Designer and Server.  My solution has always been to switch the configuration to 'Append Existing', and configure a Pre-SQL statement to handle the delete.