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 11.1.1.8.0 and later
Information in this document applies to any platform.

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

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