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:
Oracle WebCenter Sites - Version 11.1.1.8.0 and laterInformation 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
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
Symptoms |
Changes |
Cause |
Solution |