WebCenter Content Server's Managed Server Will Not Start With MS SQL 2008 Case Sensitive Collation

(Doc ID 1561654.1)

Last updated on NOVEMBER 19, 2016

Applies to:

Oracle WebCenter Portal - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

WebCenter Content Server's managed Server will not start, if WebCenterConfigure is Enabled and SQL Server 2008 database is using Case Sensitive collation.

WebCenterConfigure is a setting in WebCenter Content Server that enabled as part of Webcenter Portal (WCP) and Spaces integration with WebCenter Content (WCC) Server.
<Document 1424064.1>  Tutorial: Configuring Oracle WebCenter Content Server with Oracle WebCenter Portal R11 (PS5)

To Reproduce:

1. Install MS SQL 2008 with Case Sensitive collation. Set database's default collation to SQL_Latin1_General_CP1_CS_AS or Latin1_General_CS_AS (for details refer Microsoft documentation on Setting and Changing Server Collation)

2. Execute RCU against this database and configure WCC.

3. After enabling WebcenterConfigure component <Document 1424064.1> an error is encountered when starting up UCM Managed Server.

 

Error reported in UCM logs is as follows:

 

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