{"id":429,"date":"2019-12-16T07:09:37","date_gmt":"2019-12-16T11:09:37","guid":{"rendered":"http:\/\/dbtricks.com\/?p=429"},"modified":"2019-12-16T07:09:37","modified_gmt":"2019-12-16T11:09:37","slug":"short-reminder-for-informatica-ora-24333-zero-iteration-count","status":"publish","type":"post","link":"https:\/\/dbtricks.com\/?p=429","title":{"rendered":"Short reminder for Informatica ORA-24333: zero iteration count"},"content":{"rendered":"\n

When\nyou run an Informatica  workflow and you get\nthe following error message <\/p>\n\n\n\n

ORA-24333: zero iteration count\n\nDatabase driver error...\nFunction Name : Execute\nSQL Stmt :       TABLE_NAME.COL1='A'\nOracle Fatal Error\nDatabase driver error...\nFunction Name : Execute\nSQL Stmt TABLE_NAME.COL1='A'\nOracle Fatal Error].\n\n<\/code><\/pre>\n\n\n\n
The Informatica error description in https:\/\/kb.informatica.com\/solution\/18\/Pages\/121171.aspx<\/a>\u00a0 say <\/p>\n\n\n\n
\n\n” This error occurs because the SQL query sent to the database for the Source Qualifier only contains the Join <\/em>statement – this is caused by putting the JOIN-statement in the SQL Query<\/em> property instead of in the User Defined Join<\/em> property of the Source Qualifier.”\n\n<\/p>\n\n\n\n
This is a little confusing because the message talks about joins when in many cases, like the above example, there is no join.<\/p>\n\n\n\n
\u00a0<\/p>\n\n\n\n
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<\/strong><\/p>\n\n\n\n
\"\"
ORA-24333<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"
When you run an Informatica  workflow and you get the following error message The Informatica error description in https:\/\/kb.informatica.com\/solution\/18\/Pages\/121171.aspx\u00a0 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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[112],"class_list":["post-429","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-ora-24333"],"_links":{"self":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=429"}],"version-history":[{"count":6,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/429\/revisions"}],"predecessor-version":[{"id":444,"href":"https:\/\/dbtricks.com\/index.php?rest_route=\/wp\/v2\/posts\/429\/revisions\/444"}],"wp:attachment":[{"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtricks.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}