TM1 Web Internal Server Error

Post Reply
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

TM1 Web Internal Server Error

Post by macsir »

Hi, guy

Just weird thing, one TM1 web report just works fine for most of departments but if you select one parent department which many children departments inside it. It will give you an Internal Server Error from the web. However sometime I can show the report correctly by selecting this trouble parent department. This success often happens after the app server reboots. I check TM1 server log and tm1 web log. Nothing is showing for this strange event.

Any clue? We haven't changed this report for ages and this error is usually repeatable. And this report can always be shown in perspectives correctly all the time.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: TM1 Web Internal Server Error

Post by macsir »

I am not quite sure coz I can't find anything useful but just came cross this configuration in tomcat server configuration file. Has anyone known this about? If I make it longer, does that help? Since the overall symptom is just like timeout for me.

connectionTimeout.png
connectionTimeout.png (18.5 KiB) Viewed 5874 times
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
gtonkin
MVP
Posts: 1265
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: TM1 Web Internal Server Error

Post by gtonkin »

Have you configured your Application server to use more memory than the standard 768Mb? Could be that you are exceeding this.
When you get the Internal Error, does the application server crash i.e. need a restart?
BR, George.

Learn something new: MDX Views
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: TM1 Web Internal Server Error

Post by macsir »

gtonkin wrote:Have you configured your Application server to use more memory than the standard 768Mb? Could be that you are exceeding this.
When you get the Internal Error, does the application server crash i.e. need a restart?
No the server is still fine. It is just popping up with internal server error window and stop refreshing that report and close it. If you just select another department from the landing page, it will still be successful.
And ram, it is up to 12GB already.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: TM1 Web Internal Server Error

Post by tomok »

How many rows and columns of data does the report have when selecting this department?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
Steve Rowe
Site Admin
Posts: 2464
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: TM1 Web Internal Server Error

Post by Steve Rowe »

Any funnies in the department name? I had some issues in TM1Web with some elements with apostrophes in them and their charts not rendering correctly.
Just a thought on the off chance...
Technical Director
www.infocat.co.uk
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: TM1 Web Internal Server Error

Post by macsir »

tomok wrote:How many rows and columns of data does the report have when selecting this department?
Not many, 11 columns and around 700 rows.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: TM1 Web Internal Server Error

Post by macsir »

Steve Rowe wrote:Any funnies in the department name? I had some issues in TM1Web with some elements with apostrophes in them and their charts not rendering correctly.
Just a thought on the off chance...
Thanks, all names are fine and standard. If the name has an issue, it can't be run at all, right?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: TM1 Web Internal Server Error

Post by macsir »

Just a update,

I have changed gc policy to balanced according to this article and changed the max ram to 768*15=11520. So far so good.
http://www-01.ibm.com/support/docview.w ... wg21643906
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: TM1 Web Internal Server Error

Post by macsir »

The change doesn't help. It still happens sometimes.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply