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:
Primavera P6 Enterprise Project Portfolio Management - Version 8.2 1.0 and laterInformation in this document applies to any platform.
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.
BI Publisher was configured for Email per the documentation under: How To Enable E-mail Delivery for Reports Configured With BI Publisher In P6 (all r8.x versions) (Doc ID 1304276.1)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |