Error: "ORA-22275 invalid lob locator specified" When Running Project Publication in P6 Using an Oracle Database (Doc ID 2062394.1)

Last updated on AUGUST 08, 2023

Applies to:

Symptoms

When attempting to publish projects, the publication job fails and the following error is noted in the publication log for the project:

ERROR
-----------------------
com.primavera.PhoenixException: ora-22275 invalid lob locator specified
  at com.primavera.px.writer.PxBusinessObjectSqlWriter.a(Unknown Source)
  at com.primavera.px.writer.PxBusinessObjectSqlWriter.updatePxBusinessObjects(Unknown Source)
  at com.primavera.px.common.PxServiceBoWriter.doWork(Unknown Source)
  at com.primavera.px.common.PxServiceBoTaskImpl$PxServiceBoTaskUnit.attemptToProcessForPageSize(Unknown Source)
  at com.primavera.px.common.PxServiceBoTaskImpl$PxServiceBoTaskUnit.execute(Unknown Source)
  at com.primavera.px.common.PxServiceBoTaskImpl.executeTask(Unknown Source)
  at com.primavera.px.common.PxAbstractServiceTask.execute(Unknown Source)
  at com.primavera.infr.threadpool.ThreadPoolImpl.run(Unknown Source)
  at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.BatchUpdateException: ora-22275 invalid lob locator specified

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

1. Install an Oracle 12c database (12.1.0.2)
2. Enable publication for all projects
3. Note the log error which occurs when a project publication runs

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.