Topic
  • 5 replies
  • Latest Post - ‏2012-08-21T18:06:13Z by RobertTanenbaum
SystemAdmin
SystemAdmin
658 Posts

Pinned topic TM1 Perspectives gets macro error after Windows XP update

‏2012-08-02T14:51:03Z |
Two of our users did an automated windows update of Windows XP last night, and now TM1 Perspectives fails to start.

The error message is "Compile error in hidden module: mMacros"
or it says something about a missing library.

I figured I would just back out the windows updates, but there were 27 of them.

Has anyone else seen this problem?

Do you know which update is causing the problem, so I can back it out?

Do you have an alternative solution?

Thanks.
Robert from HavasMedia
Updated on 2012-08-21T18:06:13Z at 2012-08-21T18:06:13Z by RobertTanenbaum
  • KTrent
    KTrent
    2 Posts

    Re: TM1 Perspectives gets macro error after Windows XP update

    ‏2012-08-02T15:10:38Z  
    Not sure if this was the same excel error-- but had to do the following after an office patch:

    Delete mscomctllib.exd from
    User/profile/appdata/roaming/Microsoft/forms
    The file will recreate- and the Excel startup error was eliminated.
  • SystemAdmin
    SystemAdmin
    658 Posts

    Re: TM1 Perspectives gets macro error after Windows XP update

    ‏2012-08-02T16:15:51Z  
    Thank you. That solved the problem.

    For others who encounter this, if you don't have roaming, you can find the mscomctllib.exd file in:
    C:\Documents and Settings{user}\Application Data\Microsoft\Forms

    Also, for the sake of completeness and for search engine indexing, there was another error message sometimes.
    "Object library invalid or contains references to object definitions that could not be found."

    Thanks again, for the quick response and correct solution.
  • RobertTanenbaum
    RobertTanenbaum
    14 Posts

    Re: TM1 Perspectives gets macro error after Windows XP update

    ‏2012-08-20T16:00:56Z  
    This problem has resurfaced for ALL of our Perspectives users and the method that used to be working (deleting MSComctlLib.exd) no longer fixes the problem. The only thing that seems to work is to back out the Microsoft Office updates and block the machines from doing any more updates. Obviously this is not a good option. Everyone here is dead in the water. HELP!
  • RobertTanenbaum
    RobertTanenbaum
    14 Posts

    Re: TM1 Perspectives gets macro error after Windows XP update

    ‏2012-08-21T17:59:23Z  
    Ok. got another solution to this problem.
    On Windows 7,
    1. Click Start -> type in “cmd” in the search line
    2. Type in: regsvr32 /u mscomctl.ocx
    3. Type in: regsvr32 c:\windows\sysWOW64\mscomctl.ocx
    On XP,
    1. Click Start -> type in “cmd” in the search line
    2. Type in: regsvr32 /u mscomctl.ocx
    3. Type in: regsvr32 c:\windows\system32\mscomctl.ocx
  • RobertTanenbaum
    RobertTanenbaum
    14 Posts

    Re: TM1 Perspectives gets macro error after Windows XP update

    ‏2012-08-21T18:06:13Z  
    NOW TO PUT ALL THE SOLUTIONS IN ONE PLACE:

    There are two errors that come up relatively frequently when people are starting up TM1.

    ERROR 1:
    "Compile error in hidden module: mMacros"
    OR the error might say
    "Object library invalid or contains references to object definitions that could not be found."

    Here is how to fix this problem.
    1. Close all Excel windows that are currently open.
    2. Open Windows Explorer.
    3. Go to the directory C:\Documents and Settings\user\Application Data\Microsoft\Forms where you substitute 'user' with the user's login name.
    4. Delete the file MSComctlLib.exd Actually, you can delete all files with the extension .exd
    5. Do the same thing in directories C:\Documents and Settings\user\Local Settings\Temp\VBE and C:\Documents and Settings\user\Local Settings\Temp\Excel8.0
    6. Actually, you can delete all files with the extension .exd
    Don't worry; Excel will recreate this file when it restarts.
    Now restart TM1 the usual way.

    Note: If this doesn’t fix the problem, try doing the following:
    On Windows 7,
    1. Click Start -> type in “cmd” in the search line
    2. Type in: regsvr32 /u mscomctl.ocx
    3. Type in: regsvr32 c:\windows\sysWOW64\mscomctl.ocx
    On XP,
    1. Click Start -> type in “cmd” in the search line
    2. Type in: regsvr32 /u mscomctl.ocx
    3. Type in: regsvr32 c:\windows\system32\mscomctl.ocx


    ERROR 2:
    "Method 'OnAction' of object '_CommandBarButton' failed"

    Here is how to fix this problem.
    In Excel, click on the "Office Button" (the button with the Excel icon in the upper left corner).
    Click on "Excel Options" select "Add-Ins" and in the "Manage:" box select "Disabled Items" and click "Go..."

    Select "Addin: IBM Cognos TM1 Perspectives (tm1p.xla)" and click "Enable" then click "Close"
    Then click "Ok".
    Now exit Excel and restart TM1 the usual way.