6 Replies Latest reply: Jan 29, 2010 4:39 PM by 750004 RSS

    BIB-14122, ORA-17002 errors when trying to run deployed Java application

    420471
      Greetings,

      We deployed a BI Beans project as a java application. Local users can use it without problems. However, remote users are getting errors. I tried editing the connection and making the server name a fully-qualified name (i.e., server.subdomain.domain.com instead of just server), but that did not help. Any ideas? Error text follows.

      oracle.dss.persistence.persistencemanager.common.PersistenceManagerRuntimeException: BIB-14122: The specified StorageManager could not be created.
      oracle.dss.security.BISecurityException: ORA-17002 Io exception: The Network Adapter could not establish the connection
      java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
           at oracle.dss.persistence.persistencemanager.server.PersistenceManagerSupport.loadStorageAdapterFromXML(PersistenceManagerSupport.java:444)
           at oracle.dss.persistence.persistencemanager.server.PersistenceManagerSupport.<init>(PersistenceManagerSupport.java:145)
           at oracle.dss.persistence.persistencemanager.server.PersistenceManagerImpl.<init>(PersistenceManagerImpl.java:99)
           at oracle.dss.persistence.persistencemanager.server.InitPersistenceManagerFactory.getInitialContext(InitPersistenceManagerFactory.java:29)
           at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
           at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
           at javax.naming.InitialContext.init(Unknown Source)
           at javax.naming.InitialContext.<init>(Unknown Source)
           at javax.naming.directory.InitialDirContext.<init>(Unknown Source)
           at oracle.dss.persistence.persistencemanager.server.InitialPersistenceManager.<init>(InitialPersistenceManager.java:103)
           at oracle.dss.connection.server.drivers.persistence.PersistenceConnectionDriverImpl.connect(PersistenceConnectionDriverImpl.java:147)
           at oracle.dss.connection.server.ConnectionImpl.connect(ConnectionImpl.java:279)
           at oracle.dss.connection.client.Connection.connect(Connection.java:400)
           at oracle.dss.connection.client.Connection.connect(Connection.java:320)
           at oracle.dss.metadataManager.client.MetadataManager.setConnectionObjects(MetadataManager.java:3985)
           at oracle.dss.metadataManager.client.MetadataManager.attach(MetadataManager.java:852)
           at oracle.dss.metadataManager.client.MetadataManager.attach(MetadataManager.java:792)
           at oracle.dss.datautil.client.XMLManagerFactory.createQueryManager(XMLManagerFactory.java:187)
           at oracle.dss.datautil.client.ManagerFactoryImpl.lookupQueryManager(ManagerFactoryImpl.java:176)
           at oracle.dss.datautil.client.ManagerFactoryImpl.lookupMetadataManager(ManagerFactoryImpl.java:219)
           at oracle.dss.datautil.client.ManagerFactoryImpl.lookupManager(ManagerFactoryImpl.java:128)
           at mypackage2.BIApplication3.getMetadataManager(BIApplication3.java:395)
           at mypackage2.BIApplication3.openView(BIApplication3.java:659)
           at mypackage2.BIApplication3.jbInit(BIApplication3.java:302)
           at mypackage2.BIApplication3.<init>(BIApplication3.java:184)
           at mypackage2.BIApplication3.main(BIApplication3.java:1066)
      oracle.dss.security.BISecurityException: ORA-17002 Io exception: The Network Adapter could not establish the connection
      java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
           at oracle.dss.persistence.storagemanager.bi.mapping.ReposConnectionDriver.connect(ReposConnectionDriver.java:116)
           at oracle.dss.persistence.storagemanager.bi.mapping.JdbcAdapter.init(JdbcAdapter.java:537)
           at oracle.dss.persistence.storagemanager.bi.BIStorageManagerImpl.init(BIStorageManagerImpl.java:206)
           at java.lang.reflect.Method.invoke(Native Method)
           at oracle.dss.persistence.persistencemanager.server.PersistenceManagerSupport.loadStorageAdapterFromXML(PersistenceManagerSupport.java:399)
           at oracle.dss.persistence.persistencemanager.server.PersistenceManagerSupport.<init>(PersistenceManagerSupport.java:145)
           at oracle.dss.persistence.persistencemanager.server.PersistenceManagerImpl.<init>(PersistenceManagerImpl.java:99)
           at oracle.dss.persistence.persistencemanager.server.InitPersistenceManagerFactory.getInitialContext(InitPersistenceManagerFactory.java:29)
           at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
           at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
           at javax.naming.InitialContext.init(Unknown Source)
           at javax.naming.InitialContext.<init>(Unknown Source)
           at javax.naming.directory.InitialDirContext.<init>(Unknown Source)
           at oracle.dss.persistence.persistencemanager.server.InitialPersistenceManager.<init>(InitialPersistenceManager.java:103)
           at oracle.dss.connection.server.drivers.persistence.PersistenceConnectionDriverImpl.connect(PersistenceConnectionDriverImpl.java:147)
           at oracle.dss.connection.server.ConnectionImpl.connect(ConnectionImpl.java:279)
           at oracle.dss.connection.client.Connection.connect(Connection.java:400)
           at oracle.dss.connection.client.Connection.connect(Connection.java:320)
           at oracle.dss.metadataManager.client.MetadataManager.setConnectionObjects(MetadataManager.java:3985)
           at oracle.dss.metadataManager.client.MetadataManager.attach(MetadataManager.java:852)
           at oracle.dss.metadataManager.client.MetadataManager.attach(MetadataManager.java:792)
           at oracle.dss.datautil.client.XMLManagerFactory.createQueryManager(XMLManagerFactory.java:187)
           at oracle.dss.datautil.client.ManagerFactoryImpl.lookupQueryManager(ManagerFactoryImpl.java:176)
           at oracle.dss.datautil.client.ManagerFactoryImpl.lookupMetadataManager(ManagerFactoryImpl.java:219)
           at oracle.dss.datautil.client.ManagerFactoryImpl.lookupManager(ManagerFactoryImpl.java:128)
           at mypackage2.BIApplication3.getMetadataManager(BIApplication3.java:395)
           at mypackage2.BIApplication3.openView(BIApplication3.java:659)
           at mypackage2.BIApplication3.jbInit(BIApplication3.java:302)
           at mypackage2.BIApplication3.<init>(BIApplication3.java:184)
           at mypackage2.BIApplication3.main(BIApplication3.java:1066)
      java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
           at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
           at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
           at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
           at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:418)
           at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
           at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
           at java.sql.DriverManager.getConnection(Unknown Source)
           at java.sql.DriverManager.getConnection(Unknown Source)
           at oracle.dss.persistence.storagemanager.bi.mapping.ReposConnectionDriver.connect(ReposConnectionDriver.java:105)
           at oracle.dss.persistence.storagemanager.bi.mapping.JdbcAdapter.init(JdbcAdapter.java:537)
           at oracle.dss.persistence.storagemanager.bi.BIStorageManagerImpl.init(BIStorageManagerImpl.java:206)
           at java.lang.reflect.Method.invoke(Native Method)
           at oracle.dss.persistence.persistencemanager.server.PersistenceManagerSupport.loadStorageAdapterFromXML(PersistenceManagerSupport.java:399)
           at oracle.dss.persistence.persistencemanager.server.PersistenceManagerSupport.<init>(PersistenceManagerSupport.java:145)
           at oracle.dss.persistence.persistencemanager.server.PersistenceManagerImpl.<init>(PersistenceManagerImpl.java:99)
           at oracle.dss.persistence.persistencemanager.server.InitPersistenceManagerFactory.getInitialContext(InitPersistenceManagerFactory.java:29)
           at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
           at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
           at javax.naming.InitialContext.init(Unknown Source)
           at javax.naming.InitialContext.<init>(Unknown Source)
           at javax.naming.directory.InitialDirContext.<init>(Unknown Source)
           at oracle.dss.persistence.persistencemanager.server.InitialPersistenceManager.<init>(InitialPersistenceManager.java:103)
           at oracle.dss.connection.server.drivers.persistence.PersistenceConnectionDriverImpl.connect(PersistenceConnectionDriverImpl.java:147)
           at oracle.dss.connection.server.ConnectionImpl.connect(ConnectionImpl.java:279)
           at oracle.dss.connection.client.Connection.connect(Connection.java:400)
           at oracle.dss.connection.client.Connection.connect(Connection.java:320)
           at oracle.dss.metadataManager.client.MetadataManager.setConnectionObjects(MetadataManager.java:3985)
           at oracle.dss.metadataManager.client.MetadataManager.attach(MetadataManager.java:852)
           at oracle.dss.metadataManager.client.MetadataManager.attach(MetadataManager.java:792)
           at oracle.dss.datautil.client.XMLManagerFactory.createQueryManager(XMLManagerFactory.java:187)
           at oracle.dss.datautil.client.ManagerFactoryImpl.lookupQueryManager(ManagerFactoryImpl.java:176)
           at oracle.dss.datautil.client.ManagerFactoryImpl.lookupMetadataManager(ManagerFactoryImpl.java:219)
           at oracle.dss.datautil.client.ManagerFactoryImpl.lookupManager(ManagerFactoryImpl.java:128)
           at mypackage2.BIApplication3.getMetadataManager(BIApplication3.java:395)
           at mypackage2.BIApplication3.openView(BIApplication3.java:659)
           at mypackage2.BIApplication3.jbInit(BIApplication3.java:302)
           at mypackage2.BIApplication3.<init>(BIApplication3.java:184)
           at mypackage2.BIApplication3.main(BIApplication3.java:1066)


        • 1. Re: BIB-14122, ORA-17002 errors when trying to run deployed Java application
          152598
          Have you tried simply telneting or pinging the server from the remote location?
          Thanks
          • 2. Re: BIB-14122, ORA-17002 errors when trying to run deployed Java application
            420471
            That was it. I had to change my connections to use IP addresses instead of DNS names. Things are now working.
            • 3. Re: BIB-14122, ORA-17002 errors when trying to run deployed Java application
              414172
              Try to confirm the 2 Connection Authentication are correct:
              OLAP Data Source Connection & Catalog Connection. Please make sure you have made these 2 connection login id correct: use ip instead of hostname.
              • 4. Re: BIB-14122, ORA-17002 errors when trying to run deployed Java application
                691397
                We are having the same problems here at work, and
                problem is intermittent.

                The network guys think it may be related to
                TCP-IP keep alives being required on the
                JDBC connection (which uses TCP-IP
                underneath) , but not passing those keep
                alives through our firewall. So the connection
                is breaking.

                That is the theory ... at least ...

                Also, problem might be related to the initial
                query: if it is a simple query like:
                Select 1 from DUAL
                that executes quickly, so no problem is seen.
                But a query which takes a long time before
                the data starts flowing like:
                select * from YOURTABLE
                might be more problamatic ...

                My 2 cents...

                dbednar
                • 5. Re: BIB-14122, ORA-17002 errors when trying to run deployed Java application
                  750004
                  //**********************Error I'm getting**********************

                  17002java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

                  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
                  at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
                  at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3668)
                  at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:353)
                  at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:371)
                  at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:551)
                  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:351)
                  at java.sql.DriverManager.getConnection(DriverManager.java:525)
                  at java.sql.DriverManager.getConnection(DriverManager.java:171)
                  at org.apache.jsp.WEB_002dINF.jsp.index_jsp._jspService(index_jsp.java:76)
                  at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
                  at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
                  at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
                  at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                  at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                  at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
                  at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
                  at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
                  at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
                  at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:167)
                  at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:239)
                  at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1158)
                  at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900)
                  at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:808)
                  at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)
                  at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:431)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                  at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)
                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
                  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
                  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
                  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
                  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
                  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
                  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
                  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
                  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
                  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
                  at java.lang.Thread.run(Thread.java:595)
                  Error Is




                  Io exception: The Network Adapter could not establish the connection





                  ///***************Code **********************

                  <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
                  pageEncoding="ISO-8859-1"%>
                  <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

                  <%@page import="java.sql.SQLException"%><html>
                  <head>
                  <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
                  <title>Insert title here</title>
                  </head>
                  <body>
                  <%="hii" %>
                  <%@page import="java.sql.Connection,java.sql.DriverManager,java.sql.ResultSet,java.sql.Statement " %>


                  <%
                  try{
                  String driver = "oracle.jdbc.driver.OracleDriver";
                  Class.forName(driver);
                  Connection con = DriverManager.getConnection("jdbc:oracle:thin:@172.16.119.72:1521:new","system","Iwasoptra10*");
                  Statement st = con.createStatement();
                  st.executeUpdate("insert into forums values(7,'oye','Lptiiptn');");
                  st.close();
                  con.close();
                  }
                  catch(SQLException e){
                       e.printStackTrace();
                       System.out.print("Error Is\n\n\n\n\n"+e.getMessage()+"\n\n\n\n\n"+e.getErrorCode());}
                  %>

                  //************************************* Additional Info **************************

                  i gave following commands in sql and out puts are...

                  1) SQL> select instance_name from v$instance;

                  INSTANCE_NAME
                  ----------------
                  new


                  2) SQL> SELECT UTL_INADDR.get_host_address from dual;

                  GET_HOST_ADDRESS
                  ---------------------------------------------------
                  172.16.119.72


                  I even tried with server address localhost & 127.0.0.1 but it did not solve the purpose. Please help...please...
                  • 6. Re: BIB-14122, ORA-17002 errors when trying to run deployed Java application
                    750004
                    //***************************Problem solved*****************

                    1) goto control panel --> Administrative Tools --> services --> "OracleOraDB....Listner" and enable this listner process.... Hirray it's working...