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"
Last updated on DECEMBER 28, 2017
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 8.2 1.0 and later
Information in this document applies to any platform.
Using Primavera P6 Enterprise Project Portfolio Management (P6 EPPM r8.2), configured to use BI Publisher for Reporting:
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[
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)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms