My Oracle Support Banner

Unable To Delete An Asset (Doc ID 2225510.1)

Last updated on JULY 10, 2024

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 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(BaseTable.java:298)

Cause

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
Symptoms
Cause
Solution
References


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