java.sql.SQLException: Collection 770 has no default item READ policies

Sakai JIRA | Claudia Jürgen | 4 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    At the moment it is possible to delete the collection policies: - default_item_read - default_bitstream_read From these the policies of the item are derived during submission. If they are missing, they are not treated as if restricted but lead to an internal system error see below. Either we should make these undeletable similar to the admin group or change the behaviour. ERROR org.dspace.submit.step.CompleteStep @ Caught exception in submission step: java.sql.SQLException: Collection 770 has no default item READ policies at org.dspace.content.Item.inheritCollectionDefaultPolicies(Item.java:2180) at org.dspace.content.InstallItem.installItem(InstallItem.java:167) at org.dspace.content.InstallItem.installItem(InstallItem.java:71) at org.dspace.workflow.WorkflowManager.archive(WorkflowManager.java:660) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:614) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:590) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:554) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:514) at org.dspace.workflow.WorkflowManager.start(WorkflowManager.java:199) at org.dspace.submit.step.CompleteStep.doProcessing(CompleteStep.java:116) at org.dspace.app.webui.submit.JSPStepManager.doStepStart(JSPStepManager.java:331) at org.dspace.app.webui.submit.JSPStepManager.processStep(JSPStepManager.java:278) at org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:408) at org.dspace.app.webui.servlet.SubmissionController.doNextStep(SubmissionController.java:478) at org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:424) at org.dspace.app.webui.servlet.SubmissionController.doDSPost(SubmissionController.java:344) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:147) at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:619)

    Sakai JIRA | 4 years ago | Claudia Jürgen
    java.sql.SQLException: Collection 770 has no default item READ policies
  2. 0

    At the moment it is possible to delete the collection policies: - default_item_read - default_bitstream_read From these the policies of the item are derived during submission. If they are missing, they are not treated as if restricted but lead to an internal system error see below. Either we should make these undeletable similar to the admin group or change the behaviour. ERROR org.dspace.submit.step.CompleteStep @ Caught exception in submission step: java.sql.SQLException: Collection 770 has no default item READ policies at org.dspace.content.Item.inheritCollectionDefaultPolicies(Item.java:2180) at org.dspace.content.InstallItem.installItem(InstallItem.java:167) at org.dspace.content.InstallItem.installItem(InstallItem.java:71) at org.dspace.workflow.WorkflowManager.archive(WorkflowManager.java:660) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:614) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:590) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:554) at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:514) at org.dspace.workflow.WorkflowManager.start(WorkflowManager.java:199) at org.dspace.submit.step.CompleteStep.doProcessing(CompleteStep.java:116) at org.dspace.app.webui.submit.JSPStepManager.doStepStart(JSPStepManager.java:331) at org.dspace.app.webui.submit.JSPStepManager.processStep(JSPStepManager.java:278) at org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:408) at org.dspace.app.webui.servlet.SubmissionController.doNextStep(SubmissionController.java:478) at org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:424) at org.dspace.app.webui.servlet.SubmissionController.doDSPost(SubmissionController.java:344) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:147) at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:619)

    Sakai JIRA | 4 years ago | Claudia Jürgen
    java.sql.SQLException: Collection 770 has no default item READ policies

    Root Cause Analysis

    1. java.sql.SQLException

      Collection 770 has no default item READ policies

      at org.dspace.content.Item.inheritCollectionDefaultPolicies()
    2. DSpace Kernel :: API and Implementation
      CompleteStep.doProcessing
      1. org.dspace.content.Item.inheritCollectionDefaultPolicies(Item.java:2180)
      2. org.dspace.content.InstallItem.installItem(InstallItem.java:167)
      3. org.dspace.content.InstallItem.installItem(InstallItem.java:71)
      4. org.dspace.workflow.WorkflowManager.archive(WorkflowManager.java:660)
      5. org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:614)
      6. org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:590)
      7. org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:554)
      8. org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:514)
      9. org.dspace.workflow.WorkflowManager.start(WorkflowManager.java:199)
      10. org.dspace.submit.step.CompleteStep.doProcessing(CompleteStep.java:116)
      10 frames
    3. org.dspace.app
      DSpaceServlet.doPost
      1. org.dspace.app.webui.submit.JSPStepManager.doStepStart(JSPStepManager.java:331)
      2. org.dspace.app.webui.submit.JSPStepManager.processStep(JSPStepManager.java:278)
      3. org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:408)
      4. org.dspace.app.webui.servlet.SubmissionController.doNextStep(SubmissionController.java:478)
      5. org.dspace.app.webui.servlet.SubmissionController.doStep(SubmissionController.java:424)
      6. org.dspace.app.webui.servlet.SubmissionController.doDSPost(SubmissionController.java:344)
      7. org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:147)
      8. org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105)
      8 frames
    4. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      2 frames
    5. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    6. org.dspace.app
      RegisteredOnlyFilter.doFilter
      1. org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98)
      1 frame
    7. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      2 frames
    8. DSpace Services Framework :: API and Implementation
      DSpaceWebappServletFilter.doFilter
      1. org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:112)
      1 frame
    9. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      8. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      9. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
      9 frames
    10. Embedded GlassFish Web
      ChannelSocket$SocketConnection.runIt
      1. org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
      2. org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
      3. org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
      4. org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
      5. org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
      5 frames
    11. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
      1 frame
    12. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame