1 2 3 Previous Next 39 Replies Latest reply on Nov 19, 2015 4:52 PM by 3122638

    Work Repository is not log-in but can log-in to Master repository

    3122638

      Hi,

       

        Recently my database connection(master repository) schema password has expired . I regenerated the the password . When i tested  connection with master repository it's successfully connected but when i tested connection with work repository it's showing an  error sawing Invalid Repository Connection.


      Please help me in this Issue.



      ERROR:


      oracle.odi.core.config.WorkRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.

      Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

       

      at oracle.odi.core.repository.Repository.getWorkRepository(Repository.java:195)
      at oracle.odi.core.OdiInstance.createWorkRepository(OdiInstance.java:504)
      at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:581)
      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:288)
      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:2319)
      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:6288)
      at javax.swing.JComponent.processMouseEvent(JComponent.java:3268)
      at java.awt.Component.processEvent(Component.java:6053)
      at java.awt.Container.processEvent(Container.java:2042)
      at java.awt.Component.dispatchEventImpl(Component.java:4651)
        1 2 3 Previous Next