Error: PRMDB-0581-F and Slow Performance When Importing an XER File (Doc ID 2130932.1)

Last updated on JULY 15, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 15.2.4.0 to 15.2.7.0 [Release 15.2]
Primavera P6 Enterprise Project Portfolio Management - Version 15.2.4.0 to 15.2.7.0 [Release 15.2]
Information in this document applies to any platform.

Symptoms

When attempting to import a project into P6 Professional over P6 Pro Cloud Connect there is a long delay, in some cases up to 20 or 30 minutes or more, followed by the error:

*****************************************************
* EXCEPTION REPORT *
*****************************************************
Date: 16-Mar-16 11:47 AM

Executable: PM.exe
Application: Primavera P6 Professional R15.2
Event Code: PRMDB-0581-F
Message:
PRM DBAccess Error: Error executing query. Error: String
index out of range: 3124

Session undefined
Request type: EXECUTE_SQL
Command text: Not set
Block count: 0
Total data size: 0 bytes (before compression)
Total job time spent to push in the queue: 0 ms
Total job time: 0 ms (not including compression)

Context:
1: TfrmWizImport.wizImportFinish
2: TfrmWizImport.wizImportBeforeShowPage
3: TfrmWizImport.RunImportWizard
4: TDevxMainForm.actFileImportExecute
5: TfrmEPS.mnuOpenProjectClick
6: TDevxMainForm.actFileImportExecute
7: TDevxMainForm.BeforeFormShow
8:
9:
10:

Detail:
Type: EprmDBSQLExecutionFailure
Object Type: TCUltraButton

Database Error:
Error Code: 0

 

Cause

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