Announcement

Collapse
No announcement yet.

OBIEE Integration with OTM 5.5. CU4

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • OBIEE Integration with OTM 5.5. CU4

    Hi,

    I have tried to integrate OBIEE with existing OTM 5.5 CU4 version. As per the document,we should create new system DSN under ODBC connections. My OS is RHEL 4 and manually created the DSN in odbc.ini file as follows.

    [TEST]
    Driver=/oraclebi/server/Bin/libnqsodbc.so
    Description=Oracle BI Server
    ServerMachine=10.239.5.126
    UID=
    PWD=
    Port=9704

    But if I check the client connectivity using nqcmd, the commands hangs for ever. Is the configuration is correct?

  • #2
    Re: OBIEE Integration with OTM 5.5. CU4

    Hi Guys, Any updates? When I try to start the Oracle BI server, I found the following error in the NQServer.log file.

    [55003] The cache polling SELECT query failed for table UET.
    2008-09-22 23:49:02
    libclntsh.so.9.0: cannot open shared object file: No such file or directory
    [nQSError: 46029] Failed to load the DLL /oraclebi/server/Bin/libnqsdbgatewayoci8i.so. Check if 'Oracle OCI 8.x' database client is installed.
    2008-09-22 23:49:02
    [55005] The cache polling delete statement failed for table UET.
    2008-09-23 00:00:00
    [nQSError: 43059] Init block 'CURRENT MONTH INITIALIZATION': Dynamic refresh of repository scope variables has failed.
    libclntsh.so.9.0: cannot open shared object file: No such file or directory
    [nQSError: 46029] Failed to load the DLL /oraclebi/server/Bin/libnqsdbgatewayoci8i.so. Check if 'Oracle OCI 8.x' database client is installed.
    2008-09-23 00:00:00
    [nQSError: 43059] Init block 'CURRENT YEAR INIITIALIZATION': Dynamic refresh of repository scope variables has failed.
    libclntsh.so.9.0: cannot open shared object file: No such file or directory
    [nQSError: 46029] Failed to load the DLL /oraclebi/server/Bin/libnqsdbgatewayoci8i.so. Check if 'Oracle OCI 8.x' database client is installed.

    The Note 551110.1 talks about the installation of Oracle Client 9i. But My obiee version is 10.1.3.3.1 and I have currently configured with OCI 10g client.

    Is there any issues with this configuration?

    Comment


    • #3
      Re: OBIEE Integration with OTM 5.5. CU4

      The admin guide has all kinds of errors and should be corrected in the near future. I would suggest you get in contact with Oracle support to have a check over all of your configurations. Have you installed the Oracle 9i client to interface with OBI?
      If my post was helpful please click on the Thanks! button

      MavenWire Hosting Admin
      15 years of OTM experience

      Comment


      • #4
        Re: OBIEE Integration with OTM 5.5. CU4

        Nick,

        Thanks for your reply. But I didn't install the oracle 9i client, rather installed 10gR2 client. Because as per the doc,
        02 - Oracle 9i
        03 - Oracle 10g R1
        04 - Oracle 10g R2
        05 - DB2 OS/390 V7
        06 - DB2 OS/390 V8
        07 - DB2 UDB V7
        08 - DB2 UDB V8
        Enter 02 and press enter – in 10.1.3.3 you should select 3

        Since my OBIEE version is 10.1.3.3.1, I opted for 10.2.0.1 client. Can I install Oracle 9i client and check? More over, I can't find any client version for oracle 9iR2 for Linux.

        Please comment.

        Comment


        • #5
          Re: OBIEE Integration with OTM 5.5. CU4

          Which guide told you to install 10g client?

          Here is from the OTM admin guide

          Note: If you are installing OBI EE on a server running 64-bit Linux be sure the
          LD_LIBRARY_PATH for the “oracle” user also includes the < Oracle 9i Client Home>/lib32
          directory. If the path isn’t correct, the following error would be generated later in the OBI
          EE installation.



          I know that Oracle development has the 10g client working but you need to configure a bunch of things to get it working which have not yet been published. I would just install the 9i client for now.
          If my post was helpful please click on the Thanks! button

          MavenWire Hosting Admin
          15 years of OTM experience

          Comment


          • #6
            Re: OBIEE Integration with OTM 5.5. CU4

            Hi Nick,

            I installed the oracle9i client and the necessary configuration was done.I started the services, but found the following error while accessing the FTI from OTM.
            saw.dll was not found on this server.

            Also this my DSN entry in odbc.ini file.
            [RPTAPP]
            Driver=/oraclebi/server/Bin/libnqsodbc.so
            Description=Oracle BI Server
            ServerMachine=10.239.5.126
            UID=
            PWD=
            Port=9704

            Is this correct?

            Comment


            • #7
              Re: OBIEE Integration with OTM 5.5. CU4

              Did you rerun the [FONT='Arial','sans-serif']OBI EE]/Oracle BI\server\Bin\[/FONT]schconfig script again so that it uses the 9i client?

              I am also assuming you have installed this on a Redhat 4 server?


              [FONT='Arial','sans-serif']As far as modifying the odbc.ini, I can tell you that I didn't have to modify it to get this working. I had to add the RPTAPP as a tnsnames.ora entry into the Oracle 9i client.[/FONT]
              [FONT='Arial','sans-serif'][/FONT]
              If my post was helpful please click on the Thanks! button

              MavenWire Hosting Admin
              15 years of OTM experience

              Comment


              • #8
                Re: OBIEE Integration with OTM 5.5. CU4

                Nick,

                Configuration using schconfig utility was completed and the parameters defined as follows.

                ***** Scheduler Database Configuration *****
                1 - Database Type : Oracle 9i
                2 - Call Interface : OCI 8i/9i
                3 - Data Source Name : RPTAPP
                4 - User Name : hdowner
                5 - Password : *****
                6 - Timeout (Minutes) : 60
                7 - Maximum Connections : 5
                8 - Bulk Fetch Buffer Size (bytes) : 33792
                9 - Database Table for Jobs : S_NQ_JOB
                10 - Database Table for Instances : S_NQ_INSTANCE
                11 - Database Table for Parameters : S_NQ_JOB_PARAM
                12 - Database Table for Messages : S_NQ_ERR_MSG
                13 - DEFAULT VALUES
                0 - Quit

                However, While trying to connect to the OBIEE via OTM,got the following error.
                The requested URL /analytics/saw.dll was not found on this server.

                While trying to invoke the OBIEE using standalone method (http://<hostname:9704>/analytics> fails for the following error.
                Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.

                Did I miss something in the configuration?

                Comment


                • #9
                  Re: OBIEE Integration with OTM 5.5. CU4

                  However, While trying to connect to the OBIEE via OTM,got the following error.
                  The requested URL /analytics/saw.dll was not found on this server.

                  You are supposed to be using a separate version of apache and tomcat copied over from your otm install not what OBIEE ships with.
                  If my post was helpful please click on the Thanks! button

                  MavenWire Hosting Admin
                  15 years of OTM experience

                  Comment


                  • #10
                    Re: OBIEE Integration with OTM 5.5. CU4

                    Hi Nick,

                    I removed the DSN entry from my odbc.ini file and started the services. Now I'm getting the 'The page cannot be displayed' error while accessing OBIEE via OTM.

                    Also as per the documentation, I downloaded apache-tomcat-5.5.27.tar file for the tomcat installation. But copied the entire apache directory from otm installation and modified the files as per the doc. Is this correct?

                    If not, could you provide me the URL from where I can download the standalone apache? Because I checked the otn site and found weblogic is available now. My current version of httpd is 2.0.55.

                    Comment


                    • #11
                      Re: OBIEE Integration with OTM 5.5. CU4

                      Besides changing the IP address, the only changes you need to make to the server.xml for Tomcat is
                      Context path="/analytics" docBase="/opt/oraclebi/web/app" privileged="true">

                      You also have to add the JAVA_HOME directory to your startup and shutdown scripts for Tomcat.

                      Honestly you should already have a ticket opened with Oracle support. The 4-5 page document is missing a lot of information that is needed to get this installed. After I documented the entire process, I ended up with a 21 page document.
                      If my post was helpful please click on the Thanks! button

                      MavenWire Hosting Admin
                      15 years of OTM experience

                      Comment


                      • #12
                        Re: OBIEE Integration with OTM 5.5. CU4

                        Hi Nick,

                        Yes, I have raised the SR with Oracle, but still it's waiting with the development for more than a week. Thanks for all your inputs, so that I can reduce my error level.

                        I verified the server.xml and it seems fine. I have a big doubt. What are the services associated with OBIEE? For me the following services are running.

                        1. oc4j
                        2. BI server(run-sa.sh)
                        3.Oracle BI Java Host(run-saw.sh)
                        4.Oracle BI Scheduler(run-sch.sh)

                        Apart from this should I start the apache(using apachectl) and tomcat(startup.sh)? As per my configuration, I believe this should be the problematic one.

                        Comment


                        • #13
                          Re: OBIEE Integration with OTM 5.5. CU4

                          Yep that should be all that is needed. Check all of your obi startup scripts and ensure you don't get any errors in any of these startups.
                          If my post was helpful please click on the Thanks! button

                          MavenWire Hosting Admin
                          15 years of OTM experience

                          Comment


                          • #14
                            Re: OBIEE Integration with OTM 5.5. CU4

                            Hi Nick,

                            I started the services and found no errors in the logfiles. But still I can't see the dashboards from OTM.

                            What should be Listen port values in <obiee>/apache/conf/httpd.conf file? It should be same like the value in <otm>/apache/conf/httpd.conf file?

                            Here are the values at my environment.
                            /otm55/apache/conf/httpd.conf
                            Listen 10.239.5.126:80
                            Listen 10.239.5.126:443

                            /oraclebi/apache/conf/httpd.conf
                            Listen 10.239.5.126:8081
                            Listen 10.239.5.126:8443

                            /otm55/glog/config/glog.properties
                            aa_webserver=ctsinnvlvmotx.cts.com:8443

                            Do you find any issue over these values?

                            Comment


                            • #15
                              Re: OBIEE Integration with OTM 5.5. CU4

                              On the OBIEE http, I'm running on port 8081.

                              Make sure you glog.properties file on your web server looks like this for AA.

                              # Advanced Analytics
                              aa_webserver=xxx.mavenwire.com:8081
                              #aa_domain=.[AA_DOMAIN]
                              ALLOW_ADVANCED_ANALYTICS=true

                              Nick
                              If my post was helpful please click on the Thanks! button

                              MavenWire Hosting Admin
                              15 years of OTM experience

                              Comment

                              Working...
                              X