Error During Nio Conversion Attempt with ' (Apostrophe) in a BLOB's File Name

(Doc ID 2357913.1)

Last updated on FEBRUARY 12, 2018

Applies to:

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

Symptoms

While executing the nioconversion.sh utility on WebCenter Sites the following error is encountered:

10.01.2018 12:36:05 *ERROR* conversion: IO error copying file:<sharedfs>/ccurl/107/307/SSLDocument%271938799.pdf to dbasefs:///Shared/ccurl/107/307/SSLDocument'1938799.pdf java.io.IOException: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
(SitesUpgradeUtility.java, line 474)
10.01.2018 12:36:05 *INFO * nio: IO error copying file:<sharedfs>/ccurl/107/307/SSLDocument%271938799.pdf to dbasefs:///Shared/ccurl/107/307/SSLDocument'1938799.pdf java.io.IOException: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
(NIOconversion.java, line 307)
IO error copying file:<sharedfs>/ccurl/107/307/SSLDocument%271938799.pdf to dbasefs:///Shared/ccurl/107/307/SSLDocument'1938799.pdf java.io.IOException: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

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