Error "ORA-01461: can bind a LONG value only for insert into a LONG column" Syncing Data From P6 to Unifier Including WBS Hierachy Data (Doc ID 2063423.1)

Last updated on APRIL 19, 2017

Applies to:

Primavera Gateway - Version 15.1.0.0 to 15.1.0.0 [Release 15.1]
Information in this document applies to any platform.

Symptoms

When attempting to execute the "Send to Primavera Unifier" synchronization in Gateway to import data from P6 to Unifier the job fails on the Update Destination step with the following error.

java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column

Removing the option the Send WBS Hierachy from synchronization resolves issue.

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