java.sql.SQLException: Invalid character encountered in

Oracle Community | Vitaly | 6 years ago
  1. 0

    OIM 11g: SAP HRMS User Recon

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

    When the database gives a warning for Password expiring shortly (ORA-28002), I was unable to connect to the database. I got the below error message. This was while connecting to an Oracle database schema. Unexpected error running Liquibase: java.sql.SQLException: Invalid character encountered in SEVERE 1/27/16 8:31 PM: liquibase: java.sql.SQLException: Invalid character encountered in liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: java.sql.SQLException: Invalid character encountered in at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:143) at liquibase.integration.commandline.Main.doMigration(Main.java:915) at liquibase.integration.commandline.Main.run(Main.java:180) at liquibase.integration.commandline.Main.main(Main.java:99) Caused by: liquibase.exception.DatabaseException: java.sql.SQLException: Invalid character encountered in at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:247) at liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:151) at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:85) ... 3 more Caused by: java.sql.SQLException: Invalid character encountered in at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227) at oracle.sql.CharacterSet$2.onFailConversion(CharacterSet.java:2567) at oracle.sql.CharacterSet.convertUTFBytesToJavaChars(CharacterSet.java:1111) at oracle.sql.CharacterSet.convertUTFBytesToJavaChars(CharacterSet.java:923) at oracle.sql.CharacterSet.UTFToJavaChar(CharacterSet.java:825) at oracle.sql.CharacterSet.UTFToString(CharacterSet.java:789) at oracle.jdbc.driver.DBConversion.CharBytesToString(DBConversion.java:520) at oracle.jdbc.driver.T4CTTIoer.processWarning(T4CTTIoer.java:362) at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:636) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:348) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:563) at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:239) ... 5 more

    JIRA | 10 months ago | Varun Kalaiselvan
    liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: java.sql.SQLException: Invalid character encountered in
  3. 0

    When the database gives a warning for Password expiring shortly (ORA-28002), I was unable to connect to the database. I got the below error message. This was while connecting to an Oracle database schema. Unexpected error running Liquibase: java.sql.SQLException: Invalid character encountered in SEVERE 1/27/16 8:31 PM: liquibase: java.sql.SQLException: Invalid character encountered in liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: java.sql.SQLException: Invalid character encountered in at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:143) at liquibase.integration.commandline.Main.doMigration(Main.java:915) at liquibase.integration.commandline.Main.run(Main.java:180) at liquibase.integration.commandline.Main.main(Main.java:99) Caused by: liquibase.exception.DatabaseException: java.sql.SQLException: Invalid character encountered in at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:247) at liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:151) at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:85) ... 3 more Caused by: java.sql.SQLException: Invalid character encountered in at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227) at oracle.sql.CharacterSet$2.onFailConversion(CharacterSet.java:2567) at oracle.sql.CharacterSet.convertUTFBytesToJavaChars(CharacterSet.java:1111) at oracle.sql.CharacterSet.convertUTFBytesToJavaChars(CharacterSet.java:923) at oracle.sql.CharacterSet.UTFToJavaChar(CharacterSet.java:825) at oracle.sql.CharacterSet.UTFToString(CharacterSet.java:789) at oracle.jdbc.driver.DBConversion.CharBytesToString(DBConversion.java:520) at oracle.jdbc.driver.T4CTTIoer.processWarning(T4CTTIoer.java:362) at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:636) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:348) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:563) at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:239) ... 5 more

    JIRA | 10 months ago | Varun Kalaiselvan
    liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: java.sql.SQLException: Invalid character encountered in
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDBC failAL32UTF8Conv

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: Invalid character encountered in: failAL32UTF8Conv
  6. 0

    issues with jbdc logging on solaris and windows enviroment

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: Invalid character encountered in: failAL32UTF8Conv

    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.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