My Oracle Support Banner

Error "ORA-12899: Value Too Large For Column ADMUSER.UDF_TEXT" When Importing XER (Doc ID 2655172.1)

Last updated on MAY 12, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.3 to 18.8.17.0 [Release 8.3 to 18.8]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.3 to 18.8.17.0 [Release 8.3 to 18.8]
Primavera P6 Professional Project Management - Version 8.3 to 18.8.17.0 [Release 8.3 to 18.8]
Information in this document applies to any platform.

Symptoms

Problem Summary
---------------------------------------------------
XER Import Fails With: ORA-12899: Value Too Large For Column ADMUSER.UDF_TEXT

Problem Description
---------------------------------------------------
We export out .XER file. Attempts to import unaltered .XER back results in error:

TYPE: EprmDBSQLExecutionFailure
EVENT CODE: PRMDB-3103-1
DESCRIPTION: PRM DBAccess Error: ORA-12899: Value Too Large For Column ADMUSER.UDF_TEXT (actual: 256, maximum: 255).


Error Codes
---------------------------------------------------
PRMDB-3103-1; ORA-12899

 

REPRODUCE STEP
1. Add an Activity text UDF.
2. Export a project with the newly added UDF as XLSX.
3. Modify the XLSX in excel and input the UDF field with more than 255
characters and also include "line return".
4. Import the XLSX back to the original project. Then it would only retain  255 characters but remain the "line return".
5. Export the project as XER.
6. Import the XER to the same database and see the following error.

Changes

 

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
Changes
Cause
Solution
References


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