com.kpn.crm.sso.oim.functional.command.BaseCommandException: com.kpn.crm.sso.oim.functional.store.DataStoreOperationException: com.ibatis.common.jdbc.exception.NestedSQLException: Could not start transaction. Cause: com.ibatis.sqlmap.engine.transaction.TransactionException: TransactionManager could not start a new transaction. A transaction is already started.

Oracle Community | S.K.N | 6 years ago
  1. 0

    OIM 10g - Reconciliation is not happening

    Oracle Community | 6 years ago | S.K.N
    com.kpn.crm.sso.oim.functional.command.BaseCommandException: com.kpn.crm.sso.oim.functional.store.DataStoreOperationException: com.ibatis.common.jdbc.exception.NestedSQLException: Could not start transaction. Cause: com.ibatis.sqlmap.engine.transaction.TransactionException: TransactionManager could not start a new transaction. A transaction is already started.

    Root Cause Analysis

    1. com.ibatis.sqlmap.engine.transaction.TransactionException

      TransactionManager could not start a new transaction. A transaction is already started.

      at com.ibatis.sqlmap.engine.transaction.TransactionManager.begin()
    2. com.ibatis.sqlmap
      SqlMapClientImpl.startTransaction
      1. com.ibatis.sqlmap.engine.transaction.TransactionManager.begin(TransactionManager.java:38)
      2. com.ibatis.sqlmap.engine.transaction.TransactionManager.begin(TransactionManager.java:31)
      3. com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.startTransaction(SqlMapExecutorDelegate.java:684)
      4. com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.startTransaction(SqlMapSessionImpl.java:164)
      5. com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.startTransaction(SqlMapClientImpl.java:140)
      5 frames
    3. com.kpn.crm
      SchedulerTask.execute
      1. com.kpn.crm.sso.oim.functional.command.audit.AuditTrail.add(AuditTrail.java:65)
      2. com.kpn.crm.sso.oim.functional.command.audit.CommandAuditor.handleMessage(CommandAuditor.java:83)
      3. com.kpn.crm.sso.oim.functional.command.audit.CommandAuditor.update(CommandAuditor.java:52)
      4. com.kpn.crm.sso.oim.functional.command.Multicaster.update(Multicaster.java:83)
      5. com.kpn.crm.sso.oim.functional.command.BaseCommand.execute(BaseCommand.java:112)
      6. com.kpn.crm.sso.oim.integration.vtaut.command.NewCustomerCommand.templateCommand(NewCustomerCommand.java:160)
      7. com.kpn.crm.sso.oim.integration.vtaut.command.NewCustomerCommand.checkUserExists(NewCustomerCommand.java:177)
      8. com.kpn.crm.sso.oim.integration.vtaut.command.NewCustomerCommand.executeCommand(NewCustomerCommand.java:56)
      9. com.kpn.crm.sso.oim.functional.command.BaseCommand.execute(BaseCommand.java:102)
      10. com.kpn.crm.sso.oim.integration.vtaut.recon.Reconciler.executeCommand(Reconciler.java:174)
      11. com.kpn.crm.sso.oim.integration.vtaut.recon.Reconciler.reconcile(Reconciler.java:102)
      12. com.kpn.crm.sso.oim.integration.vtaut.recon.task.SchedulerTask.execute(SchedulerTask.java:58)
      12 frames
    4. com.thortech.xl
      QuartzWrapper$TaskExecutionAction.run
      1. com.thortech.xl.scheduler.tasks.SchedulerBaseTask.run(Unknown Source)
      2. com.thortech.xl.scheduler.core.quartz.QuartzWrapper$TaskExecutionAction.run(Unknown Source)
      2 frames
    5. Thor.API.Security
      oracleLoginSession.runAs
      1. Thor.API.Security.LoginHandler.oracleLoginSession.runAs(Unknown Source)
      1 frame
    6. com.thortech.xl
      QuartzWrapper.execute
      1. com.thortech.xl.scheduler.core.quartz.QuartzWrapper.execute(Unknown Source)
      1 frame
    7. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:178)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:477)
      2 frames