My Oracle Support Banner

Projects Failing Publication with the Following Error: SEVERE: datetime::[TASK]:[PxServiceActivityBoWriter]: [22] CORE(BRE): Overflow (Doc ID 2646446.1)

Last updated on MARCH 16, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 18.8 to 18.8.17.0 [Release 18.8]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.8 to 18.8.17.0 [Release 18.8]
Information in this document applies to any platform.

Symptoms

When attempting to publish particular projects,
the following error occurs.

ERROR
-----------------------
SEVERE: 2020-01-27 15:01:16:[TASK]:[PxServiceActivityBoWriter]: [22] CORE(BRE): Overflow
com.primavera.PhoenixException: Overflow
at com.primavera.px.writer.sql.PxActivitySpreadSqlProvider.addBusinessObjectToBatch(PxActivitySpreadSqlProvider.java:139)
at com.primavera.px.writer.PxBusinessObjectSqlWriter.a(PxBusinessObjectSqlWriter.java:64)
at com.primavera.px.writer.PxBusinessObjectSqlWriter.createPxBusinessObjects(PxBusinessObjectSqlWriter.java:32)
at com.primavera.px.common.PxServiceBoWriter.a(PxServiceBoWriter.java:99)
at com.primavera.px.writer.PxServiceActivityBoWriter.b(PxServiceActivityBoWriter.java:166)
at com.primavera.px.writer.PxServiceActivityBoWriter.doWork(PxServiceActivityBoWriter.java:80)
at com.primavera.px.common.PxServiceBoTaskImpl$PxServiceBoTaskUnit.attemptToProcessForPageSize(PxServiceBoTaskImpl.java:387)
at com.primavera.px.common.PxServiceBoTaskImpl$PxServiceBoTaskUnit.execute(PxServiceBoTaskImpl.java:285)
at com.primavera.px.common.PxServiceBoTaskImpl.c(PxServiceBoTaskImpl.java:227)
at com.primavera.px.common.PxServiceBoTaskImpl.a(PxServiceBoTaskImpl.java:181)
at com.primavera.px.common.PxServiceBoTaskImpl.executeTask(PxServiceBoTaskImpl.java:147)
at com.primavera.px.common.PxAbstractServiceTask.execute(PxAbstractServiceTask.java:110)
at com.primavera.px.common.PxAbstractServiceTask.execute(PxAbstractServiceTask.java:28)
at com.primavera.infr.threadpool.ThreadPoolImpl.run(ThreadPoolImpl.java:343)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.IllegalArgumentException: Overflow
at oracle.jdbc.driver.OraclePreparedStatement.setDoubleInternal(OraclePreparedStatement.java:6607)
at oracle.jdbc.driver.OraclePreparedStatement.setDouble(OraclePreparedStatement.java:6574)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.setDouble(OraclePreparedStatementWrapper.java:193)
at com.primavera.infr.db.PPreparedStatement.setDouble(PPreparedStatement.java:404)
at com.primavera.px.writer.PxBusinessObjectBase.a(PxBusinessObjectBase.java:50)
at com.primavera.px.writer.sql.PxActivitySpreadSqlProvider.addBusinessObjectToBatch(PxActivitySpreadSqlProvider.java:103)
... 14 more
Original Exception:
java.lang.IllegalArgumentException: Overflow
at oracle.jdbc.driver.OraclePreparedStatement.setDoubleInternal(OraclePreparedStatement.java:6607)
at oracle.jdbc.driver.OraclePreparedStatement.setDouble(OraclePreparedStatement.java:6574)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.setDouble(OraclePreparedStatementWrapper.java:193)
at com.primavera.infr.db.PPreparedStatement.setDouble(PPreparedStatement.java:404)
at com.primavera.px.writer.PxBusinessObjectBase.a(PxBusinessObjectBase.java:50)
at com.primavera.px.writer.sql.PxActivitySpreadSqlProvider.addBusinessObjectToBatch(PxActivitySpreadSqlProvider.java:103)
at com.primavera.px.writer.PxBusinessObjectSqlWriter.a(PxBusinessObjectSqlWriter.java:64)
at com.primavera.px.writer.PxBusinessObjectSqlWriter.createPxBusinessObjects(PxBusinessObjectSqlWriter.java:32)
at com.primavera.px.common.PxServiceBoWriter.a(PxServiceBoWriter.java:99)
at com.primavera.px.writer.PxServiceActivityBoWriter.b(PxServiceActivityBoWriter.java:166)
at com.primavera.px.writer.PxServiceActivityBoWriter.doWork(PxServiceActivityBoWriter.java:80)
at com.primavera.px.common.PxServiceBoTaskImpl$PxServiceBoTaskUnit.attemptToProcessForPageSize(PxServiceBoTaskImpl.java:387)
at com.primavera.px.common.PxServiceBoTaskImpl$PxServiceBoTaskUnit.execute(PxServiceBoTaskImpl.java:285)
at com.primavera.px.common.PxServiceBoTaskImpl.c(PxServiceBoTaskImpl.java:227)
at com.primavera.px.common.PxServiceBoTaskImpl.a(PxServiceBoTaskImpl.java:181)
at com.primavera.px.common.PxServiceBoTaskImpl.executeTask(PxServiceBoTaskImpl.java:147)
at com.primavera.px.common.PxAbstractServiceTask.execute(PxAbstractServiceTask.java:110)
at com.primavera.px.common.PxAbstractServiceTask.execute(PxAbstractServiceTask.java:28)
at com.primavera.infr.threadpool.ThreadPoolImpl.run(ThreadPoolImpl.java:343)
at java.lang.Thread.run(Thread.java:748)
2020-01-27 15:01:17:[TASK]:[Activity]: [22] CORE(BRE): Task completed[2020-01-27 15:01:17]


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Either allow the project to be queued for publication according to the Project Publication settings or manually publish.
2.  Take note of the error in the publication log.

Changes

 

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
Changes
Cause
Solution
References


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