Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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