Unable to Delete Pages With SubPages in WebCenter Portal Installed with SQL Server
Last updated on JULY 12, 2017
Applies to:Oracle WebCenter Portal - Version 18.104.22.168.0 to 22.214.171.124.0
Information in this document applies to any platform.
This is only applicable to 12.2.1* release. For 12.2.2 onwards (once fix for bug 21835983 is merged), this workaround isn't required.
Unable to delete Pages with SubPages in WebCenter Portal installed with SQL Server. When attempting to delete a Page, the following error is shown in the managed server Logs:
Caused by: java.sql.SQLIntegrityConstraintViolationException: [FMWGEN][SQLServer JDBC Driver][SQLServer] The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "WC_PORTAL_ENTITY_SEC_ENTITY". The conflict occurred in database "certdb", table "MSSQLCERT_WEBCENTER.WC_PORTAL_ENTITY", column 'SECURITY_ENTITY_ID'.
In the user interface (UI0, the page still exists.
The issue can be reproduced with the following steps:
- Create a portal.
- Create a page with multiple level sub pages (i.e. 3 levels).
- Publish all the pages.
- Delete the parent page.
- View Portal.
You will notice that the page disappears from Pages when it is deleted.
But the page still shows in the portal.
If you go back to Portal editor you can still see the pages that were deleted.
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