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 OCTOBER 07, 2020

Applies to:

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:

1. Login to P6 or P6 Professional.
2. Delete a specific project.

Changes

Cause

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