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
Last updated on SEPTEMBER 11, 2017
Applies to:Primavera P6 Professional Project Management - Version 126.96.36.199 and later
Primavera P6 Enterprise Project Portfolio Management - Version 188.8.131.52 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 184.108.40.206 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
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