My Oracle Support Banner

Event Code PRMDB-1130-1 Error When Importing an XER in P6 Professional (Doc ID 2506387.1)

Last updated on OCTOBER 02, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 17.12.9.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to import a .XER file into a SQL Server database via P6 Professional, the following error occurs:

ERROR

Executable: PM.exe
Application: Primavera P6 Professional 17
Event Code: PRMDB-1130-1
Message:
PRM DBAccess Error: SQL State: 1, SQL Error Code: 3621,
Level: 0, Procedure: , Line: 28
The statement has been terminated.
SQL State: 14, SQL Error Code: 8152, Level: 16,
Procedure: , Line: 28
String or binary data would be truncated.

Context:
1: TfrmWizImport.wizImportFinish
2: TfrmWizImport.wizImportBeforeShowPage
3: TfrmWizImport.RunImportWizard
4: TDevxMainForm.actFileImportExecute
5: TCFormManager.SetToolbar
6: TDevxMainForm.BeforeFormShow
7: TfrmLogin.FormCreate
8:
9:
10:

Detail:
Type: EprmDBSQLExecutionFailure
Object Type: TCUltraButton

Database Error:
Error Code: 0

STEPS

The issue can be reproduced at will with the following steps:
   1.  Login to P6 Professional, connected to a SQL Server database.
   2.  Import .XER File.
   3.  Receive error.

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.