Oracle Analytics Publisher

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

Categories

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

BIPCatalogUtil.sh - Error with Unknown Host Exception - Oracle Fusion Cloud

Received Response
21
Views
4
Comments
User_ROJRK
User_ROJRK Rank 1 - Community Starter
in Oracle Analytics Publisher

i installed oracle Analytics Client tools ( https://www.oracle.com/middleware/technologies/oac-tools-downloads.html ) to export /import BIPReports in my linux instance

i'm trying to import / export BIP Reports using BIPCatalogUtil , i'm encountering this error while executing these commands , any help is appreaciated

i have masked the hostname

sh BIPCatalogUtil.sh -listfolder catalogpath=/Custom/ExportDemo subfolders=true
[listfolder] Connect to https://xxxx-xxxxx-dev1.fa.ocs.oraclecloud.com/xmlpserver/ using xxxxxxxxxxxxxxxxxx
Exception in thread "main" javax.xml.ws.WebServiceException: Failed to access the WSDL at: https://xxxx-xxxxx-dev1.fa.ocs.oraclecloud.com/xmlpserver/services/PublicReportService?wsdl. It failed with:
xxxxxx-xxxxxx-dev1.fa.ocs.oraclecloud.com.
at com.sun.xml.internal.ws.wsdl.parser.RuntimeWSDLParser.tryWithMex(RuntimeWSDLParser.java:151)
at com.sun.xml.internal.ws.wsdl.parser.RuntimeWSDLParser.parse(RuntimeWSDLParser.java:133)
at com.sun.xml.internal.ws.client.WSServiceDelegate.parseWSDL(WSServiceDelegate.java:234)
at com.sun.xml.internal.ws.client.WSServiceDelegate.<init>(WSServiceDelegate.java:197)
at com.sun.xml.internal.ws.client.WSServiceDelegate.<init>(WSServiceDelegate.java:145)
at com.sun.xml.internal.ws.spi.ProviderImpl.createServiceDelegate(ProviderImpl.java:93)
at javax.xml.ws.Service.<init>(Service.java:56)
at oracle.xdo.tools.catalog.proxy.axis.PublicReportServiceService.<init>(PublicReportServiceService.java:45)
at oracle.xdo.tools.catalog.proxy.axis.PublicReportServiceProxy._initPublicReportServiceProxy(PublicReportServiceProxy.java:35)
at oracle.xdo.tools.catalog.proxy.axis.PublicReportServiceProxy.<init>(PublicReportServiceProxy.java:23)
at oracle.xdo.tools.catalog.command.SOAPCommand.connect(SOAPCommand.java:54)
at oracle.xdo.tools.catalog.command.SOAPCommand.connect(SOAPCommand.java:47)
at oracle.xdo.tools.catalog.command.ListCatalogFolder.execute(ListCatalogFolder.java:60)
at oracle.xdo.tools.catalog.command.CommandRunner.execute(CommandRunner.java:124)
at oracle.xdo.tools.catalog.command.CommandRunner.process(CommandRunner.java:483)
at oracle.xdo.tools.catalog.command.CommandRunner.main(CommandRunner.java:528)
Caused by: java.net.UnknownHostException: xxxx-xxxxx-dev1.fa.ocs.oraclecloud.com
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:195)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:570)
at com.sun.net.ssl.internal.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:141)
at sun.net.NetworkClient.doConnect(NetworkClient.java:163)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:411)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:525)
at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:272)
at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:329)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(AbstractDelegateHttpsURLConnection.java:172)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:923)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(AbstractDelegateHttpsURLConnection.java:158)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1195)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:234)
at java.net.URL.openStream(URL.java:1010)
at com.sun.xml.internal.ws.wsdl.parser.RuntimeWSDLParser.createReader(RuntimeWSDLParser.java:793)
at com.sun.xml.internal.ws.wsdl.parser.RuntimeWSDLParser.resolveWSDL(RuntimeWSDLParser.java:251)
at com.sun.xml.internal.ws.wsdl.parser.RuntimeWSDLParser.parse(RuntimeWSDLParser.java:118)
... 14 more

Any help would be appreciated , TIA

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @User_ROJRK - As per the error message above it complains about the host being reachable. Please let us know if you are able to ping the FA host from the client machine from where you are running the BIPCatalogUtil command.

  • User_ROJRK
    User_ROJRK Rank 1 - Community Starter
    edited Jun 4, 2024 4:32PM

    Hi Sumanth ,

    No , im getting an connection timedout Error

    --2024-06-04 13:08:52-- https://xxxxx-xxxxxx-dev1.fa.ocs.oraclecloud.com/xmlpserver/services/PublicReportService?wsdl
    Resolving xxxxx-xxxxxxx-dev1.fa.ocs.oraclecloud.com (xxxxx-xxxxxx-dev1.fa.ocs.oraclecloud.com)... 140.86.222.129
    Connecting to xxxxxx-xxxxxx-dev1.fa.ocs.oraclecloud.com (xxxxx-xxxxxx-dev1.fa.ocs.oraclecloud.com)|140.86.222.129|:443... failed: Connection timed out.
    Retrying.

    --2024-06-04 13:11:03-- (try: 2) https://xxxxx-xxxxxx-dev1.fa.ocs.oraclecloud.com/xmlpserver/services/PublicReportService?wsdl
    Connecting to xxxxx-xxxxxx-dev1.fa.ocs.oraclecloud.com (xxxxx-xxxxxx-dev1.fa.ocs.oraclecloud.com)|140.86.222.129|:443... failed: Connection timed out.

    please note the instance is accessable via internet and im not behind any firewall

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @User_ROJRK - That could be causing the issue. Is the Fusion instance accessible in public? If yes, please do try installing the Oracle Analytics Client tools in the machine where it's accessible and then try using the utility again. Share your feedback after trying the same. Thanks.

  • User_ROJRK
    User_ROJRK Rank 1 - Community Starter

    Hi Sumanth, Yes Fusion instance is accessible in public , im able to access the url via browser but via command line if i try to ping or use Wget it fails with this timeout error

    Running BipCatalogUtility.sh fails as well.

    .Exception in thread "main" javax.xml.ws.WebServiceException: Failed to access the WSDL at: https://xxxxx-xxxxxx-dev1.fa.ocs.oraclecloud.com/xmlpserver/services/PublicReportService?wsdl. It failed with:
    xxxxx-xxxxxx-dev1.fa.ocs.oraclecloud.com.