IBM Support

Unable to launch TM1 Perspectives: Microsoft Visual Basic Automation Error Unspecified Error

Troubleshooting


Problem

After receiving a Microsoft update(s), users trying to access TM1 Perspectives see the following error message:

Symptom

Microsoft Visual Basic

Automation Error
Unspecified Error

Cause

The following Microsoft updates have been released August 2012.

See bulletin below for all updates released;

http://technet.microsoft.com/en-us/security/bulletin/ms12-aug

This issue is specific to this Microsoft Office security Update KB2687441

Environment

Excel 2007 on Windows

Resolving The Problem

*** Excel must be closed before performing these steps***

Unregister and re-register the mscomctl.ocx file.
NOTE: The following must be performed on the machine where problem is occurring when logged into the machine as a user in the local Administrators group.

Open a command prompt window.
When applicable (Windows Vista, Windows 7, Windows Server 2008 R2), you must use the "Run as Administrator" mode/option when opening the command prompt window

Run the appropriate commands indicated below.

For 64 bit machines:

regsvr32 /u C:\Windows\SysWOW64\mscomctl.ocx

regsvr32 C:\Windows\SysWOW64\mscomctl.ocx


For 32 bit machines:

regsvr32 /u C:\Windows\System32\mscomctl.ocx

regsvr32 C:\Windows\System32\mscomctl.ocx


Once the file has successfully re-registered, start Perspectives to confirm whether this has resolved the problem.

For additional information including for other Operating system and Excel versions, please see the following Technote:

http://www-01.ibm.com/support/docview.wss?uid=swg21438688

OR

Upgrade to Office 2010

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU002","label":"Business Analytics"},"Component":"TM1 Perspectives","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5.2;10.1.0","Edition":"All Editions"},{"Product":{"code":"SSMR4U","label":"Cognos Express"},"Business Unit":{"code":"BU002","label":"Business Analytics"},"Component":"Cognos Xcelerator Perspectives","Platform":[{"code":"","label":"Windows 2003 server"},{"code":"PF033","label":"Windows"}],"Version":"10.1;10.2.1","Edition":""}]

Document Information

Modified date:
15 June 2018

UID

swg21608271