My Oracle Support Banner

Error: "The delete statement conflicted with reference constraint "fk_rscrate_shiftper" the conflict occurred in database "xxxx", table "dbo.RSRCRATE"" When Attempting to Delete or Edit a Shift Calendar (Doc ID 2304216.1)

Last updated on DECEMBER 04, 2019

Applies to:

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

Symptoms

When attempting to delete or edit a Resource shift, the following errors occur:

ERRORS

1. Event Code: PRMDB-2281-8
    Message:  The DELETE statement conflicted with the REFERENCE constraint 'fk_rsrcrate_shiftper'. The conflict occurred in database 'xxxx', table 'DBO.rsrcrate', column 'shift_period_id'.

2. Event Code CVQII-2154-9
    Message:  TCCustomVirtualQueryItem.getItems: index -99 out of bounds.


STEPS

The issue can be reproduced at will with the following steps:
1. Attempt to delete or edit a Resource Shift in P6 Professional.
2. View first error, click OK
3. View second error

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


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