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
  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 | 5 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)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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