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 | 6 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 while trying to replicate current environment

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