Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(2 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

"RR_4035: SQL Error [ORA-24333: zero iteration count" while running a session in PowerCenter
Problem Description

In PowerCenter, while running a session, the following error appears in the session log:

RR_4035 : SQL Error [ORA-24333: zero iteration count
Database driver error...
Function Name : Execute
SQL Stmt : STG_DEALERSHIP.DEALERSHIP_ID = STG_EMPLOYEES.DEALERSHIP_ID

Cause

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.

Solution
To resolve this issue, put the Join statement in the User Defined Join statement instead of in the SQL Query statement.
More Information
Refer to online documentation for information on User Defined Join statement and the SQL Query statement.
Applies To
Product: PowerCenter
Problem Type:
User Type:
Project Phase:
Product Version: PowerCenter
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:9/20/2011 4:59 PMID:121171
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)