Unable To Delete An Asset (Doc ID 2225510.1)

Last updated on JULY 10, 2024

Applies to:

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

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