IZ59712: KOQCOLL.EXE CRASHES AFTER MICROSOFT SQL SERVER STOPS.

IBM Tivoli Monitoring for Microsoft(R)App: SQL Server 6.2.1.1-TIV-ITM_SQL-IF0005

APAR status

• Closed as program error.

Error description

• Severity: 2
  Approver: Steven Barnett
  Compid: 5724B96MO
  Abstract: koqcoll.exe crashes after Microsoft SQL Server stops.
  
  Environment:
  All windows versions
  All Microsoft SQL Server versions.
  
  Microsoft SQL Server Agent 6.2.1.
  
  Problem Description: SQL Server agent does not show data on
  portal after MSSQL Server Stops due to 'Shared Memory Error'.
  
  korcoll.exe goes down with the Application Error in Application
  Event Log:
  ---
  2009/08/21 15:20:10 Application Error Error (100) 1000 N/A
  KV031030 Faulting Application koqcoll.exe, Versoin 0.0.0.0,
  Faulting Module koqsqld.dll, Version 0.0.0.0, fault address
  0x0001dee1
  ----
  
  Here is the output in C:\WINDOWS\System32\KOQCOLL.ras
  ---
  Exception 0xC0000005 (ACCESS_VIOLATION)
  
         Computer: KV031030                   Windows: 5.2-SP2
     Current Time: 2009/08/21, 15:20:09    Start Time: 2009/08/21,
  15:15:26
    Current Clock: 0x4A8E3C99             Start Clock: 0x4A8E3B7E
       Process ID: 0x00000D64               Thread ID: 0x000014D0
          Program: C:\Tivoli\itm\TMAITM6\KOQCOLL.EXE
           Origin: koqsqld.dll<>execSqlRequest+0x1CE81
  ...
  ---
  
  
  Detailed Recreation Procedure:
  1. Stop MSSQL Server service.
  2. Go to TEP.
  3. Click on any of the workspaces, it will not show data.
  
  Related Files and Output:
  <%CANDLE_HOME%>\TMAITM6\Logs\[SERVERNAME_OQ_INSTANCENAME_COL.out
  ]
  
  Search for '[Microsoft][ODBC SQL Server Driver][DBMSLPCN]
  ConnectionOpen'
  or
  '[Microsoft][ODBC SQL Server Driver][SharedMemory]
  ConnectionOpen' in collector log file which restricts Collector
  service from restarting and hence collector cannot collect data.
  

Local fix

Problem summary

• KOQCOLL.EXE Crashes after Microsoft SQL Server stops.
  

Problem conclusion

• Now no more KOQCOLL.EXE Crash occurs after Microsoft SQL Server
  stops.
  
  The fix for this APAR is contained in the following maintenance
  packages:
     | interim fix | 6.2.1-TIV-ITM_SQL-IF0004
     | interim fix | 6.2.1.1-TIV-ITM_SQL-IF0001
  

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

  TIV MON MS SQL

• Fixed component ID

  5724B96MO

Applicable component levels

• R621 PSY

     UP