3 Replies Latest reply on Feb 4, 2013 2:51 PM by vicky

    OIM Connector Installation Error. Cluster

    vicky
      Hi,

      We are facing issue when installing OIM connectors.

      Getting this error repeatedly if installation is done from 1st node.
      Error Adding Column: java.sql.SQLException: ORA-01430: column being added already exists in table[[

      [userId: xelsysadm] [ecid: 0000JmOMuXjC^qM_qLK6yY1H35uk00009Q,0] [APP: oim#11.1.1.3.0] ALTER TABLE USR MODIFY [[
      java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
           at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
           at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
           at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1074)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
           at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:2123)
           at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:2067)
           at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:306)
           at sun.reflect.GeneratedMethodAccessor1148.invoke(Unknown Source)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:230)
           at $Proxy412.executeUpdate(Unknown Source)

      If the connector is installed from second node, installation is succesful. Any pointers are appreciated.

      OIM Version: 11gR1

      Thanks

      Edited by: vicky on Feb 1, 2013 8:48 PM