OA38974: TEMS CRASHES DURING STARTUP.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• TEMS fails during initialization when automatically starting a
  situat
  with malformed SQL.  The failue reported initially reported
  occurred
  the Windows platform but this failure can occur on all
  platforms.
  
  The failing thread call stack looks a follows:
  
    kdsmain!VPM11CAT+0x14b4
    kdsmain!VPM11CVP+0x78a
    kdsmain!VVW1CSV+0x3aa
    kdsmain!VRQ11CR+0xbf2
    kdsmain!VPA11_CreateRequest+0x322
    KDSBASE!sql1creq+0xb05
    kdsmain!RUL11CRQ+0x5e4
    kdsmain!RUL11DEC+0x41f
    kdsmain!RUL11CRN+0x255
    kdsmain!RUL11CRT+0xa0e
    kdsmain!SIT11CS+0x24a
    kdsmain!VST12SRT+0x1ce
    kdsmain!VPM11OUT+0xeeb
    kdsmain!VPM11CT+0x48c
    kdsmain!VVW1CSV+0x6ba
    kdsmain!VRQ11CR+0xbf2
    kdsmain!VPA11_CreateRequest+0x322
    KDSBASE!sql1creq+0xb05
    KSM!WsSqlDSRequest::WsSqlDSRequest+0x3c3
    KSM!WsSqlDSDB::CreateRequest+0x296
  
  RECREATE INSTRUCTIONS:
  The following SQL can be issued to cause the exception reported
  here:
  
    SELECT SITDB.RULENAME,
           SITDB.PREDICATE
    FROM   O4SRV.SITDB, O4SRV.LOCALTIME;
  

Local fix

• Modify the offending situation to not be automatically started.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All TEMS users.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: AGENT FAILS TO DISCARD EVENTS FOR A     *
  *                      STOPPED SITUATION.                      *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  Agent fails to discard events collected in autonomous mode
  for a stopped or modified situation. Situation events remain
  stored in persistent files on the agent if a situation is
  stopped while an agent is running in autonomous mode.
  Symptom: Presence of persistent files
  <hostname><pc>_autoattr.asa in the agent  directory when
  agent is connected to the monitoring server.
  

Problem conclusion

• Agent framework now discards events for stopped or modified
  situations.
  

Temporary fix

Comments

APAR Information

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

  IV04070

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

Modules/Macros

• KDSMAIN
  

Fix information

• Fixed component name

  MGMT SERVER DS

• Fixed component ID

  5608A2800

Applicable component levels

• R623 PSY UA64468

     UP12/03/09 P F203

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.