6 Replies Latest reply on Jul 14, 2014 1:40 PM by 2710776

    Create Domain failure installing ODI

    2710776

      I"m working on setting up Enterprise ODI and having issues.

       

      I've installed

      • Weblogic server and took the defaults
      • Infrastructure software installed
      • Repositories created (using SQL server for test environment)
      • Install ODI Enterprise taking the defaults
      • Creating Domain - Fails
        • When I get to the JDBC Component schema test I select the (3) I want that have repository / schemas configured.  I don't have any of the audits setup.  I updated those to point to the SQL server repositorys and the test successfully
        • The Audit ones fail on the second page but move on to the next screen
        • I selected  Administration Server
        • Selected the web servers IP address
        • The creation then fails with the errors below. 

      Any suggestions on locating some information on troubleshooting these errors,  I'm in a crunch time to get a server up and running for testing purposes.   I flatlined the install once already, reinstalled from scratch and it's still crashing on create domain. 

       

      I'm installing on a Windows 2008R2 server and SQL Server 2012 database.

       

      2014-07-11 20:30:56,524 INFO [1] com.oracle.cie.wizard.internal.wcf.WCFWrapper - Overriding task definition summary_gui

      2014-07-11 20:30:58,290 INFO [14] com.oracle.cie.domain.DomainLoader - domain C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain is not a valid BEA domain

      2014-07-11 20:30:58,290 INFO [14] com.oracle.cie.domain.DomainRegistryWrapper - need to initialize domainRegistrydocument object

      2014-07-11 20:30:58,290 INFO [14] com.oracle.cie.domain.DomainLoader - domain C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain is not a valid BEA domain

      2014-07-11 20:31:44,022 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.wls.core.app.server version 12.1.3.0.0 to oracle.wls.core.app.server_12.1.3.0.0/wlserver_ORACLE_HOME

      2014-07-11 20:31:44,038 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.wls.core.app.server version 12.1.3.0.0 to oracle.wls.core.app.server_12.1.3.0.0/wlserver_ORACLE_HOME

      2014-07-11 20:31:44,335 INFO [14] com.oracle.cie.domain.WLSTemplateBuilder - No config groups xml found in template

      2014-07-11 20:31:44,600 INFO [14] com.oracle.cie.domain.WLSTemplateBuilder - No config groups xml found in template

      2014-07-11 20:31:45,897 WARNING [14] com.oracle.cie.domain.AbstractTemplate - Could not find component name 'oracle.data_integrator.datasources' version 'null'

      2014-07-11 20:31:46,038 WARNING [14] com.oracle.cie.domain.AbstractTemplate - Could not find component name 'oracle.data_integrator.work.datasource' version 'null'

      2014-07-11 20:31:46,147 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.wsm.jrf version 12.1.3.0.0 to oracle.wsm.jrf_12.1.3.0.0/oracle_common_ORACLE_HOME

      2014-07-11 20:31:46,272 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.webservices.base version 12.1.3.0.0 to oracle.webservices.base_12.1.3.0.0/oracle_common_ORACLE_HOME

      2014-07-11 20:31:46,397 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.jrf.j2ee version 12.1.3.0.0 to oracle.jrf.j2ee_12.1.3.0.0/oracle_common_ORACLE_HOME

      2014-07-11 20:31:46,444 INFO [14] com.oracle.cie.domain.AbstractTemplate - Adding component reference

      2014-07-11 20:31:46,554 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.sdp.messaging version 12.1.3.0.0 to oracle.sdp.messaging_12.1.3.0.0/oracle_common_ORACLE_HOME

      2014-07-11 20:31:46,601 INFO [14] com.oracle.cie.domain.AbstractTemplate - Adding component reference

      2014-07-11 20:31:46,647 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.wsm.jrf version 12.1.3.0.0 to oracle.wsm.jrf_12.1.3.0.0/oracle_common_ORACLE_HOME

      2014-07-11 20:31:46,679 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.wls.core.app.server version 12.1.3.0.0 to oracle.wls.core.app.server_12.1.3.0.0/wlserver_ORACLE_HOME

      2014-07-11 20:31:46,804 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.jrf.dms version 12.1.3.0.0 to oracle.jrf.dms_12.1.3.0.0/oracle_common_ORACLE_HOME

      2014-07-11 20:31:46,929 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.jrf.infra.fmw.wls version 12.1.3.0.0 to oracle.jrf.infra.fmw.wls_12.1.3.0.0/oracle_common_ORACLE_HOME

      2014-07-11 20:31:47,022 INFO [14] com.oracle.cie.domain.AbstractTemplate - Adding component reference

      2014-07-11 20:31:47,101 WARNING [14] com.oracle.cie.domain.AbstractTemplate - Could not find component name 'oracle.data_integrator.base' version 'null'

      2014-07-11 20:31:47,413 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.wsm.console.core version 12.1.3.0.0 to oracle.wsm.console.core_12.1.3.0.0/oracle_common_ORACLE_HOME

      2014-07-11 20:31:47,601 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.wsm.jrf version 12.1.3.0.0 to oracle.wsm.jrf_12.1.3.0.0/oracle_common_ORACLE_HOME

      2014-07-11 20:31:47,882 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.webcenter.skin version 12.1.3.0.0 to oracle.webcenter.skin_12.1.3.0.0/oracle_common_ORACLE_HOME

      2014-07-11 20:31:48,101 WARNING [14] com.oracle.cie.domain.AbstractTemplate - Could not find component name 'oracle.data_integrator.standalone_agent' version 'null'

      2014-07-11 20:31:48,444 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.webcenter.pageeditor version 12.1.3.0.0 to oracle.webcenter.pageeditor_12.1.3.0.0/oracle_common_ORACLE_HOME

      2014-07-11 20:31:48,726 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.sysman.fmw.as version 12.1.3.0.0 to oracle.sysman.fmw.as_12.1.3.0.0/em_ORACLE_HOME

      2014-07-11 20:31:48,944 INFO [14] com.oracle.cie.domain.AbstractTemplate - Adding component reference

      2014-07-11 20:31:49,147 WARNING [14] com.oracle.cie.domain.AbstractTemplate - Could not find component name 'oracle.data_integrator.agentlibraries' version 'null'

      2014-07-11 20:31:49,866 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.sdp.messaging version 12.1.3.0.0 to oracle.sdp.messaging_12.1.3.0.0/oracle_common_ORACLE_HOME

      2014-07-11 20:31:50,210 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.sdp.messaging version 12.1.3.0.0 to oracle.sdp.messaging_12.1.3.0.0/oracle_common_ORACLE_HOME

      2014-07-11 20:31:50,444 WARNING [14] com.oracle.cie.domain.AbstractTemplate - Could not find component name 'oracle.data_integrator.repository_explorer' version 'null'

      2014-07-11 20:31:50,819 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.sysman.fmw.core version 12.1.3.0.0 to oracle.sysman.fmw.core_12.1.3.0.0/em_ORACLE_HOME

      2014-07-11 20:31:51,272 INFO [14] com.oracle.cie.domain.AbstractTemplate - Setting symbol for component oracle.sysman.plugin.ai.odi version 12.1.3.0.0 to oracle.sysman.plugin.ai.odi_12.1.3.0.0/em_ORACLE_HOME

      2014-07-11 20:39:56,875 WARNING [14] com.oracle.cie.domain.gui.panel.ConfigVPanel - Ajusted ordering index 6 is out of bounds.

      2014-07-11 20:39:56,875 WARNING [14] com.oracle.cie.domain.gui.panel.ConfigVPanel - Ajusted ordering index 7 is out of bounds.

      2014-07-11 20:47:08,636 INFO [68] oracle.security.jps.util.JpsUtil - JpsUtil: isAuditDisabled set to true

      2014-07-11 20:47:12,917 INFO [68] org.hibernate.validator.util.Version - Hibernate Validator 12.1.3.0.0

      2014-07-11 20:47:12,917 INFO [68] org.hibernate.validator.engine.resolver.DefaultTraversableResolver - Instantiated an instance of org.hibernate.validator.engine.resolver.JPATraversableResolver.

      2014-07-11 20:47:13,542 WARNING [68] oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl - Exception oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

      Internal Exception: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

      Error Code: 17002

      2014-07-11 20:47:13,542 SEVERE [68] oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl - Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

      Internal Exception: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

      Error Code: 17002

      2014-07-11 20:47:13,542 SEVERE [68] oracle.security.opss.tools.lifecycle.cie.OpssSecurityConfiguration - Error while processing initializeSubsystem. Exception oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

      Internal Exception: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

      Error Code: 17002

      2014-07-11 20:47:13,542 SEVERE [68] com.oracle.cie.domain.DomainGenerator - Domain Creation Failed!

       

      Domain Location: C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain

       

      Reason: oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

      Internal Exception: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

      Error Code: 17002

       

      Exception:

       

      • oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

      Internal Exception: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

      Error Code: 17002

       

      1. a. com.oracle.cie.domain.security.external.ConfigSecurityException: oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

      Internal Exception: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

      Error Code: 17002

      at oracle.security.opss.tools.lifecycle.cie.OpssSecurityConfiguration.initializeSubsystem(OpssSecurityConfiguration.java:141)

      at com.oracle.cie.domain.DomainGenerator.run(DomainGenerator.java:323)

      at java.lang.Thread.run(Thread.java:745)

      Caused by: oracle.security.opss.tools.lifecycle.LifecycleException: Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

      Internal Exception: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

      Error Code: 17002

      at oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl.configureDBSecurityStore(OpssDomainConfigImpl.java:404)

      at oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl.initializeSubsystem(OpssDomainConfigImpl.java:194)

      at oracle.security.opss.tools.lifecycle.cie.OpssSecurityConfiguration.initializeSubsystem(OpssSecurityConfiguration.java:138)

      ... 2 more

      Caused by: oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

      Internal Exception: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

      Error Code: 17002

      at oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl.checkIfFarmExists(OpssDomainConfigImpl.java:814)

      at oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl.configureDBSecurityStore(OpssDomainConfigImpl.java:389)

      ... 4 more

      Caused by: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

      Internal Exception: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

      Error Code: 17002

      at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.processJPAException(JpsDBDataManager.java:2180)

      at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.init(JpsDBDataManager.java:1028)

      at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.beginTransaction(JpsDBDataManager.java:1538)

      at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.beginTransaction(JpsDBDataManager.java:1534)

      at oracle.security.jps.internal.common.rdbms.util.JpsDbBootstrapImpl.<init>(JpsDbBootstrapImpl.java:167)

      at oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl.checkIfFarmExists(OpssDomainConfigImpl.java:785)

      ... 5 more

      Caused by: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

      Internal Exception: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

      Error Code: 17002

      at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:766)

      at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:204)

      at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:304)

      at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:336)

      at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:302)

      at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.getVersion(JpsDBDataManager.java:1100)

      at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.getEMFAndSubject(JpsDBDataManager.java:1203)

      at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.init(JpsDBDataManager.java:980)

      ... 9 more

      Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

      Internal Exception: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

      Error Code: 17002

      at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)

      at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326)

      at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138)

      at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)

      at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:204)

      at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:741)

      at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:239)

      at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:685)

      ... 16 more

      Caused by: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743)

      at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)

      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)

      at java.sql.DriverManager.getConnection(DriverManager.java:571)

      at java.sql.DriverManager.getConnection(DriverManager.java:187)

      at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98)

      ... 21 more

      Caused by: oracle.net.ns.NetException: Got minus one from a read call

      at oracle.net.ns.Packet.receive(Packet.java:314)

      at oracle.net.ns.NSProtocolStream.negotiateConnection(NSProtocolStream.java:159)

      at oracle.net.ns.NSProtocol.connect(NSProtocol.java:264)

      at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1452)

      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:496)

      ... 27 more

      2014-07-11 20:47:52,056 INFO [14] com.oracle.cie.common.util.BrowserLauncher - jdk used is : 1.7.0_60

        • 1. Re: Create Domain failure installing ODI
          2655429

          Hey,

           

          The below exception points that either the ports to the database from the machine (where you are trying to install) is not open or the db is not up and running.

          Try to ping/telnet your database from the machine where you are doing the install and see if it connects.

           

          Internal Exception: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

          Error Code: 17002

          2014-07-11 20:47:13,542 SEVERE [68] oracle.security.opss.tools.lifecycle.OpssDomainConfigImpl - Error during configuring DB security store. Exception oracle.security.opss.tools.lifecycle.LifecycleException: oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException

          Internal Exception: java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

          Error Code: 17002


          Thanks

          • 2. Re: Create Domain failure installing ODI
            KKT

            May be One of the reason could be Oracle Database default Number of processes could be too low for your environment.  One way to check this is to issue this SQL command:

             

             

             

            SQL> show parameter processes

             

             

             

            default is when you install 150 , change this to 300 and see if it works.

             

             

            SQL> alter system set processes=300 scope=spfile;

             

             

            Thanks,

            ~KKT~

            • 3. Re: Create Domain failure installing ODI
              Sh!va

              I think backend is SQL server, Can you check if server collation is set correctly ??

               

              Cheers!

               

              Sh!va

              • 4. Re: Create Domain failure installing ODI
                2710776
                • The SQL Collation is set to:  SQL_Latin1_General_CP1_CI_AS 

                 

                • I can telnet to the database server,  I created the repository for ODI from the same application server as i'm running create domain script and the same database server. That was able to communicate without issue to the database server. 

                 

                • This is running against a SQL 2012 database not Oracle. 
                • 5. Re: Create Domain failure installing ODI
                  Phanikanth

                  Hi

                   

                  Did you configured weblogic multiple times ?

                   

                  Regards,

                  Phanikanth

                  • 6. Re: Create Domain failure installing ODI
                    2710776

                    I'm not sure I entirely understand your question about configuring multiple times.   

                    When I did the initial installation of Weblogic, I skipped creating the domain as suggested by a blog I was following to setup ODI 12c.   Technically I have run the configuration multiple times, however it fails every time unable to create the domain.  So I have yet to run it successfully