Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Error-DataWrapOCI: Unable to Prepare the Query

Alteryx Partner

It worked fine.

It's awful when works in SQL Developer and it doesn't work in other places.


@CraigAustin wrote:

I had this error when I was trying to connect to the wrong DB.


Check that too.

Right... if it works in a sql console but not in Alteryx, it is probably because the sql concole is connected to a specific schema or DB, but Alteryx is not.  In Alteryx, you will need to use the fully qualified name.  I got stuck on this b/c I had a large query, all was fully qualified except for one table.  It worked in my sql console, but not in Alteryx.  Took a few minutes to figure out!