My Oracle Support Banner

Asset API Insert from CSElement Works from ContentServer but Not from Remote Satellite Server (Doc ID 1943641.1)

Last updated on MAY 19, 2021

Applies to:

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


Calling AssetDataManager.insert() in a CSElement works when called directly from the ContentServer servlet, but not when called from Remote Satellite Server.

The error on WebCenter Sites in the sites.log, when called through Remote Satellite Server, is:
[2014-11-11 08:10:02,340] [ERROR] [[ACTIVE] ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] | Failed to execute query SELECT, PubSession.cs_sessiontype, PubSession.cs_status, PubSession.cs_sessionuser,PubSession.cs_sessiondate, PubSession.cs_enddate,PubSession.cs_msgcount,PubContext.cs_target,PubContext.cs_sessionid, PubContext.cs_factors FROM PubSession, PubContext, PubTarget WHERE PubSession.cs_sessiontype='Publish' AND AND AND PubSession.cs_status IN ('R') ORDER BY PubSession.cs_sessiondate DESC for query 1415589821723
[2014-11-11 08:10:02,341] [ERROR] [[ACTIVE] ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self-tuning)'] [logging.cs.xcelerate.asset] | Error in Asset:CanEdit SQL statement failed -105:
com.openmarket.basic.interfaces.AssetException: SQL statement failed -105:
    at com.openmarket.basic.common.BaseTable.querySQL(


The CSElement uses SessionFactory.getSession() to get a session for the AssetDataManager.


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.