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 18.104.22.168 and later
Primavera P6 Enterprise Project Portfolio Management - Version 22.214.171.124 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 126.96.36.199 and later
Information in this document applies to any platform.
When attempting to delete or edit a Resource shift, the following errors occur:
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.
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
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