9.5.2 FP3 Perspectives Error PMR 674069 019 866

Post bug reports and the status of reported bugs
Post Reply
whitej_d
Community Contributor
Posts: 103
Joined: Mon Sep 05, 2011 11:04 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

9.5.2 FP3 Perspectives Error PMR 674069 019 866

Post by whitej_d »

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.
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: 9.5.2 FP3 Perspectives Error PMR 674069 019 866

Post by rmackenzie »

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.
Robin Mackenzie
Edward Stuart
Community Contributor
Posts: 248
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: 9.5.2 FP3 Perspectives Error PMR 674069 019 866

Post by Edward Stuart »

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
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
User avatar
jim wood
Site Admin
Posts: 3958
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: 9.5.2 FP3 Perspectives Error PMR 674069 019 866

Post by jim wood »

Thanks for letting us know what the fix is. Very interesting.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: 9.5.2 FP3 Perspectives Error PMR 674069 019 866

Post by rmackenzie »

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"
Robin Mackenzie
moby91
MVP
Posts: 228
Joined: Fri Mar 11, 2011 2:18 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003 2007

Re: 9.5.2 FP3 Perspectives Error PMR 674069 019 866

Post by moby91 »

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.
alimurat
Posts: 18
Joined: Mon Sep 14, 2009 4:04 pm
OLAP Product: TM1
Version: 10 2 2 FP3
Excel Version: 2010

Re: 9.5.2 FP3 Perspectives Error PMR 674069 019 866

Post by alimurat »

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:

Code: Select all

reg delete hkcr\typelib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0 /f

if exist %systemroot%\SysWOW64\cscript.exe goto 64 

%systemroot%\system32\regsvr32 /u mscomctl.ocx

%systemroot%\system32\regsvr32 mscomctl.ocx

exit


:64 

%systemroot%\sysWOW64\regsvr32 /u mscomctl.ocx

%systemroot%\sysWOW64\regsvr32 mscomctl.ocx

exit
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...
MKusuma
Posts: 8
Joined: Thu Mar 15, 2012 1:06 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Re: 9.5.2 FP3 Perspectives Error PMR 674069 019 866

Post by MKusuma »

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.
Catherine
Posts: 110
Joined: Wed May 20, 2009 7:30 am
OLAP Product: TM1
Version: 10.2.2 - PA
Excel Version: 2010
Location: Rennes, France

Re: 9.5.2 FP3 Perspectives Error PMR 674069 019 866

Post by Catherine »

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
declanr
MVP
Posts: 1822
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: 9.5.2 FP3 Perspectives Error PMR 674069 019 866

Post by declanr »

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
Declan Rodger
Catherine
Posts: 110
Joined: Wed May 20, 2009 7:30 am
OLAP Product: TM1
Version: 10.2.2 - PA
Excel Version: 2010
Location: Rennes, France

Re: 9.5.2 FP3 Perspectives Error PMR 674069 019 866

Post by Catherine »

Thanks a lot !
This solved my problem.
Post Reply