vdm:setalias Not Working With Microsoft SQL Server
(Doc ID 2341198.1)
Last updated on APRIL 30, 2021
Applies to:
Oracle WebCenter Sites - Version 12.2.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
Unable to use vdm:setalias, encountering the following error:
[2017-11-14T15:22:41.484-06:00] [dlv_sites1] [ERROR] [] [oracle.wcsites.db] [tid: 143] [userId: <anonymous>] [ecid: 5555941e-1edb-4908-83eb-806f24a7744a-000001cd,0] [APP: sites] [partition-name: DOMAIN] [tenant-name: GLOBAL] Illegal table name VMVisitorAlias for PreparedStmt.
[2017-11-14T15:22:41.485-06:00] [dlv_sites1] [ERROR] [] [oracle.wcsites.sseed] [tid: 143] [userId: <anonymous>] [ecid: 5555941e-1edb-4908-83eb-806f24a7744a-000001cd,0] [APP: sites] [partition-name: DOMAIN] [tenant-name: GLOBAL] Exception in doEndTag() in tag com.openmarket.gator.jsp.vdm.Setalias in page 'CH_Wrapper' in element 'Panorama/CH/Security/GetSecurityGroups' errno: -106 errdetail: 0[[
java.lang.IllegalStateException: Illegal table name VMVisitorAlias for PreparedStmt.
at COM.FutureTense.CatalogManager.CatalogEngine._resolveMetadata(CatalogEngine.java:5378)
at COM.FutureTense.CatalogManager.CatalogEngine.executeStatement(CatalogEngine.java:5229)
at COM.FutureTense.Common.CS.SQL(CS.java:1166)
at com.openmarket.visitor.data.SessionVisitor._getCurrentVisitorForAlias(SessionVisitor.java:1178)
at com.openmarket.visitor.data.SessionVisitor.setAlias(SessionVisitor.java:1153)
at com.openmarket.visitor.data.PersistentVisitorDataConnection.setAlias(PersistentVisitorDataConnection.java:500)
at com.openmarket.gator.visitordatamanager.VisitorDataManager.setAlias(VisitorDataManager.java:451)
at com.openmarket.gator.seed.VisitorDataManager.worker(VisitorDataManager.java:172)
at com.openmarket.basic.seed.BaseSeed.doEndTag(BaseSeed.java:132)
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 |