TM1 Web Internal Server Error
- 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
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.
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.
- 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
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.
- 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
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?
When you get the Internal Error, does the application server crash i.e. need a restart?
- 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
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.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?
And ram, it is up to 12GB already.
-
- 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
How many rows and columns of data does the report have when selecting this department?
- 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
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...
Just a thought on the off chance...
Technical Director
www.infocat.co.uk
www.infocat.co.uk
- 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
Not many, 11 columns and around 700 rows.tomok wrote:How many rows and columns of data does the report have when selecting this department?
- 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
Thanks, all names are fine and standard. If the name has an issue, it can't be run at all, right?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...
- 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
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
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
- 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
The change doesn't help. It still happens sometimes.