IJ49846: GENERATED SQL FOR ORGNODE UPDATES FAILS IF THE FIELD VALUES CONTAIN ? CHARACTER

APAR status

• Closed as program error.

Error description

• The problem is the event's Identifier contains a ? character
  because it has a URL with parameters, and the code it thinking
  they are values to be set.
  
  23 Jan 2024 10:53:08,886 ERROR [ObjectServerSQLHandler]
  pool-5-thread-3114sql/values mismatch in SQL UPDATE
  alerts.status SET imp_stat = ? WHERE Identifier='xx.xxx.xxx.xx
  FTPBatchFileOutBoundDeliveryXml_V1 S2PROD_V2
  DATAPOWER-NOTIFICATION-MIB 0x80e00625
  https://hostname:port/
  path?Param1=xxx] Conne
  \'https://hostname:port/path?Param2';
  23 Jan 2024 10:53:08,886 INFO  [ObjectServerSQLHandler]
  pool-5-thread-3114 Count Tokens 4
  23 Jan 2024 10:53:08,886 INFO  [ObjectServerSQLHandler]
  pool-5-thread-3114 Values Size 1
  23 Jan 2024 10:53:08,886 INFO  [ObjectServerSQLHandler]
  pool-5-thread-3114 'XXX@YYY.com,Event.M
  anagement.Secondary@YYY.com'getSqlEscapedStringValue v
  
  23 Jan 2024 10:53:08,886 ERROR [DynamicOrgNode] Unhandled error
  in run
  java.lang.IllegalArgumentException: sql/values mismatch
  at com.micromuse.response.event.ObjectServerSQLHandler.execute
  Statement(ObjectServerSQLHandler.java:303)~[nci.jar:?] at
  com.micromuse.response.event.ObjectServerSQLHandler.execute
  Statement(ObjectServerSQLHandler.java:280)~[nci.jar:?] at
  com.micromuse.response.event.ObjectServerSQLHandler.update(
  ObjectServerSQLHandler.java:223)~[nci.jar:?] at
  com.micromuse.response.dblayer.SQLOrgNode.updateBatch(SQLOr
  gNode.java:384)~[nci.jar:?] at
  com.micromuse.response.dblayer.DynamicOrgNode$BatchUpdater.
  run(DynamicOrgNode.java:857)~[nci.jar:?] at
  com.micromuse.response.common.parser.ImpactFunctionImpl.pro
  cessUpdateObjects(ImpactFunctionImpl.java:207)~[nci.jar:?]
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Impact Users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * GENERATED SQL FOR ORGNODE UPDATES FAILS IF THE FIELD VALUES  *
  * CONTAIN ? CHARACTER                                          *
  *                                                              *
  * ERROR [ActionTreeLogger] Error executing error handler for   *
  * policy: critical                                             *
  * com.micromuse.response.common.PolicyProcessingException:     *
  * sql/values mismatch in DefaultExceptionHandler               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  packages:
  |Fix Pack | 7.1.0-TIV-NCI-FP0033 |
  

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