vdm:setalias Not Working With Microsoft SQL Server

(Doc ID 2341198.1)

Last updated on MARCH 01, 2018

Applies to:

Oracle WebCenter Sites - Version 12.2.1.0.0 and later
Information 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

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