oracle.iam.reconciliation.exception.ReconciliationException: Exception occurred while inserting data into table RA_SWADADUSERTRUST1FD0BDE6 due to java.sql.SQLException: Year out of range.

Oracle Community | Srivatsa.kashyap | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    AD _ OIM 11gr2 PS1 Trusted reconciliation java.sql.SQLException: Year out of range for END Date

    Oracle Community | 3 years ago | Srivatsa.kashyap
    oracle.iam.reconciliation.exception.ReconciliationException: Exception occurred while inserting data into table RA_SWADADUSERTRUST1FD0BDE6 due to java.sql.SQLException: Year out of range.

    Root Cause Analysis

    1. oracle.iam.reconciliation.exception.ReconciliationException

      Exception occurred while inserting data into table RA_SWADADUSERTRUST1FD0BDE6 due to java.sql.SQLException: Year out of range.

      at oracle.iam.reconciliation.impl.ReconOperationsServiceImpl$1.process()
    2. oracle.iam.reconciliation
      ReconOperationsServiceImpl$1.process
      1. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl$1.process(ReconOperationsServiceImpl.java:431)
      2. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl$1.process(ReconOperationsServiceImpl.java:409)
      2 frames
    3. oracle.iam.platform
      OIMTransactionCallback.doInTransaction
      1. oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:13)
      2. oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:6)
      2 frames
    4. Spring Tx
      TransactionTemplate.execute
      1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
      1 frame
    5. oracle.iam.platform
      OIMTransactionManager.execute
      1. oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:22)
      1 frame
    6. oracle.iam.reconciliation
      ReconOperationsServiceImpl.createReconciliationEvent
      1. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.reconEvent(ReconOperationsServiceImpl.java:409)
      2. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.createReconciliationEvent(ReconOperationsServiceImpl.java:351)
      3. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.createReconciliationEvent(ReconOperationsServiceImpl.java:374)
      4. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.createReconciliationEvent(ReconOperationsServiceImpl.java:363)
      5. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.createReconciliationEvent(ReconOperationsServiceImpl.java:359)
      5 frames
    7. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    8. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    9. oracle.iam.platform
      DMSMethodInterceptor.invoke
      1. oracle.iam.platform.utils.DMSMethodInterceptor.invoke(DMSMethodInterceptor.java:25)
      1 frame
    10. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    11. com.sun.proxy
      $Proxy409.createReconciliationEvent
      1. com.sun.proxy.$Proxy409.createReconciliationEvent(Unknown Source)
      1 frame
    12. Thor.API.Operations
      tcReconciliationOperationsIntfEJB.createReconciliationEventx
      1. Thor.API.Operations.tcReconciliationOperationsIntfEJB.createReconciliationEventx(Unknown Source)
      1 frame
    13. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    14. com.bea.core
      ReflectiveMethodInvocation.proceed
      1. com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
      2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      4. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      6. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      6 frames
    15. com.oracle.pitchfork
      MethodInvocationVisitorImpl.visit
      1. com.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:34)
      1 frame
    16. weblogic.ejb.container
      EnvironmentInterceptorCallbackImpl.callback
      1. weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
      1 frame
    17. com.oracle.pitchfork
      EnvironmentInterceptor.invoke
      1. com.oracle.pitchfork.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:42)
      1 frame
    18. com.bea.core
      JdkDynamicAopProxy.invoke
      1. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      4. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      6. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      7. com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      7 frames
    19. com.sun.proxy
      $Proxy408.createReconciliationEventx
      1. com.sun.proxy.$Proxy408.createReconciliationEventx(Unknown Source)
      1 frame
    20. Thor.API.Operations
      tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.__WL_invoke
      1. Thor.API.Operations.tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.__WL_invoke(Unknown Source)
      1 frame
    21. weblogic.ejb.container
      SessionRemoteMethodInvoker.invoke
      1. weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
      1 frame
    22. Thor.API.Operations
      tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.createReconciliationEventx
      1. Thor.API.Operations.tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.createReconciliationEventx(Unknown Source)
      1 frame
    23. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    24. weblogic.ejb.container
      RemoteBusinessIntfProxy.invoke
      1. weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
      1 frame
    25. com.sun.proxy
      $Proxy206.createReconciliationEventx
      1. com.sun.proxy.$Proxy206.createReconciliationEventx(Unknown Source)
      1 frame
    26. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    27. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
      2 frames
    28. com.sun.proxy
      $Proxy404.createReconciliationEventx
      1. com.sun.proxy.$Proxy404.createReconciliationEventx(Unknown Source)
      1 frame
    29. Thor.API.Operations
      tcReconciliationOperationsIntfDelegate.createReconciliationEvent
      1. Thor.API.Operations.tcReconciliationOperationsIntfDelegate.createReconciliationEvent(Unknown Source)
      1 frame
    30. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    31. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    32. oracle.iam.platform
      DMSMethodInterceptor.invoke
      1. oracle.iam.platform.utils.DMSMethodInterceptor.invoke(DMSMethodInterceptor.java:25)
      1 frame
    33. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    34. com.sun.proxy
      $Proxy405.createReconciliationEvent
      1. com.sun.proxy.$Proxy405.createReconciliationEvent(Unknown Source)
      1 frame
    35. com.thortech.xl
      SchedulerBaseTask.execute
      1. com.thortech.xl.schedule.tasks.ActiveDirectoryReconTask.processUserChange(Unknown Source)
      2. com.thortech.xl.schedule.tasks.ActiveDirectoryReconTask.processBatch(Unknown Source)
      3. com.thortech.xl.integration.ActiveDirectory.tcADUtilLDAPController.searchResultPageEnum(Unknown Source)
      4. com.thortech.xl.schedule.tasks.ActiveDirectoryReconTask.performReconciliation(Unknown Source)
      5. com.thortech.xl.schedule.tasks.ActiveDirectoryReconTask.execute(Unknown Source)
      6. com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:383)
      6 frames
    36. oracle.iam.scheduler
      TaskSupport$1.processWithoutResult
      1. oracle.iam.scheduler.vo.TaskSupport.invokeExecute(TaskSupport.java:183)
      2. oracle.iam.scheduler.vo.TaskSupport.access$000(TaskSupport.java:40)
      3. oracle.iam.scheduler.vo.TaskSupport$1.processWithoutResult(TaskSupport.java:143)
      3 frames
    37. oracle.iam.platform
      OIMTransactionCallback.doInTransaction
      1. oracle.iam.platform.tx.OIMTransactionCallbackWithoutResult.process(OIMTransactionCallbackWithoutResult.java:9)
      2. oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:13)
      3. oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:6)
      3 frames
    38. Spring Tx
      TransactionTemplate.execute
      1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
      1 frame
    39. oracle.iam.platform
      OIMTransactionManager.execute
      1. oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:22)
      1 frame
    40. oracle.iam.scheduler
      TaskSupport.executeJob
      1. oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:125)
      1 frame
    41. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor1271.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    42. oracle.iam.scheduler
      QuartzJob$TaskExecutionAction.run
      1. oracle.iam.scheduler.impl.quartz.QuartzJob$TaskExecutionAction.run(QuartzJob.java:268)
      1 frame
    43. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    44. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    45. weblogic.security
      Security.runAs
      1. weblogic.security.Security.runAs(Security.java:41)
      1 frame
    46. Thor.API.Security
      weblogicLoginSession.runAs
      1. Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(weblogicLoginSession.java:52)
      1 frame
    47. oracle.iam.scheduler
      QuartzJob.execute
      1. oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:77)
      1 frame
    48. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
      2 frames