9.5.2 Server Explorer crash: text file records > 1021 chars

Post bug reports and the status of reported bugs
Post Reply
Paul Coggan
Posts: 16
Joined: Wed Sep 17, 2008 8:44 am

9.5.2 Server Explorer crash: text file records > 1021 chars

Post by Paul Coggan »

TM1 9.5.2 server explorer crash

In turbo integrator when using a text file data source, attempting to preview a file that contains any record with more than 1021 characters causes server explorer and excel to crash. (i.e. a single row of data in the source file with greater than 1021 characters.)

Attempting to save the TI will also cause a crash.

The count of characters in a row includes any comma field delimiters.

This crash does not occur with earlier versions of server explorer - earlier versions supported much longer records.

Our testing was on Excel 2007 on a Windows 7 client, with the server running on Windows Server 2008 R2.

IBM HAVE NOW ISSUED A FIX PACK FOR THIS ISSUE
Last edited by Paul Coggan on Thu May 19, 2011 12:11 pm, edited 1 time in total.
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.5.2 Server Explorer crash: text file records > 1021 c

Post by Steve Vincent »

I can confirm the same crash using 32bit Windows Server 2003 R2 with XP/Office 2003 on the client. I have just logged it with IBM as fault number 44496 999 866. If anyone gets any joy with IBM please keep this thread updated, its a show stopper for us and was fine in 9.5.1 :cry:
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
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: 9.5.2 Server Explorer crash: text file records > 1021 c

Post by Wim Gielis »

LOL, notice the title above Steve's post :-)
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Paul Coggan
Posts: 16
Joined: Wed Sep 17, 2008 8:44 am

Re: 9.5.2 Server Explorer crash: text file records > 1021 c

Post by Paul Coggan »

News on this is getting worse.

When we run a TI in 9.5.2 that was created in a previous version of TM1 and points to a file with > 1021 characters in a record, it crashes the server. i.e. it is a TI that we would not be able to create in version 9.5.2 as Server Explorer crashes when previewing the file – but as it already exists we can run it – with a server crash being the result.
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.5.2 Server Explorer crash: text file records > 1021 c

Post by Steve Vincent »

I can't even get that far.

TI already exists with a saved datasource > 1021 chars. On opening the TI, it crashes explorer.
New TI and point to a datasource > 1021 chars. Fine until you click another tab or preview the source, then explorer crashes.

I got a swift reply from IBM to request the source files. Could only provide the headers due to sensitive data but it'll behave the same anyway. Have been told it's with their development team for review.
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
Paul Coggan
Posts: 16
Joined: Wed Sep 17, 2008 8:44 am

Re: 9.5.2 Server Explorer crash: text file records > 1021 c

Post by Paul Coggan »

Our Service request 10825 999 616 has been upgraded to APAR: PM35620.

Will report back if/when I hear about any progress....

I agree with your test results.
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.5.2 Server Explorer crash: text file records > 1021 c

Post by Steve Vincent »

Our 2 reports have been merged and the bug confirmed / passed to the engineering team. Had conformation earlier this week that they are aiming for a fix by the 6th May.
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
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.5.2 Server Explorer crash: text file records > 1021 c

Post by Steve Vincent »

The hotfix was released to us for testing but due to our other commitments we have yet to do anything with it.
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
Paul Coggan
Posts: 16
Joined: Wed Sep 17, 2008 8:44 am

Re: 9.5.2 Server Explorer crash: text file records > 1021 c

Post by Paul Coggan »

Patch received and tested - issue resolved....clients are happy....
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.5.2 Server Explorer crash: text file records > 1021 c

Post by Steve Vincent »

Paul, did you have to apply the fixes to just the client / server or both in order to sort it? I suspected client side but the way our IT is handled it'll be impossible for us to impliment it any time soon.
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
Paul Coggan
Posts: 16
Joined: Wed Sep 17, 2008 8:44 am

Re: 9.5.2 Server Explorer crash: text file records > 1021 c

Post by Paul Coggan »

The fix for this specific issue is in the client loose files. The other files (server and web) relate to the other fix items included in the fix pack.
gabi
Posts: 25
Joined: Thu Jun 19, 2008 12:44 pm

Re: 9.5.2 Server Explorer crash: text file records > 1021 c

Post by gabi »

Hello,

Please advice what hot fix (interim fix) solved this bug?
In the 9.5.2 (CTM1_9_5_2_win32_IF002 and CTM1_9_5_2_win64_IF002) lf002 i see just the tm1web fixes without any bin fixes.

Thank you,
Gabi
Gabi Cohen
Biconix International
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.5.2 Server Explorer crash: text file records > 1021 c

Post by Steve Vincent »

name of the file i was given is 952_HF2_x86_server.zip
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
Post Reply