9.4.1 FP2 - Excel Crashes when refreshing spreadsheets

Post bug reports and the status of reported bugs
Post Reply
Armand Mizan
Posts: 17
Joined: Thu Aug 07, 2008 11:24 pm
OLAP Product: TM1
Version: TM1 v 10.1.1
Excel Version: 2003

9.4.1 FP2 - Excel Crashes when refreshing spreadsheets

Post by Armand Mizan » Wed Sep 16, 2009 11:32 pm

Hi All

We recently upgraded from Ver 9.1 SP3 to ver 9.4.1 FP2. We had to roll this back ,as it was discovered that when users refreshed their spreadsheets, more than once , it would cause Excel to crash.We have Office 2003 installed.
The following error message was displayed

AppName: excel.exe AppVer: 11.0.8231.0 AppStamp:48934d57
ModName: tm1api.dll ModVer: 9.4.10200.61478 ModStamp:4a3f136e
fDebug: 0 Offset: 00016a89


We refreshed the same spreadsheets with FP1 , and did not encounter these issues.
This has been logged with IBM, and we are waiting for their response.

Has anyone else experienced this?

Thanks in advance for your input

Armand

richar51
Posts: 1
Joined: Tue Aug 11, 2009 7:07 pm
OLAP Product: TM1
Version: 9.4.1
Excel Version: 2007

Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets

Post by richar51 » Wed Sep 16, 2009 11:40 pm

We are receiving a similar issue but have no resolution. If you get a response, please share.

Regards,

User avatar
mattgoff
MVP
Posts: 515
Joined: Fri May 16, 2008 1:37 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: 2016
Location: Florida, USA
Contact:

Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets

Post by mattgoff » Thu Sep 17, 2009 1:13 pm

Every time I have ever had this issue with a user it has been resolved by going to http://office.microsoft.com --> Downloads --> Check for free updates (or Start --> Microsoft Update if you've already done this before) and installing every one of the Excel patches. YMMV.

Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.

User avatar
Steve Rowe
Site Admin
Posts: 1969
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets

Post by Steve Rowe » Wed Sep 23, 2009 8:33 pm

There is clearly an issue with the client of 9.4.1 FP2 see also this link

IBM state to use the client for 9.4.1 FP1 and wait until FP3 for a fix for the issue on the FP2 client.

Can I remind users of the forum to try and update this section of the forum with known issues. Some people could have been saved pain if this issue had been posted when it was first noted.
Cheers!

Sandhya Kumar
Posts: 43
Joined: Thu Sep 10, 2009 6:36 am
OLAP Product: TM1
Version: 9.0 and above
Excel Version: 2003

Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets

Post by Sandhya Kumar » Mon Oct 19, 2009 9:05 am

Hi,

IBM released a hot fix HF16 which fixes this bug and few more including the popup error "Error in macro Excel_TM1ServerConnect SCODE = 800010105. The server threw an exception".

Armand Mizan
Posts: 17
Joined: Thu Aug 07, 2008 11:24 pm
OLAP Product: TM1
Version: TM1 v 10.1.1
Excel Version: 2003

Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets

Post by Armand Mizan » Fri Oct 30, 2009 5:02 am

Hi

We are contemplating installing this hotfix.

Has anyone had any experience with this Hot Fix?

Cheers

Armand

User avatar
Steve Vincent
Site Admin
Posts: 1050
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets

Post by Steve Vincent » Fri Oct 30, 2009 9:01 am

probably not, seeing as even if you are signed up to receive notification of new software from IBM they don't tell you it even exists :(
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

dkleist
Posts: 56
Joined: Wed May 21, 2008 12:33 pm

Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets

Post by dkleist » Fri Oct 30, 2009 12:14 pm

Hotfixes aren't announced as they are basically code patches that have barely been tested. One either needs to hear about them (like here) or have an open support ticket that references the bug/issue (good luck with that).

Sandhya Kumar
Posts: 43
Joined: Thu Sep 10, 2009 6:36 am
OLAP Product: TM1
Version: 9.0 and above
Excel Version: 2003

Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets

Post by Sandhya Kumar » Mon Nov 02, 2009 8:57 am

Yes.. This is like an emergency fix we got when we reported this problem to IBM... We do not face this multiple recalculate issue anymore...

TJMurphy
Posts: 68
Joined: Mon May 12, 2008 12:25 pm
OLAP Product: TM1
Version: PA 2.0.6 Local
Excel Version: Excel 2016

Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets

Post by TJMurphy » Tue Nov 03, 2009 9:30 am

HF16 on our Vista / Office 2007 test laptop results in Excel crashing all the time while running our load tests.

We were given the HotFix to try and get our performance back (load models were taking 5+ times longer on Vista / Office 2007 / 9.4.1 than XP / Office 2003 / 9.1.3) and also to see if it addressed the "stutter" question I'd asked about before.

Tony

Jessy
Posts: 38
Joined: Wed Mar 25, 2009 7:35 am
OLAP Product: TM1
Version: 9.4.1
Excel Version: 2003

Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets

Post by Jessy » Wed Dec 16, 2009 6:18 am

Sandhya Kumar wrote:Hi,

IBM released a hot fix HF16 which fixes this bug and few more including the popup error "Error in macro Excel_TM1ServerConnect SCODE = 800010105. The server threw an exception".
I've just come across the same error message

Thanks for your tip.

Post Reply