I've been getting an error recently which I have not been able to find any useful information online for. I am pulling data from a table going back to 2020 to current date. The Alteryx workflow use to take about an hour to run in the past but recently it is taking more than 4 hours to run and I also get the following error which I can't quite determine the root cause for: Error running PreSQL on "NoTable": [Simba][Hardy] (35) Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'.
I am not sure if this is a data limit issue.
In the Alteryx Workflow, the error usually occurs at the creation of this Write In-DB/table tool. We have limited amount of data to try to determine the root cause of the issue but the error still happens randomly somedays and other days the workflow runs without errors.
Because the workflows runs fine somedays and runs into this error someday, I can't tell if this is related to a connection issue.
Has anyone encountered or read about this issue before? If so, can you please help me as I am in a time crunch to fix this issue. Thank you so much in advance for your time and consideration.
ok, I've been able to configure the ODBC driver that you suggested. I rerun the workflow and keep you posted whether it solves the problem or not. Thank you!