My Oracle Support Banner

Error: "TCVirtualTable.FindRowNewIndex: Adding row (TASK - Activity) conflicts with existing unique key" When Attempting to Import XLSX (Doc ID 2950771.1)

Last updated on MAY 23, 2023

Applies to:

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


When attempting to import an XLSX file to P6 professional connected to an Oracle database,
the following error occurs.

TCVirtualTable.FindRowNewIndex: Adding row (TASK - Activity) conflicts with existing unique key."

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

  1. In P6 Professional, navigate to File --> Import.
  2. Select "XLSX".
  3. Navigate to XLSX file to import.


To view full details, 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 a vibrant support community of peers and Oracle experts.