Inserts of Metadata with Apostrophes Into IBM UDB/DB2 Database Throws SQL Error: "SQLCODE: -104, SQLSTATE: 42601" (Doc ID 446945.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version 7.5.0 to 10.1.3.6.0 [Release Stellent to 10gR3]
Information in this document applies to any platform.
This issue can occur when attaching to an IBM DB2/UDB database with Content Server via JDBC.


Symptoms

Inserts of metadata with apostrophes, including inserts of Options List data, into an IBM UDB/DB2 Database during check-in or Configuration Manager use, fail with DB2 SQL Error:

 

SQL0104N An unexpected token ....... SQLSTATE=42601

 

  or

Error Updating options list. Unable to execute service UPDATE_OPTIONS_LIST and
function updateOptionsList.
(System Error: Unable to execute query 'Ioption(INSERT INTO OptionsList (dKey,
dOption, dOrder) values (N'ClientNameList',N'Customer''s Name',3))'.
DB2 SQL error: SQLCODE: -104, SQLSTATE:42601, SQLERRMC: 's Name';
ntNameList',N'Customer';<space>)

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