My Oracle Support Banner

BI Publisher Reports Get Stuck in 'Running' Status When Run from P6 (Doc ID 2530088.1)

Last updated on DECEMBER 05, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.0.0 to 16.2.17.2 [Release 16.2]
Information in this document applies to any platform.

Symptoms

Multiple reports get stuck in Status 'Running' when run from P6, and the following errors can be found in the bipublisher.log file:

[<SERVER>] [ERROR] [] [oracle.xdo] [tid: 282] [userId: <USER>] [ecid: 6b0d6f07-a1ce-4e19-a30c-2d303530cece-0000000a,0:2473:24:1] [APP: bipublisher] [partition-name: <partition-name>] [tenant-name: <tenant-name>] [xdojobid: XXX] [essjobid: null] Data size (101954013) exceeds the limit (52428800) under free memory(252448432)


[<SERVER>] [ERROR] [] [oracle.xdo] [tid: 282] [userId: <USER>] [ecid: 6b0d6f07-a1ce-4e19-a30c-2d303530cece-0000000a,0:2473:24:1] [APP: bipublisher] [partition-name: <partition-name>] [tenant-name: <tenant-name>] [xdojobid: XXXX] [essjobid: null] Report data size (101954013 bytes) exceeds the maximum limit (52428800 bytes) under the free memory threshold (524288000 bytes). Stopped processing.

The same reports run fine when executed from BI Publisher directly.
Every now and then, they also run successfully from P6.

 

The issue can be reproduced at will with the following steps:

  1. Run a BI Publisher report from P6.
  2. Observe the reported behavior/errors.

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!


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