Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Need help understanding the root cause of this error

AlbertP97
5 - Atom

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?

 

 

image (2).png

3 REPLIES 3
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

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.

 

apathetichell
19 - Altair

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.

AlbertP97
5 - Atom

Thank you both for the help

Labels
Top Solution Authors