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: 14
Joined: Wed Sep 17, 2008 8:44 am

9.5.2 Server Explorer crash: text file records > 1021 chars

Post by Paul Coggan » Thu Mar 24, 2011 6:39 am

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: 1049
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 » Thu Mar 24, 2011 5:20 pm

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: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

Wim Gielis
MVP
Posts: 1809
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

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

Post by Wim Gielis » Thu Mar 24, 2011 7:51 pm

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

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

Paul Coggan
Posts: 14
Joined: Wed Sep 17, 2008 8:44 am

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

Post by Paul Coggan » Thu Mar 24, 2011 11:21 pm

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: 1049
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 » Mon Mar 28, 2011 8:26 am

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: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

Paul Coggan
Posts: 14
Joined: Wed Sep 17, 2008 8:44 am

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

Post by Paul Coggan » Mon Mar 28, 2011 8:33 am

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: 1049
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 » Thu Apr 14, 2011 1:24 pm

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: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

User avatar
Steve Vincent
Site Admin
Posts: 1049
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 » Wed May 18, 2011 4:09 pm

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: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

Paul Coggan
Posts: 14
Joined: Wed Sep 17, 2008 8:44 am

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

Post by Paul Coggan » Thu May 19, 2011 8:05 am

Patch received and tested - issue resolved....clients are happy....

User avatar
Steve Vincent
Site Admin
Posts: 1049
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 » Thu May 19, 2011 9:18 am

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: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

Paul Coggan
Posts: 14
Joined: Wed Sep 17, 2008 8:44 am

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

Post by Paul Coggan » Thu May 19, 2011 12:00 pm

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: 20
Joined: Thu Jun 19, 2008 12:44 pm

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

Post by gabi » Tue Jun 14, 2011 7:24 am

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: 1049
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 » Tue Jun 14, 2011 11:02 am

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: TM1 64 bit 10.2.2, Windows 2008/2012 Server. Excel 2010, IE11 for t'internet

Post Reply