Dynamic lookup cache error

[smajay]

hi,
Getting following error when I run a session that uses dynamic lookup cache.

CMN_1650 A duplicate row was attempted to be inserted into a dynamic lookup cache [LKP_PART_RATE]. The dynamic lookup cache only supports unique condition keys.


Pls. let me know if any one has the answer.

Thanks
Ajay

 

[Dagon]

The error pretty much says it. You've got to make sure that the key values in your dynamic cache are unique. Unlike static caches, dynamic caches don't support duplicate key values. You need to make sure the statement building the cache produces unique values for the key you're looking up on. Try doing a lookup override with a select distinct in it.