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 SEPTEMBER 11, 2017

Applies to:

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
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.4.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:

ERROR
-----------------------
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

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