Forms BIP Integration Output .pdf File Failing With HTTP 404 On An HA Active Cluster (Doc ID 2927238.1)

Last updated on AUGUST 10, 2023

Applies to:

Symptoms

Forms 12.2.1.4 BIP integration output .pdf file failing with HTTP 404 on an HA active/active cluster

404 Not Found

A forms application (12.2.1.4) runs some BI Publisher (12.2.1.3) reports and then redirects the user browser to an URL that points to the resulting .pdf file.

On a form, using some logic that does the following: runs a report (via BI Publisher 12.2.1.3) and after the report executes with success then the logic in the form is redirecting the user browser to a new browser tab/window into a URL that opens the correspondent .pdf file (that was generated by BIP during the forms to BIP report execution request). In some cases the request to access the .pdf file that was generated and stored in the filesystem works, however, sometimes the access fails and is recorded by OHS as a 404 resulting request.
- Using Run_Report_Object() to run the report and then using web.show_document() to deliver the .pdf file to the user.
- The report runs fine and actually creates the corresponding .pdf file on the filesystem. What they see is that, for example, the .pdf file is created on "node 1" but the Load Balancer request goes to "node 2" or vice-versa.
- The issue happens only on a two node "HA cluster".
- URL used to access the form:
https://<server>/forms/frmservlet?config=<configname>

Business-user forms application access request flow:
----------------------------------------------------------
Client -> Load Balancer VIP (ssl/<port>)-> OHS(<port>,http) -> WLS_FORMS managed server (<port>, http)
Load Balancer VIP (ssl/<port>) : <server>

WLS_FORMS to BIP report execution request:
-----------------------------------------------
WLS_FORMS node -> Load Balancer VIP2 (http/<port>)-> OHS(<port>,http) -> BIP managed server (<port>, http)
Load Balancer VIP2 (http/<port>): <server>
FORMS_BI_SERVER (environment variable on pmsprd.env which is used as envfile in config=<configname>) is set as: http://<server>:<port>

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.