Sending Summary Sheet From P6 to Unifier Creates Head Blocker in SQL Server Database and Blocks Other Jobs
Last updated on JUNE 05, 2018
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 184.108.40.206 to 220.127.116.11 [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 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)
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.
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