Unable to delete any asset, error received "Unexpected Identifier"

(Doc ID 2014939.1)

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

When trying to delete any content asset, the following error message is received: "Unexpected Identifier"

Error in sites.log is:

[2015-05-22 07:26:39,433 UTC] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] Failed to execute query SELECT DISTINCT ownerid FROM MyAssetType_RMap WHERE assettype='Page' AND assetid=1381996799645 for query 1432257186350
[2015-05-22 07:26:39,434 UTC] [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)
at com.openmarket.gator.common.BaseFlexManager.listAssetReferers(BaseFlexManager.java:2492)
at com.openmarket.assetframework.complexasset.ComplexAsset.listReferrers(ComplexAsset.java:1402)
...

 

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