Asset API Insert from CSElement Works from ContentServer but Not from Remote Satellite Server

(Doc ID 1943641.1)

Last updated on JULY 07, 2017

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.


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