Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "CMN_1650 A duplicate row was inserted into a dynamic lookup cache" when a PowerCenter 9.6.1 session with Dynamic lookup fails
Problem Description

One of the PowerCenter 9.6.1 session with Dynamic lookup fails with the following error:

ERROR : (1303 | LKPDP_2:TRANSF_1_1) : (IS | is_na1dev96) : na1etl96_node_na1etldev2 : CMN_1650 : A duplicate row was attempted
to be inserted into a dynamic lookup cache [LKP_SET_FLAG]. The dynamic lookup cache only supports unique condition keys.
Cause

From PowerCenter 9.6, Lookup transformation can be active or passive.

 

This issue occurs when the table on which the lookup is built has duplicate rows. As a dynamic cached lookup cannot be created with duplicate rows, the session fails with this error.

Solution

To resolve the issue, select Use first value or Use Last value for Lookup Policy on Multiple Match at the Lookup transformation PowerCenter 9.6.1.

More Information
Applies To
Product: PowerCenter
Problem Type:
User Type:
Project Phase:
Product Version: PowerCenter 9.6.0; PowerCenter 9.6.1
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:9/11/2019 11:00 PMID:408757
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)