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

Question

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.(WSServiceDelegate.java:197) at com.sun.xml.internal.ws.client.WSServiceDelegate.(WSServiceDelegate.java:145) at com.sun.xml.internal.ws.spi.ProviderImpl.createServiceDelegate(ProviderImpl.java:93) at javax.xml.ws.Service.(Service.java:56) at oracle.xdo.tools.catalog.proxy.axis.PublicReportServiceService.(PublicReportServiceService.java:45) at oracle.xdo.tools.catalog.proxy.axis.PublicReportServiceProxy._initPublicReportServiceProxy(PublicReportServiceProxy.java:35) at oracle.xdo.tools.catalog.proxy.axis.PublicReportServiceProxy.(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.(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

User_ROJRK · Answer

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.

Sumanth V -Oracle · Answer

@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 · Answer

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