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.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to resolve ODBC error.

anonymous008_G
8 - Asteroid
‎01-03-2024 05:13 AM

I was able to run the workflow properly until yesterday, but the same workflow suddenly started throwing errors as below.

 

Error: ODBCConnect (475): Tool #28: Error SQLExecute: [Oracle][ODBC][Ora]ORA-01476: divisor is equal to zero

 

Can someone please advise what this issue is and how it can be resolved?

Labels:
Reply
0 Likes
2 REPLIES 2
cjaneczko
13 - Pulsar
‎01-03-2024 05:29 AM

Can you share the SQL in tool 28? Are you using COALESCE or is there any division in your statement that would cause a division by zero?

Reply
0 Likes
jdminton
13 - Pulsar
‎01-03-2024 06:24 AM

I agree with @cjaneczko  There appears to be an error in your SQL. There is likely a "/" somewhere in the SQL that needs adjusted. Can you share the SQL. Blur out or replace the text of any confidential pieces.

Reply
0 Likes
GenAI Contest Form
Data Connection Manager
Labels
Top Solution Authors
View All