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?
Hi @AlbertP97
I am not an expert of DB connection, but
searching the community with "DataWrap2ODBC::SendBatch", I found a bunch of discussions on varous DBMS.
< Search Result >
You may want to try some of the solutions there.
Good luck.
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.
Thank you both for the help