Page 1 of 1

Navigation of ALL Websheets have broken

Posted: Thu Mar 03, 2011 3:04 pm
by image2x
I've stepped into a pretty big fire drill this morning.

In TM1Web, clicking on *any* websheets (across *all* TM1 server instances) results in prompting the user to download the websheet as oppposed to rendering it in the right-hand frame as usual. The icon for the websheets has changed to the little box of zero's indicating a binary download.

Specifics:
TM1 9.5.1 HF10
Web tier - Windows 2003 Server x64, IIS 6
App tier - AIX 6.1 - admin server is also on the app tier
There have been no system/tm1 changes that I am aware off (although IT via SMS *might* have messed with something).

I have already re-installed the web components on the Windows tier to no avail. In looking into the underlying javascript script in navtree.js, it appears that all websheets are returning an objecttype of "External File":

Code: Select all

8.getAttribute("ObjectType");if(_9=="ExternalFile"){DownloadFile(_8.id)
I'm openning a ticket with IBM next but thought I'd first throw it out to this brain trust.

Thanks,
-- John

Re: Navigation of ALL Websheets have broken

Posted: Thu Mar 03, 2011 6:07 pm
by jorelb
We had a similar issue before and it is related to the Excel Service security. Changed the login id used in the TM1 Excel Service from the Service Account to the Local Service Account and the websheets worked.

Re: Navigation of ALL Websheets have broken

Posted: Thu Mar 03, 2011 7:47 pm
by image2x
Thanks jorelb!

Changing the service account to a local account fixed it.

I'm guessing some overnight IT patch must have screwed with it.