Function Strings not working with a Route

[mark_gearhart1]

I have NY and London ASE's replicating into a global replicate database. Both ASE's have their own PRS's. NY replicates directly into the global and I use function strings attached to my own function string class which is defined for the connection to the replicate. No problems. Replication is fine.

But... for London PRS I have a route over to NY RRS. I cannot figure out how to apply the function strings. Whatever I do, and I've tried everything, the function strings are not honored. The transactions go into the global replicate as if the function strings never existed.

Any tips would be helpful. I am stuck.

[mark_gearhart1 · Accepted solution]

Ah ha! I figured it out.

In order to define a function for a London repdef to be applied to a function string attached to a connection in NY, you need to set up bi-directional routes.

I had a route from London to NY, but I was missing the route from NY back to London.

Clear as mud. Trial and error.

[mark_gearhart1]

I want to apply function strings for replication from LN ASE into GLOBAL IQ. I created NY_function_class on NY and bound to NY connection into IQ. But how to bind mytable_LN_rep.rs_insert to the NY_function_class? When I create fs on NY error is: "This function string rs_insert can only be created at the primary of the function". So I created NY_function_class on LN and create fs in LN with no error. But replication into IQ does not apply the function string. That makes sense I think, because functions are applied way over in NY on the NY DSI connection.

Scope of function strings are repdef.

Tried all different combinations. There is a basic flaw in my understanding of how this is supposed to work.