During XER Import Event Code: PRMDB-0798-A (or PRMDB-1768-7) ORA-12899: Value Too Large for Column "ADMUSER"."RISKTYPE"."RISK_TYPE" (Actual: 47, Maximum: 40).

(Doc ID 2346935.1)

Last updated on MARCH 07, 2018

Applies to:

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

Symptoms

During XER Import in P6 Professional client an Event Code occurs:

PRMDB-0798-A, PRM DBAccess Error: ORA-12899: value too large for column "ADMUSER"."RISKTYPE"."RISK_TYPE" (actual: 47, maximum: 40)


ERROR
-----------------------
PRMDB-0798-A
PRM DBAccess Error: ORA-12899: value too large for column "ADMUSER"."RISKTYPE"."RISK_TYPE" (actual: 47, maximum: 40)

PRMDB-1768-7
PRM DBAccess Error: ORA-12899: value too large for column "ADMPEDTS_PMDB".RISKTYPE"."RISK_TYPE" (actual: 42, maximum: 40)

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

  1. Log into P6 Professional Client.
  2. Import XER file.
  3. Result: Error - Event Code: PRMDB-0798-A or PRMDB-1768-7.

*****************************************************
*                EXCEPTION  REPORT                  *
*****************************************************
Date:          08-Jan-18 15:14

Executable:    PM.exe
Application:   Primavera P6 Professional 17
Event Code:    PRMDB-0798-A
Message:       
  PRM DBAccess Error: ORA-12899: value too large for
  column "ADMUSER"."RISKTYPE"."RISK_TYPE" (actual: 47,
  maximum: 40)


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

Changes

 

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