Hello,
I was exploring solution on Alteryx community and applied already few of them:
1. sqlnet.expire_time = 20 was set on Oracle database level and in sqlnet.ora file on machine where I am running the workflow
2. block until done is not working for me
Current state:
Sometimes I can upload data without issues, but it gives me error as well. So, it is not consistent.
This is what Oracle DB administrator is saying:
"Are we sure there is no timeout value set somewhere in Alteryx? We don’t see these errors on any of the other systems.
These errors seem to come when the Oracle DB server pings Alteryx to check it is still there and receives no response. Is there something you can set in Alteryx to ensure it replies back to Oracle periodically?"
Thanks for your help.