Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-2265

Got "ORA-01843: not a valid month" while trying to liveSync from Oracle database

    Details

    • Story Points:
      2
    • Sprint:
      Sprint 31, Sprint 36
    • Cases:
    • Support Ticket IDs:

      Description

      OpenIDM version "3.0.0" (revision: 3760) jenkins-OpenIDM 3.0.0 RC-6 null
      -> OpenIDM ready
      sync SELECT ATTRIBUTE1 , BRANCH_ID , AREA_CODE , POSITION_CNAME , EMPLOYEE_ENAME , DEPARTMENT_CNAME , EMPLOYEE_CNAME , DISPLAYNAME , QUIT_DATE , UID , update_date , EMPLOYEE_NO , employee_id , E_MAIL FROM opendj WHERE update_date > ? ORDER BY update_date ASC on ObjectClass: _ACCOUNT_ error
      ORA-01843: not a valid month

      -> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
      -> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      -> oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
      -> oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
      -> oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
      -> oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
      -> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
      -> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)
      -> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
      -> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
      -> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
      -> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)
      -> oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
      -> org.identityconnectors.databasetable.DatabaseTableConnector.sync(DatabaseTableConnector.java:609)
      -> org.identityconnectors.framework.impl.api.local.operations.SyncImpl.sync(SyncImpl.java:71)
      -> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      -> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      -> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      -> java.lang.reflect.Method.invoke(Method.java:597)
      -> org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:98)
      -> com.sun.proxy.$Proxy17.sync(Unknown Source)
      -> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      -> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      -> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      -> java.lang.reflect.Method.invoke(Method.java:597)
      -> org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:98)
      -> com.sun.proxy.$Proxy17.sync(Unknown Source)
      -> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      -> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      -> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      -> java.lang.reflect.Method.invoke(Method.java:597)
      -> org.identityconnectors.framework.impl.api.BufferedResultsProxy$BufferedResultsHandler.run(BufferedResultsProxy.java:158)

        Attachments

          Activity

            People

            • Assignee:
              jim.mitchener Jim Mitchener
              Reporter:
              cdlee cd lee [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: