org.springframework.dao.DataRetrievalFailureException: Error: A null sequence was returned from the database (could not get next com.vaau.rbacx.scheduling.domain.SchedulerExecutionLogRecordKey sequence).

Oracle Community | Pallavi Chaudhari | 4 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    OIM-OIA integration - Import Roles job

    Oracle Community | 4 years ago | Pallavi Chaudhari
    org.springframework.dao.DataRetrievalFailureException: Error: A null sequence was returned from the database (could not get next com.vaau.rbacx.scheduling.domain.SchedulerExecutionLogRecordKey sequence).

    Root Cause Analysis

    1. org.springframework.dao.DataRetrievalFailureException

      Error: A null sequence was returned from the database (could not get next com.vaau.rbacx.scheduling.domain.SchedulerExecutionLogRecordKey sequence).

      at com.vaau.rbacx.dao.ibatis.SqlMapSequenceDao.getNextCount()
    2. com.vaau.rbacx
      SqlMapSequenceDao.getNextCount
      1. com.vaau.rbacx.dao.ibatis.SqlMapSequenceDao.getNextCount(SqlMapSequenceDao.java:25)
      1 frame
    3. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor431.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    4. 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
    5. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
      1 frame
    6. 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
    7. Unknown
      $Proxy50.getNextCount
      1. $Proxy50.getNextCount(Unknown Source)
      1 frame
    8. com.vaau.rbacx
      VaauSchedulerEventListenerImpl.onApplicationEvent
      1. com.vaau.rbacx.service.impl.SequenceGeneratorServiceImpl.loadNext(SequenceGeneratorServiceImpl.java:117)
      2. com.vaau.rbacx.service.impl.SequenceGeneratorServiceImpl.getMemorySequence(SequenceGeneratorServiceImpl.java:98)
      3. com.vaau.rbacx.service.impl.SequenceGeneratorServiceImpl.getCount(SequenceGeneratorServiceImpl.java:57)
      4. com.vaau.rbacx.service.impl.SequenceGeneratorServiceImpl.getCount(SequenceGeneratorServiceImpl.java:42)
      5. com.vaau.rbacx.scheduling.dao.ibatis.SqlSchedulerExecutionLogRecordDao.insertSchedulerExecutionLogRecord(SqlSchedulerExecutionLogRecordDao.java:22)
      6. com.vaau.rbacx.scheduling.impl.VaauSchedulerEventListenerImpl.persistEvent(VaauSchedulerEventListenerImpl.java:61)
      7. com.vaau.rbacx.scheduling.impl.VaauSchedulerEventListenerImpl.onApplicationEvent(VaauSchedulerEventListenerImpl.java:48)
      7 frames
    9. Spring Context
      SimpleApplicationEventMulticaster$1.run
      1. org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:78)
      1 frame
    10. Spring Core
      SyncTaskExecutor.execute
      1. org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
      1 frame
    11. Spring Context
      AbstractApplicationContext.publishEvent
      1. org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:76)
      2. org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:274)
      2 frames
    12. com.vaau.rbacx
      QuartzJobListener.jobWasExecuted
      1. com.vaau.rbacx.scheduling.manager.providers.quartz.QuartzJobListener.jobWasExecuted(QuartzJobListener.java:65)
      1 frame
    13. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.QuartzScheduler.notifyJobListenersWasExecuted(QuartzScheduler.java:1910)
      2. org.quartz.core.JobRunShell.notifyJobListenersComplete(JobRunShell.java:355)
      3. org.quartz.core.JobRunShell.run(JobRunShell.java:226)
      4. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:534)
      4 frames