'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 MAY 23, 2023
Applies to:Primavera P6 Professional Project Management - Version 22.214.171.124 and later
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:
- Import the XER file into a new empty standalone SQLite database.
- Rename the imported project to a new name.
- Import the same XER once again but change the Action for Resources from Keep Existing to Update Existing.
- 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!