PI93949: INTERMITTENT "MICROSOFT EXCEL HAS STOPPED WORKING" CRASH, WHILE RUNNING (F9) EXCEL LINK REPORT, TRIGGERED BY MULTI-THREADING

APAR status

• Closed as program error.

Error description

• User launches Microsoft Excel, and logs onto Controller (via the
  Excel link).  User opens a spreadsheet report (XLSX file with
  lots of formulae in it). User clicks 'F9' to run (refresh) the
  report. This works OK.
  - User then presses F9 again (to re-run the report). An error
  appears:    "Microsoft Excel has stopped working"
  Other steps to reproduce are:
  - open excel
  - log into controller
  - open the report file
  - press F9
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * User launches Microsoft Excel, and logs onto Controller (via *
  * the Excel link).  User opens a spreadsheet report (XLSX file *
  * with lots of formulae in it). User clicks 'F9' to run        *
  * (refresh) the report. This works OK.                         *
  * - User then presses F9 again (to re-run the report). An      *
  * error appears:    "Microsoft Excel has stopped working"      *
  * Other steps to reproduce are:                                *
  * - open excel                                                 *
  * - log into controller                                        *
  * - open the report file                                       *
  * - press F9                                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Controller 10.4                        *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

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

  COG CONTROLLER

• Fixed component ID

  5724W24CO

Applicable component levels