My Oracle Support Banner

Unable To Delete An Asset (Doc ID 2225510.1)

Last updated on DECEMBER 21, 2022

Applies to:

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


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 Type WHERE parentid=<pid> 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(


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

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