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 JUNE 11, 2023

Applies to:

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