No transaction log in Win7 + 9.5.2

Post Reply
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

No transaction log in Win7 + 9.5.2

Post by lotsaram »

We have encountered an issue that seems specific to Win 7 x86 builds using Office 2010 where the transaction log option is available for admins but upon selection no transaction log query dialog pops up (message log works OK). This seems specific to Win 7 + Excel 2010 + TM1 Perspectives 9.5.2
XP + Excel 2010 + TM1 Perspectives 9.5.2 is OK
Win7 + Excel 2007 + TM1 Perspectives 9.5.2 is OK

This is entirely reproducible within our environment here on multiple PCs for multiple admins but I'm not sure yet whether this is a bona fide bug in TM1 or something specific to our Win7 configuration. We see this for 9.5.2 FP1 and 9.5.2 FP2. Does anyone out there with the same OS + MS office experience this also?
declanr
MVP
Posts: 1831
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: No transaction log in Win7 + 9.5.2

Post by declanr »

Do you not get any error message whatsoever?

I used to have an issue with the transaction log not opening on windows 7 but that was fixed by registering msmask32.ocx, that instance was using the laptop as the server so I expect the fact that some of your clients can access from different OS's suggests that the file is already registered on your box.
Declan Rodger
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: No transaction log in Win7 + 9.5.2

Post by lotsaram »

declanr wrote:Do you not get any error message whatsoever?

I used to have an issue with the transaction log not opening on windows 7 but that was fixed by registering msmask32.ocx, that instance was using the laptop as the server so I expect the fact that some of your clients can access from different OS's suggests that the file is already registered on your box.
No, no message whatsoever. Ill follow up with msmask32.ocx - the Win7 + Office 2010 and Win7 + Office 2007 are different "platform builds" so it could be a platform issue specific to us as opposed to any specific combination of TM1 + office + OS ...
User avatar
Michel Zijlema
Site Admin
Posts: 713
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: No transaction log in Win7 + 9.5.2

Post by Michel Zijlema »

Also see this thread (it also mentions the msmask32.ocx and a link to an IBM technical bulletin).

Michel
Gregor Koch
MVP
Posts: 263
Joined: Fri Jun 27, 2008 12:15 am
OLAP Product: Cognos TM1, CX
Version: 9.0 and up
Excel Version: 2007 and up

Re: No transaction log in Win7 + 9.5.2

Post by Gregor Koch »

Hi
Can confirm that the following combinations work fine.

Windows 7 Enterprise SP1
Excel (MS Office Professional Plus) 2010
TM1 9.5.2 FP2

Windows 7 Enterprise SP1
Excel (MS Office Professional Plus) 2010
TM1 9.5.2 FP2 HF2
roymathew1
Posts: 4
Joined: Mon Mar 18, 2013 3:48 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 10

Re: No transaction log in Win7 + 9.5.2

Post by roymathew1 »

Registering msmask32.ocx worked for me (did have the file).

Details here:

https://www-304.ibm.com/support/docview ... wg21469061
Post Reply