Problem:
When using query override, error msg is ”Invalid lookup override ” and Below is the Query:
”select a.accid, a.trans_date, a.trans_amt from acct_trans a, (select accid, max(trans_date) trans_date from acct_trans group by accid) b where a.accid=b.accid and a.trans_date=b.trans_date”
Sol:
This error may occurs when using sub-queries in a lookup SQL override and the LookupOverrideParsingSetting custom property is not set.
From the Administration Tab, go to the Integration Service > Process Tab
Add a custom property lookupOverrideParsingSetting and set the value =1 .
Disable and re-enable the Integration service and re-run the session.
