com.sigmadynamics.cluster.persist.StorageException: 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 | 5 years ago
  1. 0

    Error while trying to replicate current environment

    Oracle Community | 5 years ago | 881978
    com.sigmadynamics.cluster.persist.StorageException: 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. com.sigmadynamics.cluster.persist.StorageException

      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 com.sigmadynamics.cluster.persist.TopologyDatabaseStorage._getAllFresherThan()
    2. com.sigmadynamics.cluster
      TopologyDatabaseStorage.getAllFresherThan
      1. com.sigmadynamics.cluster.persist.TopologyDatabaseStorage._getAllFresherThan(TopologyDatabaseStorage.java:200)
      2. com.sigmadynamics.cluster.persist.TopologyDatabaseStorage.getAllFresherThan(TopologyDatabaseStorage.java:166)
      2 frames
    3. 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
    4. 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
    5. com.sigmadynamics.server
      RTDServerTimerAndJobRunner$1$1.run
      1. com.sigmadynamics.server.kernel.RTDServerTimerAndJobRunner$1$1.run(RTDServerTimerAndJobRunner.java:131)
      1 frame