oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis ORA-06512: at "PROD_OIM.XL_SP_RECON_ACCOUNT_DATA_MATCH", line 149 ORA-06512: at line 1at oracle.iam.reconciliation.dao.event.EventMgmtDao.ignoreEventAccountDataMatch(EventMgmtDao.java:527)

Oracle Community | LeylaDah | 5 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

    Error after applying the patch p12748351

    Oracle Community | 5 years ago | LeylaDah
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis ORA-06512: at "PROD_OIM.XL_SP_RECON_ACCOUNT_DATA_MATCH", line 149 ORA-06512: at line 1at oracle.iam.reconciliation.dao.event.EventMgmtDao.ignoreEventAccountDataMatch(EventMgmtDao.java:527)
  2. 0

    OIM 11g: SAP HRMS User Recon

    Oracle Community | 6 years ago | Vitaly
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLException: Invalid character encountered in
  3. 0

    EBS Trusted recon

    Oracle Community | 6 years ago | user651347
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis ORA-06512: at "IDMDEV_OIM.XL_SP_RECON_USR_DATA_MATCH", line 140 ORA-06512: at line 1at oracle.iam.reconciliation.dao.event.EventMgmtDao.ignoreEventUsrDataMatch(EventMgmtDao.java:449)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    OIM 11.1.1.5 Flat File Reconciliation :

    Oracle Community | 5 years ago | 813370
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00904: "USRMGR"."USR_LOGIN": invalid identifier ORA-06512: at "DEV_OIM.XL_SP_RECON_USR_MATCH", line 14 ORA-06512: at "DEV_OIM.XL_SP_RECON_USR_DATA_MATCH", line 31 ORA-06512: at line 1
  6. 0

    Error in configuration b/w database application table comnnector and OIMg11

    Oracle Community | 6 years ago | 858703
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification ORA-06512: at "DEV_OIM.XL_SP_RECON_USR_MATCH", line 14 ORA-06512: at "DEV_OIM.XL_SP_RECON_USR_DATA_MATCH", line 31 ORA-06512: at line 1at oracle.iam.reconciliation.dao.event.EventMgmtDao.ignoreEventUsrDataMatch(EventMgmtDao.java:449)

    Root Cause Analysis

    1. oracle.iam.platform.utils.SuperRuntimeException

      java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis ORA-06512: at "PROD_OIM.XL_SP_RECON_ACCOUNT_DATA_MATCH", line 149 ORA-06512: at line 1at oracle.iam.reconciliation.dao.event.EventMgmtDao.ignoreEventAccountDataMatch(EventMgmtDao.java:527)

      at oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent()
    2. oracle.iam.reconciliation
      ReconOperationsServiceImpl.ignoreEvent
      1. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:421)
      2. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:351)
      2 frames
    3. Thor.API.Operations
      tcReconciliationOperationsIntfEJB.ignoreEventx
      1. Thor.API.Operations.tcReconciliationOperationsIntfEJB.ignoreEventx(Unknown Source)
      1 frame
    4. 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
    5. com.bea.core
      MethodInvocationVisitorImpl.visit
      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)
      7. com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
      7 frames
    6. weblogic.ejb.container
      EnvironmentInterceptorCallbackImpl.callback
      1. weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
      1 frame
    7. com.bea.core
      JdkDynamicAopProxy.invoke
      1. com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
      2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      3. com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
      4. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      5. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
      6. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
      7. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      8. com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      8 frames
    8. Unknown
      $Proxy414.ignoreEventx
      1. $Proxy414.ignoreEventx(Unknown Source)
      1 frame
    9. Thor.API.Operations
      tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.__WL_invoke
      1. Thor.API.Operations.tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.__WL_invoke(Unknown Source)
      1 frame
    10. weblogic.ejb.container
      SessionRemoteMethodInvoker.invoke
      1. weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
      1 frame
    11. Thor.API.Operations
      tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.ignoreEventx
      1. Thor.API.Operations.tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.ignoreEventx(Unknown Source)
      1 frame
    12. 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
    13. weblogic.ejb.container
      RemoteBusinessIntfProxy.invoke
      1. weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
      1 frame
    14. Unknown
      $Proxy177.ignoreEventx
      1. $Proxy177.ignoreEventx(Unknown Source)
      1 frame
    15. 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
    16. 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
    17. Unknown
      $Proxy408.ignoreEventx
      1. $Proxy408.ignoreEventx(Unknown Source)
      1 frame
    18. Thor.API.Operations
      tcReconciliationOperationsIntfDelegate.ignoreEvent
      1. Thor.API.Operations.tcReconciliationOperationsIntfDelegate.ignoreEvent(Unknown Source)
      1 frame
    19. 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:384)
      6 frames
    20. oracle.iam.scheduler
      TaskSupport.executeJob
      1. oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:145)
      1 frame
    21. 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
    22. oracle.iam.scheduler
      QuartzJob.execute
      1. oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:196)
      1 frame
    23. 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