Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Reg: HTTP connection server issue

Received Response
23
Views
9
Comments
3204856
3204856 Rank 3 - Community Apprentice
edited Aug 13, 2024 6:58PM in Oracle Analytics Cloud and Server

Hi All,

All of a sudden we are facing below issue in report level we checked all the server are up and running fine and DB server also running fine.Can any one suggest

latest1.png

Thanks in advance,

Answers

  • 3204856
    3204856 Rank 3 - Community Apprentice

    Hi All,

    Can any one suggest on the above issue.

    Thanks in advance,

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello,

    I could see that you connect through ODBC, to get your user and groups, have you test your connection ODBC to get it? there is any information connection that already changed?

    Have you implemented any changed in your OBIEE Security?

    This error is because you cant get the credential of your user/groups for that reason you got it.

    Kind Regards,

  • 3204856
    3204856 Rank 3 - Community Apprentice

    Hi ,

    Thanks for the reply.

    We did't implement any security changes recently even ODBC every thing working fine. Please find the below error message from logs

    [2016-03-01T02:01:42.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0000LHMA9^0BT8QLUaXBic1N7xVh0004oo] [tid: 2dc] Error Message From BI Security Service: [nQSError: 12002] Socket communication error at call=Connect: (Number=0) Call=NQRpc: An unknown socket communications error has occurred. [[

    [nQSError: 12010] Communication error connecting to remote end point: address = XXXXXXXXX; port = 9704.

    [nQSError: 46119] Failed to open HTTP connection to server XXXXXXXX at port 9704.

    [nQSError: 43113] Message returned from OBIS.

    ]]

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello,

    1. Do you have some firewalls in your client or firewall in your BI Server?

    2. Let me insist again, your authentication is on any LDAP Server ( Active Directory, Oracle Access Manager, etc?), if the answer it's yes,

       do you have a firewall in your LDAP Server?

    3. Do you apply a ping from your client to the host of your BI server?

    4. Do you apply telnet from your client to check if the port is open?

    what i check that error is in ORACLE BI USER POPULATION API, and this error its because this API cant get the user and groups.

    Kind Regards,

  • 3204856
    3204856 Rank 3 - Community Apprentice

    Hi ,

    1. We don't have any fire walls running in the servers .

    2. We are using LDAP authentication there was no firewall in that server also.

    3. We apply ping to the host its working fine.

    4. We apply Telnet to the port but it was not connecting showing below message


    Connecting  to 23.. could not open connection to the host, on port 23: connect failed

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello,

    Please

    1. Go inside your OS of your BI and  run this command to check what process is running in your :23

    netstat -tulpn | grep :23


    Kill the process which is using the :23 port and restart your OBIEE


    2. Go inside your OS of your BI and do a ping from your OS BI SERVER to YOUR LDAP SERVER, please, also apply TELNET to check


    3. There is any setting up in your LDAP Server that could impact in the retrieve from your OBIEE server,

       USER BASE URL

       ALL USER FILTER

       ..

       ETC


    AD1.png


    Kind Regards,


  • 3204856
    3204856 Rank 3 - Community Apprentice

    Hi ,

    After restarting the server machine and all services the issue got resolved.

    thanks for your all reply's.

    Thanks in Advance.

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    OK, good for you!

    Kind regards

  • Gianni Ceresa
    Gianni Ceresa Mod

    So can you close the thread?

    Right now it is still This question is Not Answered.