Error 'java.lang.reflect UndeclaredThrowableException' or 'The DELETE Statement Conflicted With the REFERENCE Constraint "fk_filtprop_rpt"' When Attempting to Delete a Project
(Doc ID 2201290.1)
Last updated on MARCH 22, 2022
Applies to:
Primavera P6 Enterprise Project Portfolio Management - Version 8.4.10.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to delete a project, the following error occurs:
P6 Web application error:
java.lang.reflect UndeclaredThrowableException
Error in the P6WebAccess.html log file:
com.primavera.bo.remoting.RemoteDataException: Failed saving EPS/Project data.
at com.primavera.guisupport.projects.data.ProjectsDataSaver.saveStore(Unknown Source)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint "fk_filtprop_rpt".The conflict occurred in database "$DBNAME", table "dbo.FILTPROP", column 'rpt_id'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
P6 Professional application error:
PRM DBAccess Error: SQL State: 1, SQL Error Code: 3621, Level: 0, Procedure: , Line: 1
The statement has been terminated.
SQL State: 1, SQL Error Code: 547, Level: 16, Procedure: , Line: 1
The DELETE statement conflicted with the REFERENCE constraint "fk_filtprop_rpt". The conflict occurred in database "$DBNAME", table "dbo.FILTPROP", column 'rpt_id'.
The issue can be reproduced at will with the following steps:
- Login to P6 or P6 Professional.
- Delete a specific project.
Changes
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 |
Changes |
Cause |
Solution |
References |