Oracle Analytics Publisher

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

Categories

BI Publisher Microsoft Office AddIn Proxy Configuration

Received Response
52
Views
7
Comments
Tom_Chav
Tom_Chav ✭
edited June 27 in Oracle Analytics Publisher

Hi team,

I can't log on to the Oracle BI Publisher using the Word/Excel Office Add In.

The reason is that there are 2 proxies and the one route works but the other does not work.
Is there any way to configure the Office Addin to use a specific proxy ?
I tried to update the Java Option using the -Dhttp.proxyHost and -DhttpProxyPort but these flags are for the server and not for the AddIn

Any help ?

Many Thanks

Tagged:

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle ✭✭✭✭✭

    Hi @Tom_Chav

    Server end you need to configure the parameters - setDomainEnv file.

    Example - 

    EXTRA_JAVA_PROPERTIES="-Dhttp.proxyHost=www-proxy.example.com -Dhttp.proxyPort=80 -Dhttp.nonProxyHosts=localhost|*.mycompany.com|*.mycorporation.com|*.otherhost.com ${EXTRA_JAVA_PROPERTIES}"
export EXTRA_JAVA_PROPERTIES

    Try to set these parameters are your local JAVA and see are you able to fix your issue? -Dhttp.proxyHost & -Dhttp.proxyPort ( you can set these parameters client system means where your desktop software has been installed )

    Regards,

    Arjun

  • Tom_Chav
    Tom_Chav ✭

    Hi Arjun,

    Thank you for your response.

    I have already tried to set up the Params on the Desktop side and it does not work.

    Regards

    Thomas

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle ✭✭✭✭✭

    Hi @Tom_Chav

    Are you getting any Error?

    Regards,

    Arjun

  • User_H9C0W
    User_H9C0W ✭

    Hi Arjun,

    The Error message is:
    Error while trying to connect to report server Location. Unable to connect to the remote server

    Report Server location is ….

    Regards

    Thomas

  • Dir_Pal
    Dir_Pal ✭✭✭✭✭

    @User_H9C0W Try Installing Fiddler.. Configure BI Publisher Office Add-In to Use Fiddler. Try this route n see if its working

  • Tom_Chav
    Tom_Chav ✭
    edited July 1

    Hi Arjun,

    Except the issue with the Proxy, there was also an issue with the TLS 1.0.

    More info:

    https://support.oracle.com/cloud/faces/DocumentDisplay?_afrLoop=133110312206337&_afrWindowMode=0&id=2809997.1&_adf.ctrl-state=gj46kbs23_67

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle ✭✭✭✭✭

    Hi @Tom_Chav

    I hope you need to use the TLS1.2 not TLS 1.0 as its no longer using.

    Regards,

    Arjun