DSpace CRIS 5.10 - Researcher Profile - Internal server error

[Dr Mohammed Abdul Hannan Hazari]

Our installation parameters:
OS: Windows Server 2008 Standard SP2
JDK: Oracle jdk 1.8.0_212
Maven: 3.6.1
Ant: 1.9.9
Database: PostgreSQL 9.4.21
Tomcat: 8.5.40
JAVA_OPTS: -Xms512M -Xmx2048M -XX:MaxPermSize=3072m -Dfile.encoding=UTF-8 -Djava.awt.headless=true -XX:+UseConcMarkSweepGC
CATALINA_OPTS: -Xms512M -Xmx2048M -XX:MaxPermSize=3072m
setenv.bat file contains [set "CATALINA_OPTS=%CATALINA_OPTS% -Dorg.apache.el.parser.SKIP_IDENTIFIER_CHECK=true"]

Dspace CRIS 5.10-SNAPSHOT was installed successfully. jspui interface is working. The configuration-tools-demo.xls was also imported twice successfully. Whenever we are trying to create new researcher profile or clicking authority management link we are getting 'Internal Server Error'.

The dspace.log file shows

2019-06-08 12:21:51,992 WARN  org.dspace.app.webui.servlet.InternalErrorServlet @ :session_id=07D91A859D3AC962788CA1D58D539AC5:internal_error:-- URL Was: http://localhost:8282/jspui/internal-error
-- Method: GET
-- Parameters were:

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalStateException: The configuration for db.name is either invalid, or contains an unrecognised database
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:963)
    at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:842)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.dspace.app.webui.cris.filter.DSpaceContextCleanupFilter.doFilter(DSpaceContextCleanupFilter.java:54)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.IllegalStateException: The configuration for db.name is either invalid, or contains an unrecognised database
    at org.dspace.content.authority.AuthorityDAOFactory.getInstance(AuthorityDAOFactory.java:42)
    at org.dspace.app.webui.cris.controller.ResearcherPageDetailsController.handleDetails(ResearcherPageDetailsController.java:195)
    at it.cilea.osd.jdyna.web.controller.SimpleDynaController.handleRequestInternal(SimpleDynaController.java:116)
    at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
    at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951)
    ... 36 more
2019-06-08 12:21:52,054 WARN  org.dspace.app.webui.util.UIUtil @ Unable to send email alert
java.lang.NullPointerException
    at org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:237)
    at org.dspace.content.DSpaceObject$MetadataCache.retrieveMetadata(DSpaceObject.java:1291)
    at org.dspace.content.DSpaceObject$MetadataCache.get(DSpaceObject.java:1226)
    at org.dspace.content.DSpaceObject.getMetadata(DSpaceObject.java:717)
    at org.dspace.content.DSpaceObject.getMetadata(DSpaceObject.java:596)
    at org.dspace.content.DSpaceObject.getMetadataFirstValue(DSpaceObject.java:694)
    at org.dspace.eperson.EPerson.getFirstName(EPerson.java:777)
    at org.dspace.eperson.EPerson.getFullName(EPerson.java:753)
    at org.dspace.app.webui.util.UIUtil.sendAlert(UIUtil.java:445)
    at org.dspace.app.webui.servlet.InternalErrorServlet.doGet(InternalErrorServlet.java:54)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:728)
    at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:472)
    at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
    at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:316)
    at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:386)
    at org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:323)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:166)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)

 
The initial lines shows error pertaining to db.name.

In the build.properties file, i have the following

#postgres
db.name=dcris
db.driver=org.postgresql.Driver
db.url=jdbc:postgresql://localhost:5434/dcris
db.username=dspace
db.password=dspace

Database connection is OK.

C:\DCRIS\bin>dspace database test
Using DSpace installation in: C:\DCRIS
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=3072m; support was removed in 8.0

Attempting to connect to database using these configurations:
 - URL: jdbc:postgresql://localhost:5434/dcris
 - Driver: org.postgresql.Driver
 - Username: dspace
 - Password: [hidden]
 - Schema: public

Testing connection...
Connected successfully!

Can anyone help, where is the problem. How to fix this issue?
Regards

[Fazio Riccardo]

Dear Mohammed

Can you check in installation dir the content of this file

solr/search/cinf/database.properties?

(ref. https://github.com/4Science/DSpace/blob/dspace-5_x_x-cris/dspace/solr/search/conf/database.properties)

It should contain the connection parameters to the db

Regards

Riccardo

Get TypeApp for Android

-- 
This message has been checked by Libra ESVA and is believed to be clean.

[Dr Mohammed Abdul Hannan Hazari]

Dear Mr.Riccardo

Thank you for your response.

After carefully going through the build.properties and final dspace.cfg files, I realized that the db.name parameter actually does not mean the name of the database created but it means the name of the database server being used i.e. either postgres or oracle. After correcting this parameter, the internal server error has gone.

Regards