Hi Team , we have installed Oracle Forms and reports 12c on linux on 2 separate app servers ( node 1 and node 2) with load balancer. Reports are getting created on the server without any issues but when we use web.showdocument to display the report on the browser from cache using the report job URL of load balancer (http://xxxxxxxxx.xxx.com/reports/rwservlet/showjobs?server=rep_bfe_reports_uat)) . when we run node1 forms , reports are generated under node1 but while displaying on the browser , load balancer redirects to report server from node 2 which results in incorrect report or error with not found Job id.
Currently loadbalancer treats web.showdocument as a new session and hence chooses the optimal report node which sometimes may not be the same node where the report job is created.
This is not an issue with the loadbalancer as it does what it is supposed to do for a new https:// request.Is it possible to run forms on both the node1/2 running reports on only node only (say node-1).. If this can be done, could you please kindly advise the configuration changes required?
PS: Node1 and Node2 are on two separate application servers hosted on the same data centre.