My Oracle Support Banner

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 FEBRUARY 03, 2019

Applies to:

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


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 Source)
at Source)
at Source)


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.


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


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

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