IBM Support

"Internal Server Error ... STATUS: 500 ... Request failed: null" when trying to save data inside Controller Web

Troubleshooting


Problem

User is trying to perform data entry inside Controller Web. User receives an error.

Symptom


Internal Server Error
URL: http .../fcm.web/api/formdataentry/
STATUS: 500

Log entry: server=....
For more details, please use the button below.

Failed URL: http .../fcm.web/api/formdataentry/

==============================
log file:
017-01-30 12:29:29 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.ui.secure.WorkspaceController] /fcm.web/api/deadlines: 25 ms
2017-01-30 12:29:29 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.ui.secure.WorkspaceController] /fcm.web/api/commonworkspace/entities: 35 ms
2017-01-30 12:29:35 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.ui.secure.WorkspaceController] /fcm.web/api/deadlines: 71 ms
2017-01-30 12:29:35 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.service.internal.StatusServiceImpl] findReportingStatus (3): 109 ms (~36 ms each)
2017-01-30 12:29:35 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.ui.secure.BasicSpaController] getCompanies(): 42 ms
2017-01-30 12:29:35 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.ui.secure.WorkspaceController] /fcm.web/api/submissiontiles/: 348 ms
2017-01-30 12:29:41 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.ui.secure.BasicSpaController] /fcm.web/api/validatecache/: 18 ms
2017-01-30 12:29:41 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.ui.secure.WorkspaceController] /fcm.web/api/submission/invalidforms/: 14 ms
2017-01-30 12:29:41 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.ui.secure.ReconcileController] /fcm.web/api/reconcile/: 15 ms
2017-01-30 12:29:41 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.ui.secure.WorkspaceController] /fcm.web/api/forms/: 176 ms
2017-01-30 12:29:41 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.ui.secure.WorkspaceController] /fcm.web/api/numberofjournals: 26 ms
2017-01-30 12:29:41 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.ui.secure.DataEntryCompanyController] /fcm.web/api/countercompanies/21000: 25 ms
2017-01-30 12:31:39 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.ui.secure.DataEntryCompanyController] /fcm.web/api/formdataentrydimensionheader/: 28 ms
2017-01-30 12:31:39 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.ui.secure.DataEntryCompanyController] /fcm.web/api/formdataentry/: 367 ms
2017-01-30 12:31:46 | ADM@ccr_nlfpm | INFO | [com.ibm.cognos.fcm.web.ui.secure.DataEntryCompanyController] /fcm.web/api/formdataentry/401200: 5 ms
2017-01-30 12:31:52 | ADM@ccr_nlfpm | ERROR | [com.ibm.cognos.fcm.web.ui.core.GlobalDefaultExceptionHandler] Request failed: null (server: ibmdemo.demos.ibm.com, uri: /fcm.web/api/formdataentry/, user: ADM, session id: G92W9WGTAatyzl1w-nI2_Jv, parameters: {"company":["21000"],"actuality":["AC"],"year":["2011"],"form":["P105"],"period":["12"],"submission":["2"]})
java.lang.NullPointerException
at com.ibm.cognos.fcm.web.service.internal.realtime.EventCentral.collectPeriodTimestamps(EventCentral.java:641)
at com.ibm.cognos.fcm.web.service.internal.realtime.EventCentral.validateStatus(EventCentral.java:618)
at com.ibm.cognos.fcm.web.service.internal.realtime.EventCentral.loadReconcileEngines(EventCentral.java:587)
at

<................>

org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:969)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:871)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:845)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1290)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:778)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:148)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:94)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)

<.....>

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.lang.Thread.run(Thread.java:785)

Cause

Invalid entries inside the database tables.

Resolving The Problem

Perform a database optimise.
 
Steps:
1. Launch Controller classic client
2. Logon to the 'bad' Controller database
3. Ensure no other users are currently using that database (downtime)
4. Click "Maintain - Users - Single Mode"
5. Click "Maintain - Database - Optimize"
6. Tick/select all available options
7. Click 'Run' button.

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 September 2020

UID

swg21998016

Page Feedback