XER Import Fails With: ORA-12899: Value Too Large For Column "ADMUSER"."UDFTYPE"
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.
Attempting to import one XER file in P6 Professional fails with the following error:
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)
The issue can be reproduced at will with the following steps:
1. Login using P6 Professional.
2. File - Import - Primavera XER.
The issue has the following business impact:
Due to this issue, users cannot import the XER file.
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