IBM Support

PI70485: EXCEL CRASH IN C1SIZER.OCX ON WINDOWS 10

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Users are using Planning Analyst Add-in for Excel on Windows 10
    Enterprise
    Version Excel 2013
    This used to work, but not anymore, and not on the new migrated
    users too.
    We were not able to determine what Microsoft update may cause
    this (if any)
    Users are able to open the add-in and connect to the namespace,
    and create a view., and Reselect View, etc...
    In that first session everything seems to be ok.
    But once the XLSX file has been saved, and once Excel has been
    closed and reopened, and once the saved XLSX is reopened, then
    the "Reselect View" provoke an Excel crash in C1Sizer.ocx which
    is a third-party OCX from ComponentOne, that is provided by
    Cognos Planning (in c10/bin folder)
    A defect has to be logged to ComponentOne : dump and all
    necessary files are provided in this APAR.
    ERROR :
    Faulting application name: excel.exe, version: 15.0.4867.1000
    Faulting module name: C1Sizer.ocx, version: 8.0.20133.150
    Exception code: 0xc0000005
    Faulting application path: C:\Program Files (x86)\Microsoft
    Office\Office15\excel.exe
    Faulting module path: C:\Program Files
    (x86)\ibm\cognos\c10plan\bin\C1Sizer.ocx
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL USERS                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * PI70485 EXCEL CRASH IN C1SIZER.OCX  ON  WINDOWS 10           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * UPGRADE TO LATEST SUPPORTED IBM COGNOS PLANNING RELEASE      *
    ****************************************************************
    

Problem conclusion

  • ...
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI70485

  • Reported component name

    COG PLAN AN EXC

  • Reported component ID

    5724W23AE

  • Reported release

    A11

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-10-11

  • Closed date

    2018-06-07

  • Last modified date

    2018-06-07

  • 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 PLAN AN EXC

  • Fixed component ID

    5724W23AE

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSPN2D","label":"Cognos Planning"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
06 March 2023