My Oracle Support Banner

Inability To Create Folders in UCM 11g with Folders_g when Using SQL Server (Doc ID 1359449.1)

Last updated on MAY 09, 2023

Applies to:

Oracle WebCenter Content - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Symptoms

Using UCM 11g with Microsoft SQL Server 2008r2, and the SQL Server is setup to be case-sensitive.

The Folders_g component was enabled.

The folder configuration is available in the UCM interface. For example, when looking at the administration menu's folder configuration, and clicking on system folder configuration, you  see Trash disabled and Contribution Folders enabled (green button).

However, the enabled folders do not appear in the "Browse Content" dropdown menu.

If you check the database, the Contributions Folder exists. The columns in the database are case-sensitive as expected.

Additionally, when that configuration page is accessed, it sporadically does not work and returns the following error message:

Changes

Using Microsoft SQL Server in case-sensitive mode causes this issue.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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