My Oracle Support Banner

Error 'Repository creation check failed' When Running the Repository Creation Utility in Oracle Business Intelligence or Oracle Analytics Server on a Microsoft SQL ServerDatabase Instance (Doc ID 2953596.1)

Last updated on MARCH 20, 2024

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.2 and later
Oracle Analytics Server - Version 5.5.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 and later
Oracle Business Intelligence Enterprise Edition - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to execute the Repository Creation Utility for Oracle Business Intelligence or Oracle Analytics Server on a SQL Server Database instance, the following error occurs:

<TimeStamp> ERROR assistants.rcu.backend.task.ActualTask: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed oracle.sysman.assistants.common.task.TaskExecutionException:
ERROR - RCU-6083 Prerequisite check failed for selected component:
CAUSE - RCU-6083 Prerequisite check failed for selected component.
ACTION - RCU-6083 Refer to the RCU logs for additional details. Make sure that the prerequisite requirements are met.MDS
Refer to RCU log at C:\Users\user\AppData\Local\Temp\RCU2023-06-02_23-18_1437048090\logs\rcu.log for details.
-------------------------------------------------------------------------------
Component : MDS
Error : Repository creation check failed.
Cause : Database: 'Database_Name' is not configured correctly.
Action : Alter database to apply the correct collate to the database.  Ensure you have DBA priviliges.
  Also, the DBA should not have
multiple logins on this database - else it will result in a lock error.
Command : 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 $(DATABASE_NAME) COLLATE ' + @collate)
  END
  GO
-------------------------------------------------------------------------------
at oracle.sysman.assistants.rcu.backend.task.PrereqTask.execute(PrereqTask.java:84)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:345)
at java.lang.Thread.run(Thread.java:748)

Changes

 

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!


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