java.sql.SQLException: Invalid character encountered in

Oracle Community | Vitaly | 6 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 11g: SAP HRMS User Recon

    Oracle Community | 6 years ago | Vitaly
    java.sql.SQLException: Invalid character encountered in

    Root Cause Analysis

    1. java.sql.SQLException

      Invalid character encountered in

      at oracle.jdbc.driver.SQLStateMapping.newSQLException()
    2. Oracle jdbc
      OracleCallableStatementWrapper.setObject
      1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
      2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
      3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
      4. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
      5. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
      6. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
      7. oracle.sql.CharacterSet.failUTFConversion(CharacterSet.java:2706)
      8. oracle.sql.CharacterSetAL32UTF8.toString(CharacterSetAL32UTF8.java:192)
      9. oracle.sql.CHAR.getString(CHAR.java:234)
      10. oracle.jdbc.oracore.OracleTypeCHAR.pickle81(OracleTypeCHAR.java:258)
      11. oracle.jdbc.oracore.OracleTypeCOLLECTION.pickle81(OracleTypeCOLLECTION.java:310)
      12. oracle.jdbc.oracore.OracleTypeADT.pickle81(OracleTypeADT.java:1637)
      13. oracle.jdbc.oracore.OracleTypeADT.linearize(OracleTypeADT.java:1256)
      14. oracle.sql.ArrayDescriptor.toBytes(ArrayDescriptor.java:683)
      15. oracle.sql.ARRAY.toBytes(ARRAY.java:632)
      16. oracle.jdbc.driver.OraclePreparedStatement.setArrayCritical(OraclePreparedStatement.java:5576)
      17. oracle.jdbc.driver.OraclePreparedStatement.setARRAYInternal(OraclePreparedStatement.java:5535)
      18. oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:7959)
      19. oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:7547)
      20. oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8212)
      21. oracle.jdbc.driver.OracleCallableStatement.setObject(OracleCallableStatement.java:5005)
      22. oracle.jdbc.driver.OracleCallableStatementWrapper.setObject(OracleCallableStatementWrapper.java:202)
      22 frames
    3. weblogic.jdbc.wrapper
      CallableStatement.setObject
      1. weblogic.jdbc.wrapper.CallableStatement.setObject(CallableStatement.java:964)
      1 frame
    4. oracle.iam.reconciliation
      ReconOperationsServiceImpl.ignoreEvent
      1. oracle.iam.reconciliation.dao.event.EventMgmtDao.ignoreEventUsrDataMatch(EventMgmtDao.java:438)
      2. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:383)
      3. oracle.iam.reconciliation.impl.ReconOperationsServiceImpl.ignoreEvent(ReconOperationsServiceImpl.java:346)
      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
      $Proxy327.ignoreEventx
      1. $Proxy327.ignoreEventx(Unknown Source)
      1 frame
    11. Thor.API.Operations
      tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.ignoreEventx
      1. Thor.API.Operations.tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.ignoreEventx(tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl.java:2494)
      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:84)
      1 frame
    14. Unknown
      $Proxy164.ignoreEventx
      1. $Proxy164.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
      $Proxy323.ignoreEventx
      1. $Proxy323.ignoreEventx(Unknown Source)
      1 frame
    18. Thor.API.Operations
      tcReconciliationOperationsIntfDelegate.ignoreEvent
      1. Thor.API.Operations.tcReconciliationOperationsIntfDelegate.ignoreEvent(Unknown Source)
      1 frame
    19. oracle.iam.connectors
      SAPHRMSUserRecon.execute
      1. oracle.iam.connectors.common.dao.OIMUtil.createTrustedReconEvent(Unknown Source)
      2. oracle.iam.connectors.sap.common.parser.HRMDAParser.reconcileUser(Unknown Source)
      3. oracle.iam.connectors.sap.common.parser.HRMDAParser.parse(Unknown Source)
      4. oracle.iam.connectors.sap.hrms.tasks.SAPHRMSUserRecon.execute(Unknown Source)
      4 frames
    20. com.thortech.xl
      SchedulerBaseTask.execute
      1. com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:384)
      1 frame
    21. oracle.iam.scheduler
      TaskSupport.executeJob
      1. oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:144)
      1 frame
    22. 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
    23. oracle.iam.scheduler
      QuartzJob.execute
      1. oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:164)
      1 frame
    24. 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