1 2 Previous Next 18 Replies Latest reply: Jan 24, 2013 12:12 PM by Vik Kumar-Oracle Go to original post RSS
      • 15. Re: unable to install odi on windows 7 64 bit
        Vik Kumar-Oracle
        Ok so i did the installation finally. now on lauching odi studio i see the option to create repository which i did and now when i try to connect i get following exception

        oracle.odi.core.config.NotMasterRepositorySchemaException: ODI-10147: Repository type mismatches.     
        Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Invalid connection validation SQL statement
             at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:90)
             at oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:491)
             at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:544)
             at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:521)
             at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.testConnection(SnpsDialogLoginDetail.java:755)
             at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.access$4(SnpsDialogLoginDetail.java:743)
             at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail$2.performAction(SnpsDialogLoginDetail.java:287)
             at oracle.odi.ui.framework.event.OdiActionListener.actionPerformed(OdiActionListener.java:69)
             at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
             at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
             at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
             at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
             at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
             at java.awt.Component.processMouseEvent(Component.java:6297)
             at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)
             at java.awt.Component.processEvent(Component.java:6062)
             at java.awt.Container.processEvent(Container.java:2039)
             at java.awt.Component.dispatchEventImpl(Component.java:4660)
             at java.awt.Container.dispatchEventImpl(Container.java:2097)
             at java.awt.Component.dispatchEvent(Component.java:4488)
             at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
             at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
             at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
             at java.awt.Container.dispatchEventImpl(Container.java:2083)
             at java.awt.Window.dispatchEventImpl(Window.java:2489)
             at java.awt.Component.dispatchEvent(Component.java:4488)
             at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:668)
             at java.awt.EventQueue.access$400(EventQueue.java:81)
             at java.awt.EventQueue$2.run(EventQueue.java:627)
             at java.awt.EventQueue$2.run(EventQueue.java:625)
             at java.security.AccessController.doPrivileged(Native Method)
             at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
             at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
             at java.awt.EventQueue$3.run(EventQueue.java:641)
             at java.awt.EventQueue$3.run(EventQueue.java:639)
             at java.security.AccessController.doPrivileged(Native Method)
             at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
             at java.awt.EventQueue.dispatchEvent(EventQueue.java:638)
             at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
             at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
             at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
             at java.awt.Dialog$1.run(Dialog.java:1047)
             at java.awt.Dialog$3.run(Dialog.java:1099)
             at java.security.AccessController.doPrivileged(Native Method)
             at java.awt.Dialog.show(Dialog.java:1097)
             at java.awt.Component.show(Component.java:1591)
             at java.awt.Component.setVisible(Component.java:1543)
             at java.awt.Window.setVisible(Window.java:843)
             at java.awt.Dialog.setVisible(Dialog.java:987)
             at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:395)
             at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:356)
             at oracle.odi.ui.framework.adapter.DefaultAdapter.displayDialog(DefaultAdapter.java:242)
             at oracle.odi.ui.framework.UIFramework.displayDialog(UIFramework.java:88)
             at oracle.odi.ui.LoginFactory.createNewLogin(LoginFactory.java:259)
             at com.sunopsis.graphical.dialog.SnpsDialogLogin$4.performAction(SnpsDialogLogin.java:214)
             at oracle.odi.ui.framework.event.OdiActionListener.actionPerformed(OdiActionListener.java:69)
             at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
             at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
             at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
             at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
             at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
             at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
             at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
             at java.awt.Component.processMouseEvent(Component.java:6297)
             at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)
             at java.awt.Component.processEvent(Component.java:6062)
             at java.awt.Container.processEvent(Container.java:2039)
             at java.awt.Component.dispatchEventImpl(Component.java:4660)
             at java.awt.Container.dispatchEventImpl(Container.java:2097)
             at java.awt.Component.dispatchEvent(Component.java:4488)
             at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
             at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
             at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
             at java.awt.Container.dispatchEventImpl(Container.java:2083)
             at java.awt.Window.dispatchEventImpl(Window.java:2489)
             at java.awt.Component.dispatchEvent(Component.java:4488)
             at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:668)
             at java.awt.EventQueue.access$400(EventQueue.java:81)
             at java.awt.EventQueue$2.run(EventQueue.java:627)
             at java.awt.EventQueue$2.run(EventQueue.java:625)
             at java.security.AccessController.doPrivileged(Native Method)
             at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
             at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
             at java.awt.EventQueue$3.run(EventQueue.java:641)
             at java.awt.EventQueue$3.run(EventQueue.java:639)
             at java.security.AccessController.doPrivileged(Native Method)
             at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
             at java.awt.EventQueue.dispatchEvent(EventQueue.java:638)
             at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
             at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
             at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
             at java.awt.Dialog$1.run(Dialog.java:1047)
             at java.awt.Dialog$3.run(Dialog.java:1099)
             at java.security.AccessController.doPrivileged(Native Method)
             at java.awt.Dialog.show(Dialog.java:1097)
             at java.awt.Component.show(Component.java:1591)
             at java.awt.Component.setVisible(Component.java:1543)
             at java.awt.Window.setVisible(Window.java:843)
             at java.awt.Dialog.setVisible(Dialog.java:987)
             at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:395)
             at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:356)
             at oracle.odi.ui.framework.adapter.DefaultAdapter.displayDialog(DefaultAdapter.java:242)
             at oracle.odi.ui.framework.UIFramework.displayDialog(UIFramework.java:88)
             at oracle.odi.ui.OdiConnectController.handleEvent(OdiConnectController.java:113)
             at oracle.ide.controller.IdeAction.performAction(IdeAction.java:529)
             at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:897)
             at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:501)
             at oracle.odi.ui.docking.AbstractOdiDockableWindow$1.actionPerformed(AbstractOdiDockableWindow.java:203)
             at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
             at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
             at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
             at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
             at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
             at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
             at java.awt.Component.processMouseEvent(Component.java:6297)
             at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)
             at java.awt.Component.processEvent(Component.java:6062)
             at java.awt.Container.processEvent(Container.java:2039)
             at java.awt.Component.dispatchEventImpl(Component.java:4660)
             at java.awt.Container.dispatchEventImpl(Container.java:2097)
             at java.awt.Component.dispatchEvent(Component.java:4488)
             at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
             at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
             at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
             at java.awt.Container.dispatchEventImpl(Container.java:2083)
             at java.awt.Window.dispatchEventImpl(Window.java:2489)
             at java.awt.Component.dispatchEvent(Component.java:4488)
             at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:668)
             at java.awt.EventQueue.access$400(EventQueue.java:81)
             at java.awt.EventQueue$2.run(EventQueue.java:627)
             at java.awt.EventQueue$2.run(EventQueue.java:625)
             at java.security.AccessController.doPrivileged(Native Method)
             at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
             at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
             at java.awt.EventQueue$3.run(EventQueue.java:641)
             at java.awt.EventQueue$3.run(EventQueue.java:639)
             at java.security.AccessController.doPrivileged(Native Method)
             at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
             at java.awt.EventQueue.dispatchEvent(EventQueue.java:638)
             at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
             at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
             at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
             at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
             at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
             at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
        Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Invalid connection validation SQL statement
             at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
             at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:524)
             at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:588)
             at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:613)
             at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:645)
             at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:111)
             at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:121)
             at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:136)
             at oracle.odi.core.repository.support.RepositoryUtils$RepositoryInfoSource.loadRepositoryInfo(RepositoryUtils.java:182)
             at oracle.odi.core.repository.support.RepositoryUtils.loadMasterRepositoryInfo(RepositoryUtils.java:376)
             at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:78)
             ... 144 more
        Caused by: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Invalid connection validation SQL statement
             at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:133)
             at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:62)
             at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
             at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
             ... 154 more
        Caused by: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Invalid connection validation SQL statement
             at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488)
             at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163)
             at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:654)
             at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:922)
             at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:873)
             at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:863)
             at sun.reflect.GeneratedMethodAccessor451.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:597)
             at oracle.odi.core.datasource.support.RuntimeClassLoaderDataSourceCreator$DataSourceInvocationHandler.invoke(RuntimeClassLoaderDataSourceCreator.java:48)
             at $Proxy0.getConnection(Unknown Source)
             at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:217)
             at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
             at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
             at java.util.concurrent.FutureTask.run(FutureTask.java:138)
             at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
             at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
             at java.lang.Thread.run(Thread.java:662)
        Caused by: oracle.ucp.UniversalConnectionPoolException: Invalid connection validation SQL statement
             at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:368)
             at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336)
             at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:350)
             at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:196)
             at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:648)
             ... 15 more
        • 16. Re: unable to install odi on windows 7 64 bit
          Bhabani Ranjan
          I believe you are using the repository created by the RCU.
          why dont you create the repository via odistudio. No need to bother about RCU.

          Please ping me to discuss more on this.
          • 17. Re: unable to install odi on windows 7 64 bit
            Vik Kumar-Oracle
            yeah i did from odi studio only freshly
            • 18. Re: unable to install odi on windows 7 64 bit
              Vik Kumar-Oracle
              thanks skipping repository option in the installation and later creating a master repository worked for me
              1 2 Previous Next