1 Reply Latest reply: Aug 8, 2014 2:33 PM by Nathan P. RSS

    RCU (Repository Creation Utility) cannot create DEV_MDS HELP!

    2726367

      I'm using Windows server 2008, MS SQL database and i'm installing BI. So there is a problem i can't create schema DEV_MDS (Metadata services). Here's failed message:

       

      • RCU-6083:Failed - Check prerequisites requirement for selected component:MDS Please refer to RCU log at C:\rcuHome\rcu\log\logdir.2014-08-07_13-03\rcu.log for details. ------------------------------------------------------------------------------- Component : MDS Error : Repository creation check failed. Cause : Database: 'PMDB' 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 ------------------------------------------------------------------------------- RCU-6092:Component Selection validation failed. Please refer to log at C:\rcuHome\rcu\log\logdir.2014-08-07_13-03\rcu.log for details.

       

      Help!

        • 1. Re: RCU (Repository Creation Utility) cannot create DEV_MDS HELP!
          Nathan P.

          You need to run these scripts on your database as sysadmin:

           

          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 INSERT_DB_NAME_HERE COLLATE ' + @collate)  

          END           

          GO

           

           

          You need to also set your READ_COMMITTED_SNAPSHOT to on:

           

           

          ALTER DATABASE EnterpriseData SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

          ALTER DATABASE EnterpriseData SET READ_COMMITTED_SNAPSHOT ON;

          ALTER DATABASE EnterpriseData SET MULTI_USER;