Need help understanding the root cause of this error

AlbertP97

Hello,

I need help understanding why I get this error message when running a workflow. Sometimes I will just re-rerun the workflow and everything will work fine. Long term I don't think this is scalable and want to know what's the root cause. Has anyone come across this?

apathetichell

The error is that SAP S4 Hana is closing the connection with your local machine. There are NUMEROUS reasons that this could be happening but if it runs when you trigger from Designer as a workflow vs as an app -> I'd look at timeout and VPN issues. You can turn on ODBC logging at a driver level and see what happens. You can also check the S4 HANA logs to see why the connection is closing.

From a purely Alteryx standpoint -> I'd recommend writing the output to a .yxdb to see what you are trying to write. The ????? in values makes it look like that there is no data or S4 hana doesn't understand your data (that would be if something Alteryx is trying to write doesn't fit into an expected schema). You should confirm that the data looks like it should and is the correct type for yoru database.