Unable to Delete Pages With SubPages in WebCenter Portal Installed with SQL Server (Doc ID 2061433.1)

Last updated on JULY 12, 2017

Applies to:

Oracle WebCenter Portal - Version 12.2.1.0.0 to 12.2.1.0.0
Information in this document applies to any platform.

Symptoms

 

NOTE:
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:

oracle.webcenter.portal.transaction.TransactionException: An error occurred executing a transactional method.
at oracle.webcenter.portal.persistence.transaction.TransactionManagerImpl.execute(TransactionManagerImpl.java:295)
...

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.

 

STEPS

The issue can be reproduced with the following steps:

  1. Create a portal.

  2. Create a page with multiple level sub pages (i.e. 3 levels).

  3. Publish all the pages.

  4. Delete the parent page.

  5. 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.

 

Cause

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