Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Error Message while using Connect In-DB

Coral
6 - Meteoroid

I'm using 3 Connect In-DB tools on one canvas, only one of them keeps return this error message:

 

"Connect In-DB (5) Error SQLPrepare: [Simba][HiveODBC] (35) Error from Hive: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE'."

 

They are all connected to the same database. A more refined query works fine. Is this error caused by a record limit? What are the aspects to pay attention to when using the Connect In-DB tool? 

 

Thank you!

 

S. 

3 REPLIES 3
SydneyF
Alteryx Alumni (Retired)

Hi @Coral,

 

I am going to open a support case on this matter, and follow up with you via email. 

 

Thanks!

 

SydneyF - Customer Support Engineer

MGA
7 - Meteor

Any known fix for this? Thanks very much

sxa445
7 - Meteor

Any update on this? 

Labels
Top Solution Authors