Alteryx Designer Desktop Discussions

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

Write data in-DB Vs Output Data tool (Oracle)

Xeu911
8 - Asteroid

Hi,

 

I have an issue within a workflow when trying to update / create a table in Oracle.

 

Context : Everything is done using In-DB tools in the workflow. The issue happens when I'm trying to update an existing DB, or creating a new one. As soon as I use the "Write data in-DB" tool, I get an error message "ORA-00933 sql command not properly ended". 

However, using the "Output Data tool" in Memory I don't have any issue (either to update or create the table).

 

I cannot share the workflow since it contains client's data, but I would really appreciate if someone could give me a hint on this one!

 

Thanks,

Clément

1 REPLY 1
apathetichell
19 - Altair

turn on logs in your odbc connection - compare logs. send to alteryx support. This sounds like a bug.

Labels