Sending Summary Sheet From P6 to Unifier Creates Head Blocker in SQL Server Database and Blocks Other Jobs

(Doc ID 2404869.1)

Last updated on JUNE 05, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 to 15.1.6.14 [Release 15.1]
Information in this document applies to any platform.

Symptoms

When attempting to send project data from P6 to Unifier, using Gateway, the job fails and a head blocker is created in the P6 database. Due to the head blocker, all other scheduled gateway jobs are placed on hold and do not process. Once the head blocker is removed, other jobs are allowed to continue running.

P6WebAccess.html log shows below error:
java.lang.IllegalArgumentException: Invalid field checkboxcolumn for Projwbs
at com.primavera.bo.defs.StaticBusinessObjectDef.getFieldId(Unknown Source)
at com.primavera.bo.defs.DynamicBusinessObjectDef.getFieldId(Unknown Source)
at com.primavera.bo.defs.DynamicBusinessObjectDef.getFieldType(Unknown Source)

STEPS

The issue can be reproduced at will with the following steps:
1. Open a project via P6.
2. Summarize the project.
3. Click exchange data --> send to Unifier
4. In the pop up window, select the summary sheet option.
5. Click send.
6. Within a minute, observe the error reported in the P6 web access log.
7. Observe nothing happens in terms of process, but the head blocker is created in database.

BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, users cannot complete the P6 to Unifier synchronization successfully.

Cause

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