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
On Saturday, June 8, 2019 at 10:30:51 PM UTC+5:30, Fazio Riccardo wrote: > > 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 <http://www.typeapp.com/r?b=15030> > On Jun 8, 2019, at 09:32, Dr Mohammed Abdul Hannan Hazari < > [email protected] <javascript:>> wrote: >> >> 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 <http://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 >> >> -- > This message has been checked by Libra ESVA and is believed to be clean. > -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/1385da23-659d-4294-878b-fecae4eacf82%40googlegroups.com.
