Technical Blog Post
Abstract
Troubleshooting: After upgrading to TPAE 7.5.0.1 Start Center does not load.
Body
If you have upgraded to 7.5.0.1 from an earlier version, in some environments Start Center does not load after logging-in and application server log has the following error.
java.lang.NullPointerException
at psdi.webclient.system.session.WebClientSession.getReportsMap(WebClientSession.java:4067)
at psdi.webclient.controls.Menus.buildMenuCache(Menus.java:536)
at com.ibm._jsp._page._jspService(_page.java:2323)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:99)
.
.
.
This usually happens when actuate reports are not removed while upgrading. Execute following sqls on the database to remove Actuate reports.
delete from reportlookup where reportnum in (select reportnum from report where runtype in ('ESPREADSHEET', 'QUERY', 'REPORT'));
delete from reportlabel where reportname like '%.rox' or reportname like '%.dox' or reportname like '%.dov'
or reportname like '%.vts' or reportname like '%.vtf';
delete from report where runtype in ('ESPREADSHEET', 'QUERY', 'REPORT');
UID
ibm11134357