RS02577: MYSQL DECISION SERVER SCRIPT FOR DECISION RUNNER NEEDS TO UPDATE PARAMETERS COLUMN TO LONGBLOB

Operational Decision Manager V8.7.1.2: Interim Fix 66
Operational Decison Manager z/OS 8.8.1.2 Fix Pack
Operational Decision Manager V8.8.1.2 Fix Pack
Operational Decision Manager V8.7.1.2: Interim Fix 72
Operational Decision Manager V8.9.0.2: Interim Fix 10

APAR status

• Closed as program error.

Error description

• When running ODM on MySQL
  [11/16/16 14:01:50:772 EST] 00000086 sql           W   An error
  occurred when executing the SQL query.
  com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too
  long for column 'parameters' at row 1
  Based on the scripts in the execution server directory,
  CREATE TABLE IF NOT EXISTS EXECUTIONINSTANCEDATA(
  jobexecid BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  jobinstanceid BIGINT,
  createtime TIMESTAMP,
  starttime TIMESTAMP,
  endtime TIMESTAMP,
  updatetime TIMESTAMP,
  parameters BLOB,
  batchstatus VARCHAR(512),
  exitstatus VARCHAR(512),
  CONSTRAINT JOBINST_JOBEXEC_FK FOREIGN KEY (jobinstanceid)
  REFERENCES JOBINSTANCEDATA (jobinstanceid)
  )ENGINE=InnoDB;
  Which based on the MySQL documentation is a 16 bit size (65k)
  as opposed to LONGBLOB which would be 32 bits (4GB)
  

Local fix

• Since the columns for Oracle, DB2 and SQL Server are all
  defined with columns that can be more than 1GB, would it make
  sense to have the client change the type to LONGBLOB.
  You can update the script to use a longblob instead.
  

Problem summary

• The table for decisionrunner can use data with a size more than
  65k which is too small for a BLOB. The decisionrunner mysql
  scrit needed to be updated  to use a LONGBLOB instead.
  

Problem conclusion

• The code is fixed.
  

Temporary fix

• Change the type manually from decisionrunner mysql script.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• 999
  

Fix information

• Fixed component name

  WDS FOR RULES

• Fixed component ID

  5725B6903

Applicable component levels

• R881 PSY

     UP