My Oracle Support Banner

'Event Code PRMDB-4044-0' When Attempting to Import an XER File into P6 Professional Connected to a Standalone SQLite Database (Doc ID 2949267.1)

Last updated on DECEMBER 06, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 22.12 to 23.6 [Release 22.12 to 23.6]
Primavera P6 Enterprise Project Portfolio Management - Version to [Release 20.12 to 22.12]
Information in this document applies to any platform.


When attempting to import an XER project file in P6 Professional connected to a new empty standalone SQLite database, the following error occurs.

Event Code: PRMDB-4044-0
Message:   PRM DBAccess Error: SQLite-UNIQUE constraint failed:   UDFVALUE.UDF_TYPE_ID, UDFVALUE.FK_ID


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

  1. Import the XER file into a new empty standalone SQLite database.
  2. Rename the imported project to a new name.
  3. Import the same XER once again but change the Action for Resources from Keep Existing to Update Existing.
  4. The new import fails with the reported error.


To view full details, 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 a vibrant support community of peers and Oracle experts.