Checkpoint failed: Data too long for column job_data at row 1

Checkpoint failed: Data too long for column job_data at row 1

book

Article ID: KB0079147

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks 5.13.0

Description

Checkpoint failed
        at com.tibco.pe.core.CheckpointActivity.eval(Unknown Source)
        at com.tibco.pe.plugin.Activity.eval(Unknown Source)
        at com.tibco.pe.core.TaskImpl.eval(Unknown Source)
        at com.tibco.pe.core.Job.a(Unknown Source)
        at com.tibco.pe.core.Job.k(Unknown Source)
        at com.tibco.pe.core.JobDispatcher$JobCourier.a(Unknown Source)
        at com.tibco.pe.core.JobDispatcher$JobCourier.run(Unknown Source)
caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'job_data' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3968)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
        at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
        at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
        at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5098)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
        at com.tibco.pe.dm.DBJobDataManager.prepare(Unknown Source)
        at com.tibco.pe.core.JobPool.checkpointJob(Unknown Source)
        at com.tibco.pe.core.JobPool.checkpointJob(Unknown Source)
        at com.tibco.pe.core.CheckpointActivity.eval(Unknown Source)
        at com.tibco.pe.plugin.Activity.eval(Unknown Source)
        at com.tibco.pe.core.TaskImpl.eval(Unknown Source)
        at com.tibco.pe.core.Job.a(Unknown Source)
        at com.tibco.pe.core.Job.k(Unknown Source)
        at com.tibco.pe.core.JobDispatcher$JobCourier.a(Unknown Source)
        at com.tibco.pe.core.JobDispatcher$JobCourier.run(Unknown Source)

Resolution

Currently by default the column "job_data" is created as BLOB data type. So in order to support checkpoints and wait/notify activities within MYSQL with BW 5.13, we have officially released hotfix-07. So with hotfix-07, we gave a script to create the table that uses LONGBLOB data type.

Workaround: Please take a DB back-up and then you need to modify/update the data type of the column "job_data" from BLOB to LONGBLOB.

Issue/Introduction

Getting Checkpoint failed, caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'job_data' at row 1
Powered by Wolken Software