Tag Archives: ORA-24333

Short reminder for Informatica ORA-24333: zero iteration count

When you run an Informatica  workflow and you get the following error message

ORA-24333: zero iteration count

Database driver error...
Function Name : Execute
SQL Stmt :       TABLE_NAME.COL1='A'
Oracle Fatal Error
Database driver error...
Function Name : Execute
SQL Stmt TABLE_NAME.COL1='A'
Oracle Fatal Error].

The Informatica error description in https://kb.informatica.com/solution/18/Pages/121171.aspx  say

” This error occurs because the SQL query sent to the database for the Source Qualifier only contains the Join statement – this is caused by putting the JOIN-statement in the SQL Query property instead of in the User Defined Join property of the Source Qualifier.”

This is a little confusing because the message talks about joins when in many cases, like the above example, there is no join.

 

Still the problem is the same and all you need to do is to move the query from the SQL QUERY to the USER DEFINED JOIN section

ORA-24333