java.sql.SQLDataException: [FMWGEN][DB2 JDBC Driver][DB2]Character data, right truncation occurred; for example, an update or insert value is a string that is too long for the column, or a datetime value cannot be assigned to a host variable, because it is too small.

Oracle Community | 881978 | 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

    Error while trying to replicate current environment

    Oracle Community | 6 years ago | 881978
    java.sql.SQLDataException: [FMWGEN][DB2 JDBC Driver][DB2]Character data, right truncation occurred; for example, an update or insert value is a string that is too long for the column, or a datetime value cannot be assigned to a host variable, because it is too small.

    Root Cause Analysis

    1. java.sql.SQLDataException

      [FMWGEN][DB2 JDBC Driver][DB2]Character data, right truncation occurred; for example, an update or insert value is a string that is too long for the column, or a datetime value cannot be assigned to a host variable, because it is too small.

      at weblogic.jdbc.db2base.dda3.b()
    2. weblogic.jdbc.db2base
      dda2.a
      1. weblogic.jdbc.db2base.dda3.b(Unknown Source)
      2. weblogic.jdbc.db2base.dda3.a(Unknown Source)
      3. weblogic.jdbc.db2base.dda2.b(Unknown Source)
      4. weblogic.jdbc.db2base.dda2.a(Unknown Source)
      4 frames
    3. weblogic.jdbc.db2
      ddg.g
      1. weblogic.jdbc.db2.drda.ddn.d(Unknown Source)
      2. weblogic.jdbc.db2.drda.ddn.a(Unknown Source)
      3. weblogic.jdbc.db2.drda.ddp.a(Unknown Source)
      4. weblogic.jdbc.db2.drda.ddm.a(Unknown Source)
      5. weblogic.jdbc.db2.drda.ddn.c(Unknown Source)
      6. weblogic.jdbc.db2.ddg.g(Unknown Source)
      6 frames
    4. weblogic.jdbc.db2base
      ddb9.executeQuery
      1. weblogic.jdbc.db2base.ddbu.f(Unknown Source)
      2. weblogic.jdbc.db2base.dddd.y(Unknown Source)
      3. weblogic.jdbc.db2base.dddd.e(Unknown Source)
      4. weblogic.jdbc.db2base.dddd.u(Unknown Source)
      5. weblogic.jdbc.db2base.ddb9.executeQuery(Unknown Source)
      5 frames
    5. weblogic.jdbc.wrapper
      PreparedStatement.executeQuery
      1. weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
      1 frame
    6. com.sigmadynamics.cluster
      TopologyDatabaseStorage.getAllFresherThan
      1. com.sigmadynamics.cluster.persist.TopologyDatabaseStorage._getAllFresherThan(TopologyDatabaseStorage.java:180)
      2. com.sigmadynamics.cluster.persist.TopologyDatabaseStorage.getAllFresherThan(TopologyDatabaseStorage.java:166)
      2 frames
    7. com.sigmadynamics.server
      RTDServerTimerAndJobRunner$JobCatcher.run
      1. com.sigmadynamics.server.kernel.RemoteInstanceDatabaseStorage.getAllFresherThan(RemoteInstanceDatabaseStorage.java:84)
      2. com.sigmadynamics.server.SDCluster$ClusterCoordinator.removeStaleDSSessions(SDCluster.java:746)
      3. com.sigmadynamics.server.SDCluster$ClusterCoordinator.doNewCoordinator(SDCluster.java:699)
      4. com.sigmadynamics.server.SDCluster$ClusterCoordinator.doCoordinator(SDCluster.java:656)
      5. com.sigmadynamics.server.SDCluster$ClusterCoordinator.access$2(SDCluster.java:628)
      6. com.sigmadynamics.server.SDCluster.assumeCoordinatorDuties(SDCluster.java:459)
      7. com.sigmadynamics.server.SDCluster.checkCoordinatorNow(SDCluster.java:435)
      8. com.sigmadynamics.server.SDCluster.access$14(SDCluster.java:430)
      9. com.sigmadynamics.server.SDCluster$5.run(SDCluster.java:420)
      10. com.sigmadynamics.server.kernel.RTDServerTimerAndJobRunner$JobCatcher.run(RTDServerTimerAndJobRunner.java:181)
      10 frames
    8. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:897)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:919)
      3. java.lang.Thread.run(Thread.java:736)
      3 frames
    9. com.sigmadynamics.server
      RTDServerTimerAndJobRunner$1$1.run
      1. com.sigmadynamics.server.kernel.RTDServerTimerAndJobRunner$1$1.run(RTDServerTimerAndJobRunner.java:131)
      1 frame