INVALID LOOKUP OVERRIDE

[cognos11]

I am getting the following error when i run my workflow.
When i validated it, it gave 'NO errors deteced'.
I also checked the query in database and it worked fine.
Any thoughts on this please!

TRANSF_1_1_1_1> DBG_21263 Invalid lookup override REF_SOURCE_SYSTEM_ID = 10 and REFERENCE_TABLE_NAME = 'NSF_TRANSACTIONS'

 

[bardhaan]

Hi,
1)Be sure that yopu have those ports as lookup port in the transformation or not.
2) In the sql override you have to write a full sql query. You cannot write only "REF_SOURCE_SYSTEM_ID = 10 and REFERENCE_TABLE_NAME = 'NSF_TRANSACTIONS'"
for that press the generate sql tab in lkp transformation and then override the sql with your required conditions.

Regards,
Ani