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