My Oracle Support Banner

P6 Professional Hangs During XER Project Import When Connected to a SQL Server Database and Critical Error Occurs "String or Binary Data Would Be Truncated" (Doc ID 3007482.1)

Last updated on APRIL 05, 2024

Applies to:

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

Symptoms

When attempting to import an XER Project in P6 Professional connected to a SQL Server database, the process hangs and the Critical Error below occurs. After logging back into P6 Professional, the project displays as added but has 0 Total Activities.

 

ERROR

PRMDB-1742-E , PRM DBAccess Error: SQL State: 1, SQL Error Code: 3621
String or binary data would be truncated.

 

STEPS

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

  1. Using P6 Professional client.
  2. Login connected to a SQL Server database.
  3. Import customer XER project file.
  4. Result: P6 hangs with Event Code error.
  5. Next, re-login to P6 Professional.
  6. Result: the XER project is added with 0 Total Activities.

 

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
References


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