Unable To Delete An Asset (Doc ID 2225510.1)

Last updated on SEPTEMBER 18, 2017

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

Unable to delete asset from Automotive site after applying Patch 15, , delete fails and the logs reference to Suppliers site.

When attempting to delete any asset , it is throwing this error in the sites.log:

[2017-01-17 14:21:18,714 EST] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] Failed to execute query SELECT childid AS assetid,childtype AS assettype FROM Suppliers_SiteConfig_P_Group WHERE parentid=1384973789425 AND primarycount>0 for query 1484670523403
[2017-01-17 14:21:18,715 EST] [ERROR] [.kernel.Default (self-tuning)'] [logging.cs.xcelerate.asset] Error in ComplexAsset: SQL statement failed -105:
com.openmarket.basic.interfaces.AssetException: SQL statement failed -105:
  at com.openmarket.basic.common.BaseTable.querySQL(BaseTable.java:298)

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