8 Replies Latest reply on May 20, 2015 9:03 PM by 2884800

    RCU

    2884800

      I am trying to install RCU so I can install the business intelligence tools, so I can use one view reporting. Is that the correct order of install to get one view installed?

       

      Also, when running RCU on the database connection details, I keep getting this message:

       

      I have the correct information in the details. Any ideas? JDE 9.1 TR 9.1.5.2 Microsoft SQL Server database.

        • 1. Re: RCU
          Felipe_Idalgo

          You must do:

           

          1) run repository creation utility (RCU) for create repository schemas (<PREFIX>_MDS and <PREFIX>_BIPLATFORM)

          2) after download OBIEE binaries, execute the installation (verify all prereqs for your system and hardware like Static IP, host file, JVM, SO ...)

          3) after installation, login into OBIEE anlytics trought http://<your_server>:9704/analytics

           

          Documentations for OBIEE 11g

           

          11.1.1.9.0

          Get Started:

           

          11.1.1.7.0

          Oracle Fusion Middleware Online Documentation Library

           

          Felipe Idalgo

          • 2. Re: RCU
            2884800

            I got past this part. I had the incorrect port number. This is what I am getting now:

             

            When I look at the log it says:

             

            Component     : MDS

            Error         : Repository creation check failed.

            Cause         : Database: 'JDE_DEVELOPMENT' 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

             

            What do I do with that?

            • 3. Re: RCU
              Felipe_Idalgo

              Hi,

               

              Is your DB user have DBA permission on this instance? (Db user used for create objects by RCU)

               

              Another point

               

              What´s your DB full version, RCU version and SO version (from local machine)?

               

              Felipe

              • 4. Re: RCU
                2884800

                The user has sysadmin role in SQL Server 2012.

                 

                DB version is SQL Server 2012:

                I downloaded RCU "ofm_rcu_win_11.1.1.7.0_32_disk1_1of1" Should I try 64 bit?

                 

                I do not know what SO means.

                 

                Does this have anything to do with the server collation?

                should it be SQL_Latin1_General_CP1_CS_AS ?

                 

                https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=397956003685578&id=1489175.1&_afrWindowMode=0&_adf.ctrl-state=x5p43iscx_4

                • 5. Re: RCU
                  Felipe_Idalgo

                  Hi,

                  I think your problem occurs because your database version is not certified for OBIEE 11.1.1.7 (target repository schema)

                   

                  If you see into certification matrix, obiee 11.1.1.7.0 needs SQL Server 2005, 2008 and 2008 R2 for repository.

                  New version of OBIEE (11.1.1.9.0) works fine with SQL Server 2012.

                   

                  Follow fusion certification

                   

                  http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html

                   

                  Felipe Idalgo

                  • 6. Re: RCU
                    2884800

                    where can I download the correct version?

                    • 7. Re: RCU
                      Felipe_Idalgo

                      Hi,

                       

                      you can download obiee 11.1.1.9 here

                       

                      Oracle Business Intelligence 11g Downloads

                       

                      Or.. you can use SQL Server 2008 for schema repository and SQL Server 2012 for Datasource.

                       

                      Please.. mark rjght if it help you.

                       

                      Felipe Idalgo

                      • 8. Re: RCU
                        2884800

                        I followed the link, selected oracle business intelligence>all supported platforms>under RCU, download for Windows. After running the newer version I received pretty much the same error:

                         

                        Component     : MDS

                        Error         : Repository creation check failed.

                        Cause         : Database: 'JDE_DEVELOPMENT' 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