Currently in a project where i am migrating mutiple application flows from IIB 10 to ACE 13.
After a full extract this has provided the policy files for all the configurable services previously used in the older version, these have been working well untill the most recent flow migration.
This flow (simplified) uses a compute node to query an oracle DB table which has many rows, on each row there are columns which supply file pickup directory, security identity name and what was the configurable service name amongst others.
this compute node gets this information and sets the LocalEnvironment.Destination.File.Remote.Server to the name of the configurable service which previously was then used in a file read node off of the out terminal to overwrite the default property in the "Server and Port" field in the FTP tab.
The database has been updated to have the policy name where the configurable service used to be, i can see this being set in the environment tree under remote.server as before.
The problem i am having is the default property set in the flow on the FTP tab which is set to another policy which is present "I had to populate this field as mandatory, and was populated with the same value in IIB" is being used instead of the LocalEnvironment value as before.
Ive tried multiple things but im a bit lost now, ive tried to change the default property in the flow to be $LocalEnvironment.Destination.File.Remote.Server but this then give an error of "Cant be an empty field" in the windows event viewer as the flow restarts however it does let me deploy.
My question is how do i set the "Server and Port" field dynamically from my compute node to point at the correct policy from the DB table.
ive tried to illistrate this in a image attached
Appreciate any help with this matter.