TM1 10.1 TM1Web - websheets

Post Reply
User avatar
rollo19
Posts: 80
Joined: Wed May 28, 2008 2:42 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Perth, Australia

TM1 10.1 TM1Web - websheets

Post by rollo19 »

TM1 10.1 problem with TM1web worksheets.. Anyone come across this?

First I had to http://www-01.ibm.com/support/docview.w ... wg21503942

Then I get this and I can assure you those files do exist and no other application is using them. Shouldn't the path be a fully qualified web path rather than C:\..?
Attachments
13-02-2012 2-04-16 PM.png
13-02-2012 2-04-16 PM.png (125.05 KiB) Viewed 5750 times
User avatar
Michel Zijlema
Site Admin
Posts: 713
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: TM1 10.1 TM1Web - websheets

Post by Michel Zijlema »

Did you check (in task manager on the server) whether there's an Excel session hanging in the background, potentially locking the file?
Did you try to open the file directly with Excel to see whether you get an error message if you try?

Michel

PS, I moved the topic as it is not sure whether this is a bug
User avatar
rollo19
Posts: 80
Joined: Wed May 28, 2008 2:42 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Perth, Australia

Re: TM1 10.1 TM1Web - websheets

Post by rollo19 »

Michel Zijlema wrote:Did you check (in task manager on the server) whether there's an Excel session hanging in the background, potentially locking the file? No rogue sessions running


Did you try to open the file directly with Excel to see whether you get an error message if you try? Yes I can open the same file in excel by copying the link shown in the error message.

Michel

PS, I moved the topic as it is not sure whether this is a bug
User avatar
rollo19
Posts: 80
Joined: Wed May 28, 2008 2:42 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Perth, Australia

Re: TM1 10.1 TM1Web - websheets

Post by rollo19 »

ok who else is getting this error? I know of a few others.
User avatar
rollo19
Posts: 80
Joined: Wed May 28, 2008 2:42 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Perth, Australia

Re: TM1 10.1 TM1Web - websheets

Post by rollo19 »

It installs under Local System (get the error above), changed it to run under my personal Admin account and it WORKS. Thanks for the tip MR W.

But my preference would be to run it under Local System..
nick10598109
Posts: 3
Joined: Sat Feb 25, 2012 12:06 am
OLAP Product: TM1
Version: All
Excel Version: All

Re: TM1 10.1 TM1Web - websheets

Post by nick10598109 »

Unfortunately that error message isn't very helpful. It is recommended to always run Excel service as an actual account, not local system.

The 10.1 Installer doesn't include user login and password like 952, so there is extra configuration that is required after installation. This is documented in the installer guide (bullet 7):
http://publib.boulder.ibm.com/infocente ... erenv.html
Post Reply