Create collection Error after migration
46 views
Skip to first unread message
Shree Jee
Jul 21, 2023, 7:16:35 AM7/21/23
to DSpace Community
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
DSpace Community
Jul 21, 2023, 3:32:29 PM7/21/23
to DSpace Community
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.
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
Shree Jee
Jul 25, 2023, 5:21:46 AM7/25/23
to DSpace Community
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: 42023-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)
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
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
--
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 dspace-communi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/684d3339-0010-4dac-97ef-ea93f46daffcn%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages