[CR #464293] The lookup in the project Demo DB Lookup Dynamic works in the simulation environment but not when executed on the GRID engine. The reason is a wrong case of the predefined variable for the lookup key value.
To correct this problem:
Open the project Demo DB Lookup Dynamic from the Demo Repository.
Select the Change Product Number to US Standard (DB Lookup Dynamic) component.
Click the Edit button of the Query property.
Change the WHERE clause of the query to
WHERE SOURCE = rtrim('[Lookup]')
Click Save.
Close and save the project.
