WCS 12213 upgrade script upgrade_sites_data.sql contains Windows path separator "\" in Insert statements for ElementCatalog table

(Doc ID 2409548.1)

Last updated on JUNE 14, 2018

Applies to:

Oracle WebCenter Sites - Version 12.2.1.3.0 to 12.2.1.3.0 [Release FatWire]
Information in this document applies to any platform.

Goal

Q1: Can the upgrade script (/sql/wcsites/Data/oracle/12.2.1.x.x/upgrade_sites_data.sql where x.x can be 0.0 or 1.0 or 2.0) for Sites 12.2.1.0.0, 12.2.1.1.0 and 12.2.1.2.0 be used in the original form ?

Note that original form contains INSERT statements into ElementCatalog table that contain windows "\" separator for "URL" column, like for example:
- INSERT INTO ElementCatalog (elementname, description, url, resdetails1, resdetails2) VALUES (N'EloquaIntegration/Instances/Add', NULL, N'EloquaIntegration\Instances\Add.jsp', NULL, NULL)
- INSERT INTO ElementCatalog (elementname, description, url, resdetails1, resdetails2) VALUES (N'EloquaIntegration/Instances/Copy', NULL, N'EloquaIntegration\Instances\Copy.jsp', NULL, NULL)
- INSERT INTO ElementCatalog (elementname, description, url, resdetails1, resdetails2) VALUES (N'EloquaIntegration/Instances/Delete', NULL, N'EloquaIntegration\Instances\Delete.jsp', NULL, NULL)
- INSERT INTO ElementCatalog(elementname,description,url,resdetails1,resdetails2)VALUES('OpenMarket/Gator/FlexibleAssets/Common/AssocParentDetailsDisplay','Display Details','OpenMarket\Gator\FlexibleAssets\Common\AssocParentDetailsDisplay.jsp',NULL,NULL)
 

Solution

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