Please provide solution
2023-07-25 11:22:36,593 INFO org.dspace.browse.BrowseEngine @ anonymous:session_id=B5E84A792484D6B9407AC2085B5961F3:ip_addr=127.0.0.1: browse_mini: 2023-07-25 11:22:36,813 INFO org.dspace.app.webui.discovery.DiscoverUtility @ facets for scope, null: 4 2023-07-25 11:22:42,394 INFO org.dspace.authenticate.PasswordAuthentication @ anonymous:session_id=B5E84A792484D6B9407AC2085B5961F3:ip_addr=127.0.0.1:authenticate:attempting password auth of user=nops 2023-07-25 11:22:42,404 INFO org.dspace.authenticate.PasswordAuthentication @ nops:session_id=B5E84A792484D6B9407AC2085B5961F3:ip_addr=127.0.0.1: authenticate:type=PasswordAuthentication 2023-07-25 11:22:42,405 INFO org.dspace.eperson.EPersonServiceImpl @ nops:session_id=B5E84A792484D6B9407AC2085B5961F3:ip_addr=127.0.0.1: update_eperson:eperson_id=ec873417-a2d6-4d16-8186-10509ef469e1 2023-07-25 11:22:42,795 INFO org.dspace.app.webui.servlet.PasswordServlet @ nops:session_id=B5E84A792484D6B9407AC2085B5961F3:ip_addr=127.0.0.1: login:type=explicit 2023-07-25 11:22:43,080 INFO org.dspace.app.webui.servlet.MyDSpaceServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_mydspace: 2023-07-25 11:22:47,610 INFO org.dspace.browse.BrowseEngine @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: browse_mini: 2023-07-25 11:22:47,638 INFO org.dspace.app.webui.discovery.DiscoverUtility @ facets for scope, null: 4 2023-07-25 11:22:50,591 INFO org.dspace.app.webui.servlet.HandleServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_community:community_id=f4c8505e-9368-4143-aa58-879cb3364fc4 2023-07-25 11:22:50,728 INFO org.dspace.browse.BrowseEngine @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: browse_mini: 2023-07-25 11:22:50,771 INFO org.dspace.app.webui.discovery.DiscoverUtility @ facets for scope, org.dspace.content.Community@7ecedbba: 4 2023-07-25 11:22:50,997 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_community:community_id=f4c8505e-9368-4143-aa58-879cb3364fc4 2023-07-25 11:22:51,613 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=bbb988e4-6424-4057-9e3c-3152dbb0d954 2023-07-25 11:22:51,615 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=bbb988e4-6424-4057-9e3c-3152dbb0d954 2023-07-25 11:22:54,403 INFO org.dspace.app.webui.servlet.HandleServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_community:community_id=b8597b7a-aef7-4ece-ba3d-7f2b7d00767f 2023-07-25 11:22:54,747 INFO org.dspace.browse.BrowseEngine @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: browse_mini: 2023-07-25 11:22:54,790 INFO org.dspace.app.webui.discovery.DiscoverUtility @ facets for scope, org.dspace.content.Community@d1933f55: 4 2023-07-25 11:22:54,935 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_community:community_id=b8597b7a-aef7-4ece-ba3d-7f2b7d00767f 2023-07-25 11:22:55,535 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=7df10fa0-6796-42f2-b58c-8336351922e1 2023-07-25 11:22:55,537 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=7df10fa0-6796-42f2-b58c-8336351922e1 2023-07-25 11:22:55,572 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=1a1f6a81-5623-496d-94a6-916d8ae883d3 2023-07-25 11:22:55,574 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=1a1f6a81-5623-496d-94a6-916d8ae883d3 2023-07-25 11:22:55,587 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=32a65361-d040-49a7-9b1d-8cd3ec50a388 2023-07-25 11:22:55,587 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=8e5c2c2a-1c93-41ac-978e-6cbf7fb6874b 2023-07-25 11:22:55,588 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=8e5c2c2a-1c93-41ac-978e-6cbf7fb6874b 2023-07-25 11:22:55,588 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=32a65361-d040-49a7-9b1d-8cd3ec50a388 2023-07-25 11:22:55,594 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=b1f603e4-0969-4fc0-a7f5-391ffb7dae54 2023-07-25 11:22:55,596 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=b1f603e4-0969-4fc0-a7f5-391ffb7dae54 2023-07-25 11:22:55,634 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=ef20bd46-5ead-4c69-af3d-eb5e1323c4fa 2023-07-25 11:22:55,636 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=ef20bd46-5ead-4c69-af3d-eb5e1323c4fa 2023-07-25 11:22:56,014 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=e48d8d97-7a19-4200-9199-69195fd9c71c 2023-07-25 11:22:56,015 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=e48d8d97-7a19-4200-9199-69195fd9c71c 2023-07-25 11:22:56,046 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=b72b9bf9-ee52-47c1-8ec0-fc4237f03975 2023-07-25 11:22:56,046 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=b72b9bf9-ee52-47c1-8ec0-fc4237f03975 2023-07-25 11:22:56,048 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=82707970-c7f6-4b94-ae8e-ed940b6aa690 2023-07-25 11:22:56,049 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=82707970-c7f6-4b94-ae8e-ed940b6aa690 2023-07-25 11:22:56,078 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=dc7d46ca-c6de-4983-8b1a-b3a7ae73f648 2023-07-25 11:22:56,079 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=dc7d46ca-c6de-4983-8b1a-b3a7ae73f648 2023-07-25 11:22:56,098 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=4f1d581a-5ee1-49d6-a54b-19b2b8340e61 2023-07-25 11:22:56,100 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=4f1d581a-5ee1-49d6-a54b-19b2b8340e61 2023-07-25 11:22:56,151 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=1137f9b2-971d-4c6a-aec2-45021e17f3b6 2023-07-25 11:22:56,155 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=1137f9b2-971d-4c6a-aec2-45021e17f3b6 2023-07-25 11:22:56,493 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=b4be3393-462d-4a21-bd04-a43927f0da9f 2023-07-25 11:22:56,493 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=b4be3393-462d-4a21-bd04-a43927f0da9f 2023-07-25 11:22:56,598 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=adb0ec8f-4580-4b65-89fc-bc150886c460 2023-07-25 11:22:56,599 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=adb0ec8f-4580-4b65-89fc-bc150886c460 2023-07-25 11:22:56,603 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=a98721d1-f931-43bd-8c52-a44c01747921 2023-07-25 11:22:56,604 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=a98721d1-f931-43bd-8c52-a44c01747921 2023-07-25 11:22:56,606 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=10ded541-4672-4229-9e65-f05df0040fac 2023-07-25 11:22:56,606 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=10ded541-4672-4229-9e65-f05df0040fac 2023-07-25 11:22:56,633 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=734e8c51-e1f0-40c6-a915-f5cb955473ab 2023-07-25 11:22:56,634 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=734e8c51-e1f0-40c6-a915-f5cb955473ab 2023-07-25 11:22:56,658 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=cb8c229b-8821-47d4-b9a1-f48e3784af5f 2023-07-25 11:22:56,659 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=cb8c229b-8821-47d4-b9a1-f48e3784af5f 2023-07-25 11:22:56,897 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=bb9ec0b4-1ea5-416d-8e6c-c428e12aff76 2023-07-25 11:22:56,897 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=bb9ec0b4-1ea5-416d-8e6c-c428e12aff76 2023-07-25 11:22:57,091 INFO org.dspace.app.webui.servlet.RetrieveServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=c3b026c7-6c2f-4711-aea2-00ce2947ae60 2023-07-25 11:22:57,092 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_bitstream:bitstream_id=c3b026c7-6c2f-4711-aea2-00ce2947ae60 2023-07-25 11:22:58,785 INFO org.dspace.app.webui.servlet.HandleServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_community:community_id=576be0f5-4830-4c11-8db5-b9718d5bc24a 2023-07-25 11:22:58,795 INFO org.dspace.browse.BrowseEngine @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: browse_mini: 2023-07-25 11:22:58,841 INFO org.dspace.app.webui.discovery.DiscoverUtility @ facets for scope, org.dspace.content.Community@1fb5da54: 4 2023-07-25 11:22:58,951 INFO org.dspace.usage.LoggerUsageEventListener @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1: view_community:community_id=576be0f5-4830-4c11-8db5-b9718d5bc24a 2023-07-25 11:23:00,964 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: 23502 2023-07-25 11:23:00,965 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ ERROR: null value in column "collection_id" violates not-null constraint Detail: Failing row contains (null, f, 2023-07-25 11:23:00.378137, t). Where: SQL statement "INSERT INTO latest_collection SELECT NEW.collection_id, FALSE,CURRENT_TIMESTAMP" PL/pgSQL function add_to_latest_collection() line 5 at SQL statement 2023-07-25 11:23:00,974 WARN org.dspace.app.webui.servlet.DSpaceServlet @ nops:session_id=82D6163B2234BC9B307B164CF442B400:ip_addr=127.0.0.1:general_jspui_error:org.hibernate.exception.ConstraintViolationException\colon; could not execute statement org.hibernate.exception.ConstraintViolationException: could not execute statement at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:129) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3082) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3521) at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88) at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:303) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349) at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:67) at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1166) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1223) at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101) at org.dspace.core.AbstractHibernateDAO.list(AbstractHibernateDAO.java:171) at org.dspace.core.AbstractHibernateDAO.singleResult(AbstractHibernateDAO.java:229) at org.dspace.eperson.dao.impl.GroupDAOImpl.findByName(GroupDAOImpl.java:100) at org.dspace.eperson.GroupServiceImpl.findByName(GroupServiceImpl.java:320) at org.dspace.eperson.GroupServiceImpl.isMember(GroupServiceImpl.java:231) at org.dspace.authorize.AuthorizeServiceImpl.isAdmin(AuthorizeServiceImpl.java:477) at org.dspace.authorize.AuthorizeServiceImpl.isAdmin(AuthorizeServiceImpl.java:380) at org.dspace.authorize.AuthorizeServiceImpl.authorize(AuthorizeServiceImpl.java:263) at org.dspace.authorize.AuthorizeServiceImpl.authorizeAction(AuthorizeServiceImpl.java:129) at org.dspace.authorize.AuthorizeServiceImpl.authorizeAction(AuthorizeServiceImpl.java:95) at org.dspace.authorize.AuthorizeServiceImpl.authorizeAction(AuthorizeServiceImpl.java:89) at org.dspace.content.CommunityServiceImpl.addCollection(CommunityServiceImpl.java:377) at org.dspace.content.CollectionServiceImpl.create(CollectionServiceImpl.java:94) at org.dspace.content.CollectionServiceImpl.create(CollectionServiceImpl.java:82) at org.dspace.app.webui.servlet.admin.CollectionWizardServlet.doDSPost(CollectionWizardServlet.java:182) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:122) at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:80) at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) 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:53) 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.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66) 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:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:375) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1594) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "collection_id" violates not-null constraint Detail: Failing row contains (null, f, 2023-07-25 11:23:00.378137, t). Where: SQL statement "INSERT INTO latest_collection SELECT NEW.collection_id, FALSE,CURRENT_TIMESTAMP" PL/pgSQL function add_to_latest_collection() line 5 at SQL statement at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155) at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:132) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186) ... 58 more On Sat, Jul 22, 2023 at 1:02 AM DSpace Community < [email protected]> wrote: > Hi, > > I think we'd need more information about the migration you are trying to > do. The error you shared references a PostgreSQL database table (or view) > named "latest_collection". That doesn't exist in DSpace (and I don't > recall it ever existing in any older version of DSpace). So, it's unclear > to me what could be causing this error, unless maybe you have custom code > or custom plugins installed that are throwing the error. > > Tim > > On Friday, July 21, 2023 at 6:16:35 AM UTC-5 [email protected] wrote: > >> Please provide solution:- >> Dspace log:- >> Caused by: org.postgresql.util.PSQLException: ERROR: null value in column >> "collection_id" violates not-null constraint >> Detail: Failing row contains (null, f, 2023-07-21 09:38:00.917574, t). >> Where: SQL statement "INSERT INTO latest_collection SELECT >> NEW.collection_id, FALSE,CURRENT_TIMESTAMP" >> PL/pgSQL function add_to_latest_collection() line 5 at SQL statement >> >> >> >> -- > All messages to this mailing list should adhere to the Code of Conduct: > https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx > --- > You received this message because you are subscribed to the Google Groups > "DSpace Community" 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-community/684d3339-0010-4dac-97ef-ea93f46daffcn%40googlegroups.com > <https://groups.google.com/d/msgid/dspace-community/684d3339-0010-4dac-97ef-ea93f46daffcn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Community" 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-community/CA%2BST7T8ksCEWs3zWDhW5iLeE92j1bmkaPTQL9JDnB4wGSQj0pQ%40mail.gmail.com.
