My Oracle Support Banner

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

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
Symptoms
Cause
Solution


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