Access Exception While Calling Cs Element But When Log In Working Properly
(Doc ID 2944488.1)
Last updated on NOVEMBER 18, 2024
Applies to:
Oracle WebCenter Sites - Version 12.2.1.4.0 and laterInformation in this document applies to any platform.
Symptoms
When loading a certain link in the browser an error "Unable to connect" appears while calling a cs element without logging in, due to lack of permissions for the cs element map assets. The following errors can also be seen in the logs:
[2023-02-21T17:56:04.322+00:00] [wcsites_server1] [ERROR] [] [oracle.wcsites.db] [tid: 129] [userId: ] [ecid: <ecid>] [APP: sites] [partition-name: DOMAIN] [tenant-name: GLOBAL] no privilege from accEngine to execute sql:SELECT * FROM ElementCatalog WHERE elementname='/Common/SetPreviewParameters'
[2023-02-21T17:56:04.323+00:00] [wcsites_server1] [ERROR] [] [oracle.wcsites.db] [tid: 129] [userId: ] [ecid:<ecid>] [APP: sites] [partition-name: DOMAIN] [tenant-name: GLOBAL] Failed to execute query SELECT * FROM ElementCatalog WHERE elementname='/Common/SetPreviewParameters' for query 1677000417499
[2023-02-21T17:56:04.325+00:00] [wcsites_server1] [ERROR] [] [oracle.wcsites.xcelerate.asset] [tid: 129] [userId: ] [ecid: <ecid>] [APP: sites] [partition-name: DOMAIN] [tenant-name: GLOBAL] Error in ComplexAsset: SQL statement failed -105:[[
com.openmarket.basic.interfaces.AssetException: SQL statement failed -105:
at com.openmarket.basic.common.BaseTable.querySQL(BaseTable.java:309)
at com.openmarket.basic.common.BaseTable.querySQL(BaseTable.java:279)
at com.openmarket.xcelerate.common.ElementCatalogTable.getEntry(ElementCatalogTable.java:43)
at com.openmarket.xcelerate.common.ElementCatalogTable.getEntry(ElementCatalogTable.java:32)
at com.openmarket.xcelerate.asset.CSElementManager.readlocaldata(CSElementManager.java:285)
at com.openmarket.xcelerate.asset.CSElementManager.read(CSElementManager.java:240)
at com.openmarket.assetframework.complexasset.ComplexAsset.Read(ComplexAsset.java:1100)
at com.openmarket.xcelerate.asset.Asset.Load(Asset.java:2539)
at com.openmarket.xcelerate.asset.Asset.LoadAll(Asset.java:3038)
at com.fatwire.assetapi.data.AbstractSpecialAssetReadStrategy.read(AbstractSpecialAssetReadStrategy.java:69)
at com.fatwire.assetapi.data.CSElementReadStrategy.read(CSElementReadStrategy.java:30)
at com.fatwire.assetapi.data.AssetDataManagerImpl.read(AssetDataManagerImpl.java:88)
at com.fatwire.assetapi.data.AssetDataManager$read.call(Unknown Source)
at oracle.webcenter.sites.B.BWrapperController.checkIsMultilingualSite(BWrapperController:550)
at oracle.webcenter.sites.B.BWrapperController$checkIsMultilingualSite$0.callCurrent(Unknown Source)
at oracle.webcenter.sites.B.BWrapperController.doWork(BWrapperController:135)
at com.fatwire.assetapi.data.BaseController.handleRequest(BaseController.java:408)
at COM.FutureTense.Common.ControllerProcessorImpl._evaluate(ControllerProcessorImpl.java:342)
at COM.FutureTense.Common.ControllerProcessorImpl.evaluate(ControllerProcessorImpl.java:152)
at COM.FutureTense.Common.ContentServer.evalController(ContentServer.java:4061)
at COM.FutureTense.Common.ContentServer.processController(ContentServer.java:1560)
at COM.FutureTense.Common.ContentServer.evalPage(ContentServer.java:1382)
at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:533)
at COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3970)
at COM.FutureTense.Common.CS.getPage(CS.java:1366)
at COM.FutureTense.Common.CS.ReadPage(CS.java:1312)
at com.openmarket.Satellite.CoResidentContentServerEh._handlePage(CoResidentContentServerEh.java:223)
[2023-02-21T17:56:04.323+00:00] [wcsites_server1] [ERROR] [] [oracle.wcsites.db] [tid: 129] [userId: ] [ecid:<ecid>] [APP: sites] [partition-name: DOMAIN] [tenant-name: GLOBAL] Failed to execute query SELECT * FROM ElementCatalog WHERE elementname='/Common/SetPreviewParameters' for query 1677000417499
[2023-02-21T17:56:04.325+00:00] [wcsites_server1] [ERROR] [] [oracle.wcsites.xcelerate.asset] [tid: 129] [userId: ] [ecid: <ecid>] [APP: sites] [partition-name: DOMAIN] [tenant-name: GLOBAL] Error in ComplexAsset: SQL statement failed -105:[[
com.openmarket.basic.interfaces.AssetException: SQL statement failed -105:
at com.openmarket.basic.common.BaseTable.querySQL(BaseTable.java:309)
at com.openmarket.basic.common.BaseTable.querySQL(BaseTable.java:279)
at com.openmarket.xcelerate.common.ElementCatalogTable.getEntry(ElementCatalogTable.java:43)
at com.openmarket.xcelerate.common.ElementCatalogTable.getEntry(ElementCatalogTable.java:32)
at com.openmarket.xcelerate.asset.CSElementManager.readlocaldata(CSElementManager.java:285)
at com.openmarket.xcelerate.asset.CSElementManager.read(CSElementManager.java:240)
at com.openmarket.assetframework.complexasset.ComplexAsset.Read(ComplexAsset.java:1100)
at com.openmarket.xcelerate.asset.Asset.Load(Asset.java:2539)
at com.openmarket.xcelerate.asset.Asset.LoadAll(Asset.java:3038)
at com.fatwire.assetapi.data.AbstractSpecialAssetReadStrategy.read(AbstractSpecialAssetReadStrategy.java:69)
at com.fatwire.assetapi.data.CSElementReadStrategy.read(CSElementReadStrategy.java:30)
at com.fatwire.assetapi.data.AssetDataManagerImpl.read(AssetDataManagerImpl.java:88)
at com.fatwire.assetapi.data.AssetDataManager$read.call(Unknown Source)
at oracle.webcenter.sites.B.BWrapperController.checkIsMultilingualSite(BWrapperController:550)
at oracle.webcenter.sites.B.BWrapperController$checkIsMultilingualSite$0.callCurrent(Unknown Source)
at oracle.webcenter.sites.B.BWrapperController.doWork(BWrapperController:135)
at com.fatwire.assetapi.data.BaseController.handleRequest(BaseController.java:408)
at COM.FutureTense.Common.ControllerProcessorImpl._evaluate(ControllerProcessorImpl.java:342)
at COM.FutureTense.Common.ControllerProcessorImpl.evaluate(ControllerProcessorImpl.java:152)
at COM.FutureTense.Common.ContentServer.evalController(ContentServer.java:4061)
at COM.FutureTense.Common.ContentServer.processController(ContentServer.java:1560)
at COM.FutureTense.Common.ContentServer.evalPage(ContentServer.java:1382)
at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:533)
at COM.FutureTense.Common.ContentServer.runManager(ContentServer.java:3970)
at COM.FutureTense.Common.CS.getPage(CS.java:1366)
at COM.FutureTense.Common.CS.ReadPage(CS.java:1312)
at com.openmarket.Satellite.CoResidentContentServerEh._handlePage(CoResidentContentServerEh.java:223)
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 |
| Cause |
| Solution |
| References |