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 MARCH 05, 2019

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.