Scheduled BI Publisher Report Or Sending A Bi Publisher Report Through Email Stays In A Running Status (In BI Publisher Job History) And Logs The Following Warning When Running Bi Publisher In A Clustered Environment: "java.io.FileNotFoundException" (Doc ID 1574866.1)

Last updated on JULY 17, 2023

Applies to:

Symptoms

Using Primavera P6 Enterprise Project Portfolio Management (P6 EPPM r8.2), configured to use BI Publisher for Reporting:

ACTUAL BEHAVIOR
------------------------
When Bi Publisher is configured in a cluster environment (bi publisher installed to multiple nodes), and using either P6 to schedule a report through email, or scheduling a report to run as Email in Bi Publisher directly, the application will allow the reports to be scheduled and configure to distribute via email, but the email never arrives. If reviewing the Job History for the scheduled report in BI Publisher, it sits in a 'Running' status but never completes.

In the bipublisher.log file (located $MiddlewareHome\user_projects\domains\$BIPublisher_Domain\servers\$BIPublisher_ServerName\logs\bipublisher\bipublisher.log), the following warnings are thrown:

• [TIMESTAMP] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 31] [userId: ADBISystemUser] [ecid: c32e845ce5adb7d4:2c42d32c:14012ed2bb6:-8000-000000000000011f,1:22473] [APP: bipublisher#11.1.1] !!!!!!! BurstingReportProcessor.renderReport :: /tmp/bip1237284887606648409.tmp (No such file or directory)::java.io.FileNotFoundException: /tmp/bip1237284887606648409.tmp (No such file or directory)[[
• [TIMESTAMP] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 31] [userId: ADBISystemUser] [ecid: c32e845ce5adb7d4:2c42d32c:14012ed2bb6:-8000-000000000000011f,1:22473] [APP: bipublisher#11.1.1] !!!!!!! ProcessorUtil.postDataAction :: Exception happens:[INSTANCE_JOB_ID=1554][JOB_ID=1554]OUTPUT_ID=1651]document counter file is not found or empty./tmp/bip4672099909599122006.tmpjava.lang.Exception: document counter file is not found or empty./tmp/bip4672099909599122006.tmp[

EXPECTED BEHAVIOR
------------------------
When scheduling a report to run and send via Email, either from P6 (reports tab) or BI Publisher directly, for the report to send via E-Mail successfully.

Cause

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