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

Last updated on MARCH 22, 2022

Applies to:

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

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