Web Problems again

Post Reply
User avatar
LeeTaylor1979
Posts: 63
Joined: Mon Aug 25, 2008 12:53 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2010

Web Problems again

Post by LeeTaylor1979 »

Hello All,

When trying to access any application I get the following error:

Operation Failed

--------------------------------------------------------------------------------

System has encountered a problem while handling your request.
Please try again.
If you keep having trouble, please contact your system administrator for assistance.


--------------------------------------------------------------------------------
Anyone got any Ideas ?

Regards


Lee
User avatar
George Regateiro
MVP
Posts: 326
Joined: Fri May 16, 2008 3:35 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007 SP3
Location: Tampa FL USA

Re: Web Problems again

Post by George Regateiro »

The best place to start is the TM1Web Logs. The tm1web.log will get generated under inetpub\wwwroot\tm1web\log folder.

If this does not give you any good information you can change the logging details. I have not tested this yet, I got these directions from support a while back. The basic log was enough to fix my issue.

1. Open the web.config file in a text editor, such as Microsoft Windows
Notepad.
2. Locate the following section of code under <log4net>
<level value="ERROR" />
3. Change the “level value” to value= DEBUG.
4. Delete the following filter lines  This step is not documented
<filter type="log4net.Filter.LevelRangeFilter">
<acceptOnMatch value="true" />
<levelMin value="INFO" />
<levelMax value="FATAL" />
</filter>
5. Save web.conf
Martin Erlmoser
Community Contributor
Posts: 125
Joined: Wed May 28, 2008 1:22 pm
OLAP Product: TM1, Cognos Express,..
Version: 9.1.4 FP1
Excel Version: 2010
Location: Vienna
Contact:

Re: Web Problems again

Post by Martin Erlmoser »

the webserver should give more detailled information about the error when you open the website directly on the webserver. (connect remote to the server)

and check the logfiles on the server.
User avatar
LeeTaylor1979
Posts: 63
Joined: Mon Aug 25, 2008 12:53 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2010

Re: Web Problems again

Post by LeeTaylor1979 »

Thanks for your replies,

I have had a look in the Web config file but could not see the coding you mentioned.

The error now only applies to some of the application files ?????

Some work fine the other don't.

Anything else I can try ?

Regards


Lee
Sandhya Kumar
Posts: 43
Joined: Thu Sep 10, 2009 6:36 am
OLAP Product: TM1
Version: 9.0 and above
Excel Version: 2003

Re: Web Problems again

Post by Sandhya Kumar »

Hi Lee,

Did this issue get resolved?

I am facing the same error with one of the active forms now..

Thanks!
tutak
Posts: 15
Joined: Mon Dec 21, 2009 4:50 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: Web Problems again

Post by tutak »

I am having exactly the same problem. Any solutions yet?

I have a TM1 server and a BI server which is used as the web server. I am suspecting it might be related to the distributed environment. Any thoughts?
appleglaze28
Regular Participant
Posts: 269
Joined: Tue Apr 21, 2009 3:43 am
OLAP Product: Cognos TM1, Planning
Version: 9.1 SP3 9.4 MR1 FP1 9.5
Excel Version: 2003

Re: Web Problems again

Post by appleglaze28 »

I encountered that problem before when accessing a websheet, even if i try to republish it still doesn't get resolve, I have to re-upload the websheet again.

I also encountered this problem during login, I'm not sure if its a security issue or a request issue between the application serve, web server & the accessing unit. The error message was gone after Matt's advise on the security setting of the Web however I'm still having problem with it comes to the application load. But that's my experience when it comes to that error.
hardstep
Posts: 53
Joined: Tue Jul 28, 2009 7:26 pm
OLAP Product: TM1, EP, Powerplay, C8/C10
Version: 10.2
Excel Version: 2013
Location: London
Contact:

Re: Web Problems again

Post by hardstep »

I had a similar problem on my windows 7 TM1 9.5 setup....

I was getting the following error in in TM1web.log file...

System.UnauthorizedAccessException: Access to the path 'C:\inetpub\wwwroot\TM1WebEx\ExcelSheet\62930876021.xls' is denied.

The problem was casued by file permissions and security on the TM1WebEx\ExcelFiles directory.
I set the IIS_IUSRS group to have WRITE permissions and the problem went away.
neoturner
Posts: 2
Joined: Mon Nov 29, 2010 8:12 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003-2007

Re: Web Problems again

Post by neoturner »

I got this error when I was messing with the config file:

In trying to solve my 9.5.1 integrated login problem on the web I tried the

ServicePrincipalName=<service account>

setting in the config file and afterwards I was getting the Operation Failed on most, but not all, my websheets and forms.

I removed the argument in the config, rebooted the server, iis, excel service and the links worked again.


Still working integrated web login :(
Turner Knapp
Revelwood 2008 - 2010
ISA Consulting 2010 - ?
Post Reply