Our system is configurated in load balancing with 2 servers.
Everything is working fine (connections...) except that we have issues to replicate modifications on both servers at the same time. For example, if we add a new field and do an update on our oracle database, depending on the server we are actually connected, we could have an error showing that the new field does not exists. The error disapear completely only if the application is restarted the next day. So, if the restart is not done we have the error showing each time we are trying to access the new object.
When you make schema modifications, frontal servers actually keep an XML copy of all schemas on the File System.
Not all servers will get the new copy.
Anything which goes into the database will be readily available to all servers but anything picked from File System will not.
So, you will have to work with a change management plan.
Whenever rolling out a new change to the schema, please ask the server team to restart web module for both servers. There will be a downtime of 5-9 seconds but since the connection is load balanced, they can
Vipul Raghav, is it compulsory to remove server from LB before restarting the web? Actually, we have tried restarting the web module and it did not help the situation. Is there any other easy mean to correct the issue?