Generating queries across all application servers

[Former Member]

When making query changes, the changes only take affect on the App server the user is on (load balancing). When saved, it is not generated to all of the App servers. Is there a way to insure that all query changes are propogated to all of the app servers ?

[Former Member]

Hi

Is this BW Query's?

Usually Query changes are moved thru the landscape via transports, not directly changed by users!

Please clarify.

Reg's

Edan

[Former Member]

Yes, you are correct. We also have to generate all trasnsported queries. However, our ETL folks are now changing queries on the fly in production along with some "Super USers". When this is done, the chnages are not being propogated to all of the App servers until the query is regenerated thru RSRT. Is there some way to propogate these changes automatically.