IBM Support

Unable to open TM1web (Planning Analytics Spreadsheet Service) - HTTP ERROR 500

Troubleshooting


Problem

TM1Web not working - Error 500

Symptom

Error Page Exception SRVE0260E: The server cannot use the error page specified for your application to handle the Original Exception printed below. Original Exception: Error Message: java.lang.NullPointerException Error Code: 500 Target Servlet: ServletNameNotFound Error Stack: java.lang.NullPointerException at com.ibm.cognos.tm1.web.shares.TM1WebConfig.getCrossDomainAccessList(TM1WebConfig.java:541) at com.ibm.cognos.tm1.web.shares.TM1WebUtils.isOriginAllowed(TM1WebUtils.java:240) at com.ibm.cognos.tm1.web.ResponseHeaderFilter.setHttpResponseHeaders(ResponseHeaderFilter.java:47) at com.ibm.cognos.tm1.web.ResponseHeaderFilter.doFilter(ResponseHeaderFilter.java:38) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:207) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) at com.ibm.cognos.tm1.web.EncodingFilter.doFilter(EncodingFilter.java:35) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:207) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:1020) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1142) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:4867) at com.ibm.ws.webcontainer31.osgi.webapp.WebApp31.handleRequest(WebApp31.java:523) at com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.handleRequest(DynamicVirtualHost.java:297) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:997) at com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.run(DynamicVirtualHost.java:262) at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper.run(HttpDispatcherLink.java:955) at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.ready(HttpDispatcherLink.java:341) at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:470) at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleNewRequest(HttpInboundLink.java:404) at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.processRequest(HttpInboundLink.java:284) at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.ready(HttpInboundLink.java:255) at com.ibm.ws.tcpchannel.internal.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:174) at com.ibm.ws.tcpchannel.internal.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:83) at com.ibm.ws.tcpchannel.internal.WorkQueueManager.requestComplete(WorkQueueManager.java:504) at com.ibm.ws.tcpchannel.internal.WorkQueueManager.attemptIO(WorkQueueManager.java:574) at com.ibm.ws.tcpchannel.internal.WorkQueueManager.workerRun(WorkQueueManager.java:929) at com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker.run(WorkQueueManager.java:1018) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.lang.Thread.run(Thread.java:811)

Cause

above error can be presented when  <Planning Analytics Spreadsheet Service installation directory > tm1web\webapps\tm1web\WEB-INF\configurationtm1web_config.xml is invalid.

Resolving The Problem

check line by line <Planning Analytics Spreadsheet Service installation directory > tm1web\webapps\tm1web\WEB-INF\configurationtm1web_config.xml
The error may be caused by a single character being missing, e.g

<add key="HttpSessionTimeout" value="120"> there is missing  "/" and it should be corrected to 

<add key="HttpSessionTimeout" value="120" />

another example , invalid comment out line

image-20230324104152-1

Once file is corrected, save changes and restart IBM Planning Analytics Spreadsheet Service

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m3p000000PC7XAAW","label":"Planning Analytics-\u003EWeb PASS Contributor Application"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
24 March 2023

UID

ibm16966010