Apostrophes In URL Pattern Causing Publishing Errors (Doc ID 1952252.1)

Last updated on JULY 07, 2017

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

Vanity URLs with apostrophe (') in the URL don't get published. The publish succeeds but the target log contains errors:

[2014-11-07 10:44:17,667 CST] [ERROR] [-1-Publishing-ParallelUnpacker] [fatwire.logging.cs.db] SQLException executing query: SELECT * FROM WebReferences WHERE concat(webroot,webreferenceurl) IN ('myArticles/d'invalid-title')
java.sql.SQLException: Unexpected token in statement [SELECT * FROM WebReferences WHERE concat(webroot,webreferenceurl) IN ('myArticles/d'invalid]


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