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 »

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 »

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

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

Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets

Post by mattgoff »

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: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: 9.4.1 FP2 - Excel Crashes when refreshing spreadsheets

Post by Steve Rowe »

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!
Technical Director
www.infocat.co.uk
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 »

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 »

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: 1054
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 »

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: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, 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 »

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 »

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: 74
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 »

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 »

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