community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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.

Meteoroid

@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!

Labels