TM1 Forum

This should probably be in the bugs forum - please move.

We've been seeing some cases where installing 9.5.2 FP3 can break Perspectives. Causing a 'Compile error in hidden module:MenuFuncs' error. Normally this is fixed by re-registering some OCX files and deleting EXDs, however this does not work for this release.

It has been submitted to IBM (PMR 674069 019 866).

It seems to only happen if FP3 is installed over FP2. The work around seems to be to uninstall completely and install FP3 directly over the base install. http://www.infocat.co.uk/blog/2013/1/7/tm1-9-5-2-fp3

Would be interested if anyone else could replicate this.

I'm having this problem at the moment. Both workarounds are failing to fix the problem (installed FP3 on base and copying over a 'good' ocx).

If anyone gets an update or any further information on this error please could they post here. Ta.

The issue was resolved by copying a version of the MSCOMCTL.OCX file from a 'working' installation to the client machine and then re-registering the .ocx file, more information below:

Basically, there could have been two broken cases:
1. If the system already has newer version of mscomctl.ocx (timestamp should be later than May 02, 2012), and it still does not work.
User has to follow solution on "http://support.microsoft.com/kb/2664258",
and un-register and re-register the control.

2. If the system has a very old mscomctl.ocx, he/she has to grab a latest version of "mscomctl.ocx" from MS site (http://www.microsoft.com/en-us/download/default.aspx) first and then apply solution on "http://support.microsoft.com/kb/2664258", and un-register and re-register the control.

The following describes how to un-register and re-register the control.
============================================
- Open command window/console and run the following
commands depends on your system, each should succeed.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
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
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Thanks for letting us know what the fix is. Very interesting.

The guys at our place successfully fixed this issue by following this technote. This was required after an install of 9.5.2 FP3 32-bit on a Windows 2008 R2 server with Excel 2010. We thought that with that configuration something other than the latest mscomctl.ocx may still be required. Hope that helps someone stuck with this problem.

IBM wrote:Problem(Abstract)
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"

whitej_d wrote:We've been seeing some cases where installing 9.5.2 FP3 can break Perspectives. Causing a 'Compile error in hidden module:MenuFuncs' error. Normally this is fixed by re-registering some OCX files and deleting EXDs, however this does not work for this release.

Question:
After the upgrade from TM1 9.5.2 to 9.5.2 FP3, when you start TM1 9.5.2 FP3 Perspectives, do you get only ONE error message ?

That error message being:

Microsoft Visual Basic for Applications
Compile Error in hidden module: MenuFencs.
This error commonly occurs when code is incompatible with the version, platform, or architecture of this application. Click "Help" for information on how to correct this error.


Or do you get TWO error messages ?

The first error message being:

Microsoft Forms
Could not load an object because it is not available on this machine.

Which is followed by the second error message:

Microsoft Visual Basic for Applications
Compile Error in hidden module: MenuFencs.
This error commonly occurs when code is incompatible with the version, platform, or architecture of this application. Click "Help" for information on how to correct this error.


If you get two error messages, you may have applied a defective release of a Microsoft Security Update for Microsoft Office to install a newer version of the ActiveX Control MSCOMCTL.OCX:
It corrupts the Windows Registry keys used by the ActiveX Control MSCOMCTL.OCX

When you applied a defective release of a Microsoft Security Update for Microsoft Office, to un-register and re-register the ActiveX Control as outlined by the IBM Technote 1472611 will NOT resolve the problem, as this will not fix the corrupted Windows Registry keys.


When you are using Microsoft Office 2010, see the Microsoft KB 2597986:

http://support.microsoft.com/kb/2597986
MS12-060: Description of the security update for Office 2010: August 14, 2012

Known issues with this security update
Windows Common Control-based embedded ActiveX controls may fail to load within pre-existing Office documents, within third-party add-ins, and when you insert new controls in developer mode.

Recommended resolution
A fix is now available for download that installs the control and also fixes the registration of the control. We recommend that you install this fix to resolve the issue. You can download the fix here.

http://download.microsoft.com/download/ ... 86-glb.exe


Note:
Each Office 2003 and 2007 do have their own patched executable installer.
 
Note:
When you execute the patched executable installer. use the "Run as admin" option.

I did get the two error messages and nothing seemed to be fixing it so far.
Tried uninstalling TM1 completely and reinstalling from 9.5.2 base then to FP3 > Failed
Tried un-registering libraries, deleting all EXD files, re-registering libraries.

Still the same two errors.

Then, tried the solution mentioned above:
Copied the MSCOMCTL.OCX
Replaced the file on the client
ran this batch file as administrator: and it finally WORKED!

Here is a new find: If you have an FP1 Architect client and connecting to an FP3 Server, try deleting an element from a dimension. Heads up: Server crashes...

Thank you moby91.

I've just patched my TM1 10.1.1 (10.1.7101.108) and run into the same problem.

I had to search MS download for MS office 2007 security bulletin (here is the link for those who might need it: http://support.microsoft.com/kb/2687441).

After running the batch file as instructed, all is good now.

Hello,

I'm currently trying to install 10.2 version and I get the two error messages when starting Perspectives:
The first error message being:
Microsoft Forms
Could not load an object because it is not available on this machine.
Which is followed by the second error message:
Microsoft Visual Basic for Applications
Compile Error in hidden module: MenuFuncs.

Note that I install everything (server and client) on a single 64 bit machine, for test purposes.

I tried what you suggested:
-Deleting entry HKEY_CLASSES_ROOT\TypeLib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0 in register
-Re registering mscomctl.ocx file
-But I couldn't find the .exd files you're talking about. (my server is a windows 2008 R2)

Can somebody help?
thank you

Catherine wrote:Hello,

I'm currently trying to install 10.2 version and I get the two error messages when starting Perspectives:
The first error message being:
Microsoft Forms
Could not load an object because it is not available on this machine.
Which is followed by the second error message:
Microsoft Visual Basic for Applications
Compile Error in hidden module: MenuFuncs.

Note that I install everything (server and client) on a single 64 bit machine, for test purposes.

I tried what you suggested:
-Deleting entry HKEY_CLASSES_ROOT\TypeLib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0 in register
-Re registering mscomctl.ocx file
-But I couldn't find the .exd files you're talking about. (my server is a windows 2008 R2)

Can somebody help?
thank you

This has been mentioned quite a few times ont he forum for 10.2.

You need to make sure that your mscomctl.ocx file is version 6.01.9834

Thanks a lot !
This solved my problem.