How to resolve ODBC error.

Question

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?

jdminton · Answer

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.

cjaneczko · Answer

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?