0 Replies Latest reply on Feb 18, 2017 7:51 PM by 3359624

    Connecting Oracle BI to HIVE

    3359624

      Hello All.

      I have installed Oracle BI into ubuntu in VirtualBox.

      I'm trying to connect BI to Hive via web interface and get this error on dialog :

      d0ae06bac9474671a379011551280a2e.png

       

      This is log file:

      http://image.prntscr.com/image/d0ae06bac9474671a379011551280a2e.png

      [rid: 0:2:23] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000000> <TIMEOUT_ERROR Request timed out: Request Headers

      X-BI-SERVICE-INSTANCE-KEY=ssi

      User-Agent=DSS/v1

      Accept-Language=en-US,en;q=0.5

      OBIEE_SERVICE_NAME=DatasourceService

      OBIEE_BYPASS_ADF_PROTOCOL=true

      OBIEE_CONN_POOL_TIMEOUT=300000

      OBIPARAM_ImpersonatedUser=weblogic

      BISuperUserName=tzmv4us7do8ji2xcenylwhafg3qbkrp5

      OBIARG_datasourceName=JDBC

      OBIARG_targetConn=JDBC (BIJDBC)

      OBIPARAM_DriverClass=oracle.bi.jdbc.AnaJdbcDriver

      OBIPARAM_TargetType=Hadoop

      OBIPARAM_ConnectionString=jdbc:oraclebi://oracle-VirtualBox:9508/PrimaryCCS=oracle-VirtualBox;PrimaryCCSPort=9508;SSL=false;NQ_SESSION.SERVICEINSTANCEKEY=ssi;

      OBIPARAM_UserName=tzmv4us7do8ji2xcenylwhafg3qbkrp5

      OBIPARAM_Password=XXXXX

      OBIPARAM_ConnectionID='weblogic'.'HiveDs'

      OBIEE_METHOD_NAME=getObjectsList

      OBIPARAM_SchemaClearCache=true

      Host=oracle-VirtualBox:9502

      Accept=text/html, image/gif, image/jpeg, */*; q=.2

      Connection=Keep-Alive

      ECID-Context=1.cd5c7bc2-c8c5-4214-bea9-f403ebd8eaec-000002dd;kYinv0YDJPHBBLPUn3VSdGXIVVNLCKIHVKHM5VML5JGLFINN1ODDs9DEn4DDt2C

       

       

      Cause - The request did not complete within the allotted time.

      Action - Check the log for details and increase the connection pool timeout or fix the root cause.

      oracle.bi.datasource.service.adf.server.DatasourceServlet.doGet(DatasourceServlet.java:454)

      javax.servlet.http.HttpServlet.service(HttpServlet.java:687)

      >

       

      Seems bi trying to reach something on 9508 port, what shall be there?

      I do can ping machine where Hive is installed and it's running okay.

       

      Maybe i still need to install something more?

       

      Update :
      On 9508: Cluster Controller i suppose it should be running.

       

      Update 2:
      So on 9508 OBICCS is supposed to be, and i see on last part of startup script output that it is started.

      From admin console ( Environment-> Clusters) i saw that my bi_cluster doesn't have anything in 'cluster address' column, what value should be there?

      Added complete log to attachments

       

       

      And in general: am i correct supposing that i need cluster to connect BI to HIVE?