SPECTRUM Report Manager login fail with HTTP Status 500 (Legacy KB ID CNC TS32233 )

Document ID : KB000052103
Last Modified Date : 14/02/2018
Show Technical Document Details

Try the following three solutions in the order listed.


1. Rerun the $SPECROOT/Install-Tools/SRM-Tools/setup_boxi.sh script as described in the Report Manager Installation and Administration Guide.


2. Restart all BOXI servers and tomcat


a. Shutdown ALL of the servers in the BOXI Central Configuration Manager. Basically, start at the top of the list and shutdown all of the servers.
b. Bounce tomcat
c. Restart all of the servers in the BOXI Central Configuration Manager. Again, start at the top of the list and work your way down.


3. Remove all tomcat work files and directories



a. Shutdown tomcat
b. For SPECTRUM 09.00.00.00, remove all the files/directories from the $SPECROOT/tomcat/work/Catalina/localhost directory. For SPECTRUM 08.01.00.00, remove all the files/directories from the $SPECROOT/tomcat/work/Standalone/localhost directory.
c. Restart tomcat. The work files and directories will be recreated
d. Wait for OneClick to start completely
e. Launch SRM


If the problem persists, contact CA SPECTRUM Support.


Related Issues/Questions:
SPECTRUM Report Manager login fail with HTTP Status 500

Problem Environment:
SPECTRUM 08.01.00.00
SPECTRUM 09.00.00.00
SPECTRUM Report Manager
HTTP Status 500
The following exception and root cause information is displayed when trying to log into SPECTRUM Report Manager:


HTTP Status 500



type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.


exception
org.apache.jasper.JasperException: Error creating bean with name 'jdbcTemplate' defined in dataAccessContext.xml: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in dataAccessContext.xml: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.aprisma.spectrum.app.web.datasource.ManagedCredentialsPooledDataSource]: Constructor threw exception; nested exception is java.lang.NullPointerException
 org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
 com.aprisma.spectrum.app.repmgr.web.servlet.SRMSessionFilter.doFilter(SRMSessionFilter.java:121)


root cause
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcTemplate' defined in dataAccessContext.xml: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in dataAccessContext.xml: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.aprisma.spectrum.app.web.datasource.ManagedCredentialsPooledDataSource]: Constructor threw exception; nested exception is java.lang.NullPointerException
 org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:190)
 org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
 org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1046)
 org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:857)
 org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:378)
 org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:252)
 org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:145)
 org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:537)
 com.aprisma.spectrum.app.repmgr.common.SRMApplicationContext.getJdbcTemplateBean(SRMApplicationContext.java:168)
 com.aprisma.spectrum.app.repmgr.common.registry.SRMRegistry.establishJDBCTemplate(SRMRegistry.java:677)
 com.aprisma.spectrum.app.repmgr.common.registry.SRMRegistry.start(SRMRegistry.java:177)
 com.aprisma.spectrum.app.util.context.ContextFactory.threadSafeStartContextObject(ContextFactory.java:275)
 com.aprisma.spectrum.app.util.context.ContextFactory.getContextObject(ContextFactory.java:179)
 com.aprisma.spectrum.app.repmgr.common.GlobalContextObjectManager.getSRMRegistry(GlobalContextObjectManager.java:292)
 org.apache.jsp.repmgr.index_jsp._jspService(index_jsp.java:87)<.BR> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
 com.aprisma.spectrum.app.repmgr.web.servlet.SRMSessionFilter.doFilter(SRMSessionFilter.java:121)

.


(Legacy KB ID CNC TS32233 )