Omniportlet: Cannot Open the URL Specified because of Connection Timeout (Doc ID 1323572.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Portal - Version 10.1.2.3 and later
Information in this document applies to any platform.
Checked for relevance on 21-Nov-2014

Symptoms

Getting the following error when trying to create an omniportlet based on a csv file:

Cannot open the URL specified because of connection timeout. [http://myserver.oracle.com/portal/page/portal/OracleTest/foo.csv]

From the /<MIDTIER>/j2ee/OC4J_Portal/application-deployments/portalTools/OC4J_Portal_default_island_1/application.log:

11/05/17 12:19:18 omniPortlet: [instance=1997592_OMNIPORTLET_465522212, id=24723092716544,6] Cache: invalidated 1997592_OMNIPORTLET_465522212/PORTAL [co]
11/05/17 12:19:18 omniPortlet: [instance=1997592_OMNIPORTLET_465522212, id=24723092716544,6] Cache: Number of objects invalidated = 0
11/05/17 12:20:47 omniPortlet: [instance=(null), id=(null)] WARNING: Request has exceeded its warning timeout Time[elapsed=20496ms. Warning timeout=20000ms.] Request[id=17249849723231,6 providerId=465522212 portletId=100 portletName=OmniPortlet portletInstance=1997592_OMNIPORTLET_465522212 user=PORTAL] Thread[ name=AJPRequestHandler-ApplicationServerThread-21 priority=5 alive=true interrupted=false groupName=ApplicationServerThreadGroup]
11/05/17 12:20:57 omniPortlet: [instance=1997592_OMNIPORTLET_465522212, id=17249849723231,6] Failed to create HttpConnection:http://myserver.oracle.com/portal/page/portal/OracleTest/foo.csv => oracle.webdb.reformlet.ReformletException: Cannot open the URL specified because of connection timeout. [http://myserver.oracle.com/portal/page/portal/OracleTest/foo.csv]
oracle.webdb.reformlet.ReformletException: Cannot open the URL specified because of connection timeout. [http://myserver.oracle.com/portal/page/portal/OracleTest/foo.csv]
at oracle.webdb.reformlet.SmartURL.openStream(Unknown Source)
at oracle.webdb.reformlet.data.csv.CSVDataSourceDefinition.getMetaData(Unknown Source)
at oracle.webdb.reformlet.data.DataSourceDefinitionWrapper.getMetaData(Unknown Source)
at oracle.webdb.reformlet.definition.DataDefinition.getMetaData(Unknown Source)
at _htdocs._omniportlet._reformlet__edit__defaults__data__csv._jspService(_reformlet__edit__defaults__data__csv.java:949)
at com.orionserver[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:281)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:498)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:402)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:835)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.ServletRequestDispatcher.include(ServletRequestDispatcher.java:127)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.EvermindPageContext.include(EvermindPageContext.java:271)
at _htdocs._omniportlet._reformlet__edit__defaults._jspService(_reformlet__edit__defaults.java:661)
at com.orionserver[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:281)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:498)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:402)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:835)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:261)
at oracle.portal.provider.v2.render.http.AbstractResourceRenderer.renderBody(Unknown Source)
at oracle.portal.provider.v2.render.RenderManager.render(Unknown Source)
at oracle.portal.provider.v2.DefaultPortletInstance.render(Unknown Source)
at oracle.webdb.provider.v2.adapter.soapV1.ProviderAdapter.showPortlet(Unknown Source)
at oracle.webdb.provider.v2.adapter.soapV1.ProviderAdapter.handleHttp(Unknown Source)
at sun.reflect.GeneratedMethodAccessor421.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at oracle.webdb.provider.v2.adapter.SOAPServlet.doHTTPCall(Unknown Source)
at oracle.webdb.provider.v2.adapter.SOAPServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:835)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:816)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:231)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:136)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
at java.lang.Thread.run(Thread.java:534)
The original exception was
[
java.io.InterruptedIOException: Connection establishment timed out
at HTTPClient.HTTPConnection.getSocket(HTTPConnection.java:3283)
at HTTPClient.HTTPConnection.doConnect(HTTPConnection.java:4043)
at HTTPClient.HTTPConnection.sendRequest(HTTPConnection.java:3019)
at HTTPClient.HTTPConnection.handleRequest(HTTPConnection.java:2859)
at HTTPClient.HTTPConnection.setupRequest(HTTPConnection.java:2651)
at HTTPClient.HTTPConnection.Get(HTTPConnection.java:978)
at HTTPClient.HTTPConnection.Get(HTTPConnection.java:897)
at oracle.webdb.reformlet.SmartURL.openStream(Unknown Source)
at oracle.webdb.reformlet.data.csv.CSVDataSourceDefinition.getMetaData(Unknown Source)
at oracle.webdb.reformlet.data.DataSourceDefinitionWrapper.getMetaData(Unknown Source)
at oracle.webdb.reformlet.definition.DataDefinition.getMetaData(Unknown Source)
at _htdocs._omniportlet._reformlet__edit__defaults__data__csv._jspService(_reformlet__edit__defaults__data__csv.java:949)
at com.orionserver[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:281)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:498)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:402)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:835)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.ServletRequestDispatcher.include(ServletRequestDispatcher.java:127)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.EvermindPageContext.include(EvermindPageContext.java:271)
at _htdocs._omniportlet._reformlet__edit__defaults._jspService(_reformlet__edit__defaults.java:661)
at com.orionserver[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:281)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:498)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:402)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:835)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:261)
at oracle.portal.provider.v2.render.http.AbstractResourceRenderer.renderBody(Unknown Source)
at oracle.portal.provider.v2.render.RenderManager.render(Unknown Source)
at oracle.portal.provider.v2.DefaultPortletInstance.render(Unknown Source)
at oracle.webdb.provider.v2.adapter.soapV1.ProviderAdapter.showPortlet(Unknown Source)
at oracle.webdb.provider.v2.adapter.soapV1.ProviderAdapter.handleHttp(Unknown Source)
at sun.reflect.GeneratedMethodAccessor421.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at oracle.webdb.provider.v2.adapter.SOAPServlet.doHTTPCall(Unknown Source)
at oracle.webdb.provider.v2.adapter.SOAPServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:835)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:816)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:231)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:136)
at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.3.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
at java.lang.Thread.run(Thread.java:534)
]
11/05/17 12:20:57 omniPortlet: [instance=1997592_OMNIPORTLET_465522212, id=17249849723231,6] Cache: invalidated 1997592_OMNIPORTLET_465522212/PORTAL [co]
11/05/17 12:20:57 omniPortlet: [instance=1997592_OMNIPORTLET_465522212, id=17249849723231,6] Cache: Number of objects invalidated = 0


Steps to reproduce:

  1. Log into Portal as the portal user.
  2. Create a new page group called OracleTest. Ensure the root page has checked the option: Display Page To Public Users.
  3. Add two regions to the root page.
  4. In the first region add a file item and upload any csv file to the item.
  5. Take the URL for the item (click on the item and click right button).  It should be something like this:
    http://<your servername>:<port>/portal/page/portal/OracleTest/foo.csv
  6. In the second region, add an omniporlet.
  7. Click on Define.
  8. Select "Spreadsheet - A text file with character separated values (CSV)"
  9. Enter the URL copied from step 5.
    http://<your servername>:<port>/portal/page/portal/OracleTest/foo.csv
  10. Enter next and you will get the error.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms