On This Page:

Reports menu item does not appear
HTTP Status 500 exception
ServiceAnalytics 2

This page covers a number of previously seen errors from within the ServiceAnalytics product. If you come across any issues with ServiceAnalytics first check for a reason/resolution here before referring to the ServicePower Support team.

Reports menu item does not appear

The Problem

After installing ServiceAnalytics the Reports menu item is not displayed

The Reason

a) ServiceAnalytics classes not yet loaded

b) Both versions of ServiceAnalytics deployed into the same installation

The Resolution

a) After initial installation of ServiceAnalytics or upgrade of ServiceManager it is necessary to restart the tomcat server a second time in order to load all the modules classes. If this is unsuccessful then the problem may be caused by reason b).

b) Stop the tomcat server, uninstall ServiceAnalytics using the appropriate method (MSI or ZIP), remove the expanded ServiceManager webapp directory. Reinstall ServiceAnalytics and restart the tomcat server.

The Problem

The following exception occurs when selecting a report

javax.servlet.ServletException: could not execute query
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
com.servicepower.servicemanager.action.StrutsActionFilter.doFilter(StrutsActionFilter.java:34)

The Reason

The C3P0 connection pool is incorrectly handling unreturned connections to the connection pool.

The Resolution

Update the hibernate.cfg.xml file located within your properties directory and remove the following line

<property name="hibernate.c3p0.unreturnedConnectionTimeout">30</property>

The Problem

The error occurs then the user who is saving the report does not have correct permissions in the CRS Business View Manager.

The Resolution

This issue is documented on the Business Object Support site on KBase Article ID: 2800068, briefly:

Log on to Business View Manager as administrator.
Click View > Repository Explorer.
Right-click Dynamic Cascading Prompts. Click Edit Rights.
Click the appropriate user or group receiving the error.
Click the Granted option for the right to View, Edit & Set Security rights.
Click OK. Close Business View Manager.

The user or group is now able to save a report with dynamic parameters toEnterprise

Browser not supported