Delete Asset Functionality Not Working Providing Error. (Doc ID 1573676.1)

Last updated on DECEMBER 30, 2015

Applies to:

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

Symptoms

Deleting an asset is throwing an error such as below to the logs

<!--FTCS|||result=failure|||reason=Unable to locate catalog information TelProduct_C_RMap|||err=-103|||command=SQL|||params=|||-->
[2013-07-03 13:55:32,777] [DEBUG] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db]
<!--FTCS|||result=failure|||reason=Unable to locate catalog information TelProduct_C_RMap|||err=-103|||command=SQL|||params=|||-->
[2013-07-03 13:55:32,777] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] Failed to execute query SELECT DISTINCT ownerid FROM TelProduct_C_RMap WHERE assettype='Telkom_Media_C' AND assetid=1369389880109 for query 1371208603554
[2013-07-03 13:55:32,780] [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)
       at com.openmarket.basic.common.BaseTable.querySQL(BaseTable.java:268)
       at com.openmarket.gator.common.RelationshipMap.addAssetRef(RelationshipMap.java:347)

Following is observed in the browser window where the asset is deleted

Unable to locate catalog information {assettype}

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