nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error-DataWrapOCI: Unable to Prepare the Query

JordanHowell

I'm having an issue streaming data out with in-DB tool. I'm getting the error "DataWrapOCI: Unable to prepare the query: "With Tool1_Oaaf" AS query...."

Can anyone tell me what this error actually means? The query works if I run it in TOAD or SQL developer.

Error Message

In Database

In-Database

Accepted answers

JordanHowell

I woudl love to however, the error message was not saved. My apologies. What I do is within the SQL query filter, I changed a dynamic date field that went off a system date and replaced with a hard date field. At that point, it worked fine.

All comments

MikeA

Hi @JordanHowell,

Would you be able to provide the full error message? With these types of error messages the important bit it usually at the end. You can copy and paste the error message from your results window.

Thanks!

JordanHowell

kunal

I have encountered the same error. As my queries were running fine in SQL developer.

The issue with my query was a very simple one. It was ending with a semi colon(;). As SQL developer supports semi colon at the end of the query so there was no issues in executing it.

However copying the same query in Alteryx and removing Semi colon from the end of the query resolved the issue.

David-UHG

Nice Job! Unfortunately, I did not see this after spent 2 hours rewriting my query that worked perfectly fine in Toad. 2 hours for a ; thumbs up!

David-UHG

Nice Job! Unfortunately, I did not see this after spent 2 hours rewriting my query that worked perfectly fine in Toad. 2 hours for a ; thumbs up!

CraigAustin

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

Check that too.

YEM

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

jmuetzel

I had this error when I didn't reference a field from the middle table I needed to get the information on the outside tables. I just added a field from that table and it solved the issue. Then I just used a select to get rid of it.

imakosov

Removed the " ; " at the end of the sql code - and it solved the issue!

sharonschmidt

I had a similar error. The query runs fine when running it in the Designer but failed if run as a scheduled job. I did notice that there were line breaks in the query but the spaces were missing between the query words themselves. I added them back in and that fixed it.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703