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.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)

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
    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.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
  2. 0

    Using Non-APPS schema with Oracle Apps Adapter

    Oracle Community | 6 years ago | 818739
    java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_AQADM_SYS", line 5682 ORA-06512: at "SYS.DBMS_AQADM", line 314 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
  3. 0

    Target Recon Not Working

    Oracle Community | 6 years ago | 877241
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKACCOUNTCHGLOG", line 223 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 3161 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 89 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Invalid datatype while calling a procedure from java

    Stack Overflow | 3 years ago | user980956
    java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype</p> <pre><code>at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
  6. 0

    Unable to Start Oracle WebCenter Spaces

    Oracle Community | 7 years ago | user12303639
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
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. 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.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    2. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
    3. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
    4. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
    5. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
    6. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
    7. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1075)
    8. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
    9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
    10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3937)
    11. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9259)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535)
    12 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.execute
    1. weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
    1 frame
  4. oracle.iam.reconciliation
    ReconOperationsServiceImpl.ignoreEvent
    1. oracle.iam.reconciliation.dao.event.EventMgmtDao.ignoreEventAccountDataMatch(EventMgmtDao.java:519)
    2. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:421)
    3. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:351)
    3 frames
  5. Thor.API.Operations
    tcReconciliationOperationsIntfEJB.ignoreEventx
    1. Thor.API.Operations.tcReconciliationOperationsIntfEJB.ignoreEventx(Unknown Source)
    1 frame
  6. 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
  7. 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
  8. weblogic.ejb.container
    EnvironmentInterceptorCallbackImpl.callback
    1. weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
    1 frame
  9. 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
  10. Unknown
    $Proxy414.ignoreEventx
    1. $Proxy414.ignoreEventx(Unknown Source)
    1 frame
  11. Thor.API.Operations
    tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.__WL_invoke
    1. Thor.API.Operations.tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.__WL_invoke(Unknown Source)
    1 frame
  12. weblogic.ejb.container
    SessionRemoteMethodInvoker.invoke
    1. weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
    1 frame
  13. Thor.API.Operations
    tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.ignoreEventx
    1. Thor.API.Operations.tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.ignoreEventx(Unknown Source)
    1 frame
  14. 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
  15. weblogic.ejb.container
    RemoteBusinessIntfProxy.invoke
    1. weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
    1 frame
  16. Unknown
    $Proxy177.ignoreEventx
    1. $Proxy177.ignoreEventx(Unknown Source)
    1 frame
  17. 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
  18. 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
  19. Unknown
    $Proxy408.ignoreEventx
    1. $Proxy408.ignoreEventx(Unknown Source)
    1 frame
  20. Thor.API.Operations
    tcReconciliationOperationsIntfDelegate.ignoreEvent
    1. Thor.API.Operations.tcReconciliationOperationsIntfDelegate.ignoreEvent(Unknown Source)
    1 frame
  21. 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
  22. oracle.iam.scheduler
    TaskSupport.executeJob
    1. oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:145)
    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. oracle.iam.scheduler
    QuartzJob.execute
    1. oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:196)
    1 frame
  25. 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