IZ62720: AN ESCAPE SEQUENCE IN AN SQL QUERY WAS MALFORMED

7.3.0-TIV-NCOMNIbus-AIX-FP0006
7.3.0-TIV-NCOMNIbus-HPUX-FP0006
7.3.0-TIV-NCOMNIbus-ZLinux-FP0006
7.3.0-TIV-NCOMNIbus-Solaris-FP0006
7.3.0-TIV-NCOMNIbus-Windows-FP0006
7.3.0-TIV-NCOMNIbus-Linux-FP0006
7.3.0-TIV-NCOMNIbus-AIX-FP0015
7.3.0-TIV-NCOMNIbus-HPUX-FP0015
7.3.0-TIV-NCOMNIbus-HPUXIA-FP0015
7.3.0-TIV-NCOMNIbus-ZLinux-FP0015
7.3.0-TIV-NCOMNIbus-Linux-FP0015
7.3.0-TIV-NCOMNIbus-Solaris-FP0015
7.3.0-TIV-NCOMNIbus-Windows-FP0015
7.3.0-TIV-NCOMNIbus-AIX-FP0016
7.3.0-TIV-NCOMNIbus-HPUX-FP0016
7.3.0-TIV-NCOMNIbus-HPUXIA-FP0016
7.3.0-TIV-NCOMNIbus-ZLinux-FP0016
7.3.0-TIV-NCOMNIbus-Linux-FP0016
7.3.0-TIV-NCOMNIbus-Solaris-FP0016
7.3.0-TIV-NCOMNIbus-Windows-FP0016
7.3.0-TIV-NCOMNIbus-AIX-FP0017
7.3.0-TIV-NCOMNIbus-HPUXIA-FP0017
7.3.0-TIV-NCOMNIbus-ZLinux-FP0017
7.3.0-TIV-NCOMNIbus-Linux-FP0017
7.3.0-TIV-NCOMNIbus-Solaris-FP0017
7.3.0-TIV-NCOMNIbus-Windows-FP0017
Tivoli Netcool/OMNIbus 7.2.1 Fix Pack 7, 7.2.1-TIV-NCOMNIbus-FP0007
Tivoli Netcool/OMNIbus 7.3.0 Fix Pack 3, 7.3.0-TIV-NCOMNIbus-FP0003
Tivoli Netcool/OMNIbus 7.3.0 Fix Pack 4, 7.3.0-TIV-NCOMNIbus-FP0004
Tivoli Netcool/OMNIbus 7.3.0 Fix Pack 5, 7.3.0-TIV-NCOMNIbus-FP0005
Tivoli Netcool/OMNIbus 7.3.0 Fix Pack 13, 7.3.0-TIV-NCOMNIbus-FP0013
Tivoli Netcool/OMNIbus 7.2.1 Fix Pack 15, 7.2.1-TIV-NCOMNIbus-FP0015
Tivoli Netcool/OMNIbus 7.3.0 Fix Pack 14, 7.3.0-TIV-NCOMNIbus-FP0014
Tivoli Netcool/OMNIbus 7.3.0 Fix Pack 15, 7.3.0-TIV-NCOMNIbus-FP0015
Tivoli Netcool/OMNIbus 7.3.0 Fix Pack 16, 7.3.0-TIV-NCOMNIbus-FP0016
Tivoli Netcool/OMNIbus 7.2.1 Fix Pack 13, 7.2.1-TIV-NCOMNIbus-FP0013
Tivoli Netcool/OMNIbus 7.3.0 Fix Pack 17, 7.3.0-TIV-NCOMNIbus-FP0017

APAR status

• Closed as program error.

Error description

• --- Current behaviour ---
  
  When inserting certain SQL into the Object server via a client
  or the Administrator, an error is received:
  
  JZ0S8: An escape sequence in an SQL Query was malformed '{print
  $2 ":" $1}'.
  
  Failing SQL includes an escaped single quote followed by a curly
  bracket.
  
  
  --- Operating System ---
  ALL
  --- Omnibus version with Fixpack level ---
  Omnibus 7.2.1 FP2 and Omnibus 7.2.1 FP4
  
  --- Recreation Steps ---
  1. Log into Administrator to use SQL interface
  2. Insert event with
  insert into alerts.status (Identifier, Severity, Summary) values
  ('test1234', 4, 'test event')
  3. Attempt to update the event summary to the failing string:
  update alerts.status via 'test1234' set Summary = '\'{print $2
  ":" $1}\''
  4. Receive error
  JZ0S8: An escape sequence in an SQL Query was malformed '{print
  $2 ":" $1}'
  
  --- Log file excerpt ---
  Impact log error:
  Exception while executing database operation after trying twice.
  First exception: JZ0S8: An escape sequence in a SQL Query was
  malformed: '{print $2 ":" $1}'. Second exception: JZ0S8: An
  escape sequence in a SQL Query was malformed: '{print $2 ":"
  $1}'.  This may be caused by an invalid schema or an
  inaccessible database.  Please verify the actual database
  schema.
  
  Administrator error:
  
  JZ0S8: An escape sequence in an SQL Query was malformed '{print
  $2 ":" $1}'.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users of the Administrator GUI to enter SQL commands.
  ****************************************************************
  PROBLEM DESCRIPTION:
  An error occurs when using escape characters in SQL commands
  from the Administrator GUI.
  ****************************************************************
  RECOMMENDATION:
  Apply the maintenance packages listed in the Problem Conclusion.
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  packages:
  
       | fix pack | 7.2.1-TIV-NCOMNIbus-FP0006
       | fix pack | 7.3.0-TIV-NCOMNIbus-FP0001
  

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:

Fix information

• Fixed component name

  NETCOOL/OMNIBUS

• Fixed component ID

  5724O4800

Applicable component levels