IV93863: MYSQL FIELD WITH NULL VALUE CAUSES POLICY EXCEPTION:

7.1.0-TIV-NCI-ZLINUX-FP0011
7.1.0-TIV-NCI-WINDOWS-FP0011
7.1.0-TIV-NCI-SOLARIS-FP0011
7.1.0-TIV-NCI-LINUX-FP0011
7.1.0-TIV-NCI-AIX-FP0011
IBM Tivoli Netcool/Impact V7.1.0 Fix Pack 11(7.1.0-TIV-NCI-FP0011)
IBM Tivoli Netcool/Impact V7.1.0 Fix Pack 12 (7.1.0-TIV-NCI-FP0012)
IBM Tivoli Netcool/Impact V7.1.0 Fix Pack 13 (7.1.0-TIV-NCI-FP0013)

APAR status

• Closed as program error.

Error description

• APAR being requested: Unknown
  Product:              Impact
  Product Version:      7.1
  Fix/Build Level:      6
  :
  MySQL field with NULL value causes Policy exception:
  .
  Impact 7.1.0.6
  Mysql Database 5.6
  Mysql dsa lib file: mysql-connector-java-5.1.36-bin.jar
  If the destination table has a integer field (CLEAR_USR_ID in
  my case),
  setting the field to be updated with a NULL value causes the
  below
  error in impactserver.log (Line 90870) and the update to
  database doesn
  t happen (Lines 146574 to 146582 in VANCI01_policylogger.log).
  20 Jan 2017 15:58:54,012 ERROR [SQLOrgNode] Unhandled error in
  run
  java.lang.NumberFormatException: For input string: "NULL"
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Impact Users                                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Customer cannot write a NULL value to a database row from    *
  * their policy.                                                *
  * Impact will throw an error in impactserver.log:              *
  * 08 Feb 2017 14:36:39,293 WARN  [MySQLSQLHandler] Could not   *
  * parse: NULL usingyyyy-MM-dd HH:mm:ss.SSS. Trying with        *
  * yyyy-MM-dd                                                   *
  *     java.text.ParseException: Unparseable date: "NULL"       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Update toSqlType() to recognize instances of
  com.micromuse.common.util.Null and then convert them into
  regular null primitives.
  
  The fix for this APAR is contained in the following
  maintenance packages:
  | Fix Pack | 7.1.0-TIV-NCI-FP0011
  

Temporary fix

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

• UNKNOWN
  

Fix information

• Fixed component name

  NETCOOL/IMPACT

• Fixed component ID

  5724O59IS

Applicable component levels

• R710 PSY

     UP