IBM Support

Unable to start TM1 Perspectives due to error: Object library invalid or contain references to object definitions that could not be found

Troubleshooting


Problem

Attempts to start TM1 Perspectives fail with an error message.

Symptom

May see one of two errors:

Microsoft Visual Basic for Applications
Object library invalid or contain references to object definitions that could not be found


or


Microsoft Visual Basic
Compile error in hidden module: MenuFuncs

Cause

The cause of the error may be related to Microsoft updates having been applied, but may have other root causes as well. The result is that the .EXD files become corrupt and TM1 does not know how to handle them, and therefore, throws the error.

Environment

The errors have been seen on various versions of TM1/Cognos Express and with Excel 2007/Excel 2010.

Resolving The Problem

When using Windows 7, use a file manager like Windows Explorer to go into the user specific directory "%AppData%\Roaming\Microsoft\Forms\" and delete the EXD files "RefEdit.exd" and "MSComctlLib.exd", then restart TM1 Perspectives.

When using Windows XP, use a file manager like Windows Explorer to go into the user specific directory "%AppData%\Microsoft\Forms\" and delete the EXD files "RefEdit.exd" and "MSComctlLib.exd", then restart TM1 Perspectives.

Note:
For detailed information on corrupt EXD files and how to deal with them see the Microsoft KB article 290537: "EXD files are created when you insert controls".

Note:
For more information on the differences between Windows XP and Windows 7 regarding the directories referred to by environment variables like %AppData% see the Microsoft TechNet Library document: "Managing Roaming User Data Deployment Guide"

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5.2;9.5.1;9.5;9.4 MR1;9.4;10.1.0","Edition":""}]

Document Information

Modified date:
15 June 2018

UID

swg21472611