XER Import Fails With: ORA-12899: Value Too Large For Column "ADMUSER"."UDFTYPE"

(Doc ID 2320607.1)

Last updated on OCTOBER 31, 2017

Applies to:

Primavera P6 Professional Project Management - Version 7.0 SP1 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
Attempting to import one XER file in P6 Professional fails with the following error:


ERROR
Exception: EprmDBSQLExecutionFailure
Event Code: PRMDB-0114-4
Description: PRM DBAccess Error: Database Server Error: ORA-12899: Value too large for column "ADMUSER"."UDFTYPE"."UDF_TYPE_LABEL" (actual: 43, maximum: 40)


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

1. Login using P6 Professional.
2. File - Import - Primavera XER.


BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot import the XER file.

 

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