TM1 Install and tm1xl.ocx

[joeainsworth]

I have installed the TM1 10.1 client on a server with the following specs, and continue to get the run time error "File not found: tm1xl.ocx" when I run the client. I believe I have read every post about this file on this forum, etc.

Installing the client on Server 2008 R2, fully patched. Excel (Office Standard) 2010, patched. C++ 2005 Redistributable installed (have also uninstalled C++ 2008 per forum comments). This is also a Terminal Server.

When I installed the client, I was logged in as Administrator, and also selected "Run as Administrator". Everything I find points to registering tm1xl.ocx.

When I try and register the tm1xl.ocx file, I get the attached error.

Error when registering tm1xl.ocx

Screen shot 2012-07-26 at 3.17.03 PM.png (8.73 KiB) Viewed 9180 times

Any help is appreciated.

[Duncan P]

Side-by-side errors mean that you are missing a specific version of something. This may be a version that is older than the one that you have installed. If you look in the windows Application event log you will find an entry for this error and it will tell you the package and the exact version of it that it is expecting. You will need to install that particular version, which if it's a windows distributable, you can generally find by searching for the version number in a popular web search engine.

[joeainsworth]

Thanks for the reply Duncan. Here is the Application Log Event Data. Can you offer any more wisdom?


Activation context generation failed for "C:\Program Files (x86)\IBM\Cognos Express Clients\Xcelerator Client\bin\tm1xl.ocx". Dependent Assembly Microsoft.VC80.MFC,processorArchitecture="x86",publicKeyToken="1fc8b3b9a1e18e3b",type="win32",version="8.0.50727.762" could not be found. Please use sxstrace.exe for detailed diagnosis.

[Duncan P]

Microsoft.VC80.MFC

This is Microsoft Visual C++ version 8 (AKA 2005) Microsoft Foundation Classes.

version="8.0.50727.762"

This is the exact version number.

Searching for this (8.0.50727.762) gave http://www.microsoft.com/en-us/download ... px?id=5638 for Visual C++ 2005 SP1 as the first result. Download and install the package and see if that fixes your problem.

[joeainsworth]

Duncan,

It appears you have helped me out! I did install C++ 2005, but did not have SP1. I did that install via Windows updates and no longer have the error.

Thanks for your assistance!

[gtonkin]

I have been testing in a VM running 2008R2 64-bit, trying to get 10.1 FP1 servers and clients all running on the same box.
I went through the install of all the prerequisites and had a successful install.
On launching office for the first time I got the tm1xl.ocx file issue.
Check all the steps above, repaired, re-installed etc.

This seems obvious now but the issue was making sure that the 32-BIT Microsoft Visual C++ 2005 SP1 Redistributable Package (x86) is installed - I had installed the 64-BIT version. As TM1 Perspectives is 32-bit, this all makes sense.

How this post will save others some time.