IJ22701: SINGLE QUOTE IN CFG FILE FAILS WHEN CONFIGURED FROM PORTAL CLIENT

IBM Tivoli Monitoring 6.3.0 Fix Pack 7 Service Pack 5 (6.3.0.7-TIV-ITM-SP0005)

APAR status

• Closed as program error.

Error description

• This problem occurs during remote configuration of cfg-based
  agents when using the Portal client, and any of the
  configuration parameters contains a single quote character.
  The *cfg file for an agent may not contain the single quote
  character if the agent will be configured remotely using the
  TEP client.
  Using tacmd to configure a cfg based agent will remove any
  single quote characters specified on the command line for the -p
  parameters.
  Attempting to remotely configure an agent which contains a
  single quote in the *cfg file using the Portal client will fail.
  This also includes AgentBuilder agents which contain a single
  quote in the *cfg file.
  
  You will see messages like the following in the Monitoring
  Server RAS1 log file:
  (5E33EFE2.000E-44:kdssqprs.c,835,"PRS_ParseSql") SqlParse
  rc=350 User= type=A 0x00550000 Net=
  (5E33EFE2.000F-44:kdspac1.c,2039,"VPA1_CreateRequest") SQL
  parse failed with return code 350
  (5E33EFE2.0010-44:kdysql.cpp,172,"executeSQL")
  SQL1_CreateRequest error=[350]
  (5E33EFE2.0011-44:kdyshdlib.cpp,2611,"insertKDYDYST_tmstmp") An
  error occurred, rc=[2], while inserting a record into the
  deploy configuration property table using sql={INSERT INTO
  KDY.KDYCPRM
  
  
  RECREATE INSTRUCTIONS:
  1) Install a TEMS and TEPS from the ITM base_* 063000700 media.
  2) Install the OS agent and r4 agent application support for
  TEPS and TEPW from the ITM base_* 063000700 media.
  
  3) Install the OS agent from the ITM agents 063000700 media.
  4) Install the r4 agent from the ITM agents 06300700 media
  5) Configure each installed component locally using the CLI
  command "itmcmd config"
  Configure the OS agent, r4 agent and TEPS to connect to
  this TEMS.
  
  6) Start the TEMS, TEPS and OS agent.
  7) Modify the *_r4_*.cfg file locally.
  Locate the entry for
  KQZ_SNMP_PLACEHOLDER_TEXT=
  
  Change this entry to
  KQZ_SNMP_PLACEHOLDER_TEXT='testtext'
  Save the modified cfg file.
  
  8) Start the r4 agent.
  9) Start a TEP web client connected to this TEPS
  10) Attempt to configure the r4 agent from the TEP client.
  11) ERROR - Notice the above mentioned error messages in the
  TEMS RAS1 log.
  The TEP will show this error:
  KFWITM290E An unexpected error occurred. The current task was
  cancelled.
  

Local fix

Problem summary

• When remotely configuring any agent, either using the Tivoli
  Enterprise Portal client, or the Command Line Interface command
  configuresystem, if the configuration text contains a single
  quote (') character, the configuaration of the agent will fail.
  
  
  Attempts to remotely configure an Agent where the configuration
  text contains a single quoter character will fail.
  

Problem conclusion

• If a single quote character is submitted by the user in their
  configuration parameters to remotely configure an Agent, then
  change the single quote to two single quotes such that the
  Monitoring Server's SQL parser will accept the input text.
  
  
  The fix for this APAR is contained in the following maintenance
  packages:
  
     | service pack | 6.3.0.7-TIV-ITM-SP0005
  

Temporary fix

• Configure the Agent locally
  

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

  TEMS

• Fixed component ID

  5724C04MS

Applicable component levels