My Oracle Support Banner

OBIEE 11g RCU Error When Checking Prerequisites -> "The default collation of database 'BIEE' cannot be set to SQL_Latin1_General_CP1_CS_AS" (Doc ID 1489175.1)

Last updated on SEPTEMBER 12, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Information in this document applies to any platform.

Goal

When running RCU, the following error is encountered:


DECLARE @collate sysname
SELECT @collate = convert(sysname, serverproperty('COLLATION'))
IF ( charindex(N'_CI', @collate) > 0 )
BEGIN
select @collate = replace(@collate, N'_CI', N'_CS')
exec ('ALTER database BIEE COLLATE ' + @collate)
END
GO
this returned the following error
Msg 5030, Level 16, State 2, Line 1
The database could not be exclusively locked to perform the operation.
Msg 5072, Level 16, State 1, Line 1
ALTER DATABASE failed. The default collation of database 'BIEE' cannot be set to SQL_Latin1_General_CP1_CS_AS
.

How can we resolve this issue?
 

Solution

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
Goal
Solution


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