Unable to Delete Pages With SubPages in WebCenter Portal Installed with SQL Server
(Doc ID 2061433.1)
Last updated on DECEMBER 14, 2020
Applies to:Oracle WebCenter Portal - Version 220.127.116.11.0 to 18.104.22.168.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 "<DATABASE-NAME>", table "<TABLE>", column <COLUMN>.
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.
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