[OPENIDM-2265] Got "ORA-01843: not a valid month" while trying to liveSync from Oracle database Created: 24/Sep/14  Updated: 22/Jan/19  Resolved: 24/Mar/15

Status: Closed
Project: OpenIDM
Component/s: Module - OSGi Container / Framework integration
Affects Version/s: OpenIDM 3.0.0
Fix Version/s: OpenIDM 3.2.0

Type: Bug Priority: Major
Reporter: cd lee [X] (Inactive) Assignee: Jim Mitchener
Resolution: Cannot Reproduce Votes: 0
Labels: LEWIS
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Story Points: 2
Sprint: Sprint 31, Sprint 36
Cases: 11685
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)



 Comments   
Comment by Gael Allioux [ 16/Mar/15 ]

could that be linked?

https://bugster.forgerock.org/jira/browse/OPENICF-81

Comment by Jim Mitchener [ 24/Mar/15 ]

After much struggling with DatabaseTableConnector and Oracle I have been unable to reproduce this issue.

cd lee [X] If you are still experiencing this issue please try setting -Doracle.jdbc.J2EE13Compliant=true as Gael's link suggests and let us know how it goes.

Comment by Nena Hunt [ 08/Mar/16 ]

This error was duplicated in ticket #11685, and resolved when "allNative" was set to "true" in the databaseTableConnector provisioner config file.

Generated at Sun Sep 27 19:59:21 UTC 2020 using Jira 7.13.12#713012-sha1:6e07c38070d5191bbf7353952ed38f111754533a.