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

Last updated on MARCH 13, 2023

Applies to:

Symptoms

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.id, 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 PubSession.id=PubContext.cs_sessionid AND PubContext.cs_target=PubTarget.id 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(BaseTable.java:298)
...

Changes

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

Cause

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