Event Code Error: "CVRJC-####-#, Message: TCCustomVirtualRow.getJoinedColItems: PROJPCAT row has blank proj_catg_type_id" When Importing XER File (Doc ID 902570.1)

Symptoms

When importing an XER file into Project Management, the following error occurs:

• Event Code:  CVRJC-####-#
• Message:  TCCustomVirtualRow.getJoinedColItems: PROJPCAT row has blank proj_catg_type_id
• Event Code:    PRMDB-3013-C
  Message:      
   PRM DBAccess Error: SQL State: 1, SQL Error Code: 3621,
   Level: 0, Procedure: , Line: 1
   The statement has been terminated.
   SQL State: 2, SQL Error Code: 515, Level: 16, Procedure: ,
   Line: 1
   Cannot insert the value NULL into column
   'proj_catg_short_len', table 'PMDB.dbo.PCATTYPE'; column
   does not allow nulls. INSERT fails.
• AVAA0-0266-C
  Access violation at address 000000000040EF1F in module 'PM.exe'. Read of address 00000000000001A0
• PRMDB-1467-6
  PRM DBAccess Error: SQL State: 1, SQL Error Code: 3621, Level: 0, Procedure: , Line: 1
  The statement has been terminated.
  SQL State: 1, SQL Error Code: 547, Level: 16, Procedure: , Line: 1
  The INSERT statement conflicted with the FOREIGN KEY constraint "fk_pcatval_pcattype". The conflict occurred in database
  "SQL1627", table "dbo.PCATTYPE", column 'proj_catg_type_id'.

Changes

Cause

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