This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Jan 24, 2013 10:12 AM by Vik Kumar Go to original post RSS
  • 15. Re: unable to install odi on windows 7 64 bit
    Vik Kumar Explorer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    yeah i did from odi studio only freshly
  • 18. Re: unable to install odi on windows 7 64 bit
    Vik Kumar Explorer
    Currently Being Moderated
    thanks skipping repository option in the installation and later creating a master repository worked for me
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points