[Dspace-tech] RV: Problen send to repository

Luis Rojas C. (CATIE)

unread,

Aug 26, 2015, 11:37:40 AM8/26/15

to dspac...@lists.sourceforge.net

Hi all, I have a problem, when I want to send an item to repository, the system send this error:

013-07-23 12:21:36,068 WARN org.dspace.app.webui.servlet.InternalErrorServlet @ :session_id=BB054145FED6E384BB71848C872F28AF:internal_error:-- URL Was: http://biblioteca.catie.ac.cr:5050/repositorioforestal/mydspace

-- Method: POST

-- Parameters were:

-- submit_approve: "Enviar al repositorio "

-- workflow_id: "775"

-- step: "3"

java.lang.RuntimeException: Error while attempting to create identifier for Item id: 949

at org.dspace.identifier.VersionedHandleIdentifierProvider.register(VersionedHandleIdentifierProvider.java:117)

at org.dspace.identifier.IdentifierServiceImpl.register(IdentifierServiceImpl.java:80)

at org.dspace.content.InstallItem.installItem(InstallItem.java:67)

at org.dspace.content.InstallItem.installItem(InstallItem.java:44)

at org.dspace.workflow.WorkflowManager.archive(WorkflowManager.java:724)

at org.dspace.workflow.WorkflowManager.doState(WorkflowManager.java:656)

at org.dspace.workflow.WorkflowManager.advance(WorkflowManager.java:416)

at org.dspace.workflow.WorkflowManager.advance(WorkflowManager.java:336)

at org.dspace.app.webui.servlet.MyDSpaceServlet.processPerformTask(MyDSpaceServlet.java:429)

at org.dspace.app.webui.servlet.MyDSpaceServlet.doDSPost(MyDSpaceServlet.java:109)

at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:115)

at org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:73)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:66)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Important to know that system was migrated previously from 1.4.2 to 3.1.

Thanks for your support.

Luis

helix84

unread,

Aug 26, 2015, 11:37:41 AM8/26/15

to Luis Rojas C. (CATIE), dspac...@lists.sourceforge.net

On Wed, Jul 24, 2013 at 3:51 PM, Luis Rojas C. (CATIE)
<luis...@catie.ac.cr> wrote:
> java.lang.RuntimeException: Error while attempting to create identifier for
> Item id: 949
> at
> org.dspace.identifier.VersionedHandleIdentifierProvider.register(VersionedHandleIdentifierProvider.java:117)

The generic Exception was caught here. There should be a Caused by:
line in the stracktrace just under what you posted. It's hard to guess
without that information.

Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Luis Rojas C. (CATIE)

unread,

Aug 26, 2015, 11:37:43 AM8/26/15

to dspac...@lists.sourceforge.net

Hi Helix, thanks for your response, maybe this message help you to understand my problem.

org.dspace.identifier.VersionedHandleIdentifierProvider @ mag...@catie.ac.cr:session_id=CFC20E97C6EA061685F7EAEAE62124AC:ip_addr=172.17.10.70:Error while attempting to create handle:Item id\colon; 991
java.lang.RuntimeException: ERROR: permission denied for relation versionitem

Thanks for all

-----Mensaje original-----
De: ivan....@gmail.com [mailto:ivan....@gmail.com] En nombre de helix84
Enviado el: miércoles, 24 de julio de 2013 8:17
Para: Luis Rojas C. (CATIE)
CC: dspac...@lists.sourceforge.net
Asunto: Re: [Dspace-tech] RV: Problen send to repository

helix84

unread,

Aug 26, 2015, 11:37:49 AM8/26/15

to Luis Rojas C. (CATIE), dspac...@lists.sourceforge.net

On Wed, Jul 24, 2013 at 5:47 PM, Luis Rojas C. (CATIE)
<luis...@catie.ac.cr> wrote:
> java.lang.RuntimeException: ERROR: permission denied for relation versionitem

Hi Luis,

it seems that you haven't run the database_schema_18-3.sql upgrade
script as your postgres "dspace" role. There are some examples how to
fix that here:
http://stackoverflow.com/questions/15520361/permission-denied-for-relation

However, this likely means you also didn't run the other database
upgrade scripts as the "dspace" role, either. Therefore you may expect
some of the other new features in 1.5.0 - 3.0 to misbehave. Check all
commands executed there, especially CREATE TABLE, but perhaps also
CREATE INDEX and CREATE SEQUENCE and fix the permission issues.

It might be easier just to drop them and re-run the upgrade scripts as
the correct role. You'll have to judge that for yourself.

Luis Rojas C. (CATIE)

unread,

Aug 26, 2015, 11:38:19 AM8/26/15

to hel...@centrum.sk, dspac...@lists.sourceforge.net

Helix, review all data base updates and all was applied, but the problem persist.

Some other idea.

Please and thanks

-----Mensaje original-----
De: ivan....@gmail.com [mailto:ivan....@gmail.com] En nombre de helix84

Enviado el: miércoles, 24 de julio de 2013 16:17

Para: Luis Rojas C. (CATIE)
CC: dspac...@lists.sourceforge.net
Asunto: Re: [Dspace-tech] RV: Problen send to repository

helix84

unread,

Aug 26, 2015, 11:38:30 AM8/26/15

to Luis Rojas C. (CATIE), dspac...@lists.sourceforge.net

On Fri, Jul 26, 2013 at 10:10 PM, Luis Rojas C. (CATIE) <luis...@catie.ac.cr> wrote:
> Helix, review all data base updates and all was applied, but the problem persist.

What I wrote still applies. I think you did apply the updates, but under a different database role, so your dspace role doesn't see them.

To verify this, log in as user postgres, then run psql [dspace] (where [dspace] is your database name) and run the \z command. You should see something like this:

postgres@test:~$ psql dspace

psql (8.4.17)

Type "help" for help.

dspace=# \z

Access privileges

Schema | Name | Type | Access privileges | Column access privileges

--------+--------------------------------+----------+-----------------------+--------------------------

public | bi_2_dis | table | |

public | bi_2_dis_seq | sequence | |

public | bi_2_dmap | table | |

public | bi_2_dmap_seq | sequence | |

public | bi_3_dis | table | |

public | bi_3_dis_seq | sequence | |

public | bi_3_dmap | table | |

public | bi_3_dmap_seq | sequence | |

public | bi_5_dis | table | |

public | bi_5_dis_seq | sequence | |

public | bi_5_dmap | table | |

public | bi_5_dmap_seq | sequence | |

public | bi_6_dis | table | |

public | bi_6_dis_seq | sequence | |

public | bi_6_dmap | table | |

public | bi_6_dmap_seq | sequence | |

public | bi_7_dis | table | |

public | bi_7_dis_seq | sequence | |

public | bi_7_dmap | table | |

public | bi_7_dmap_seq | sequence | |

public | bi_item | table | |

public | bi_item_seq | sequence | |

public | bi_withdrawn | table | |

public | bi_withdrawn_seq | sequence | |

public | bitstream | table | dspace=arwdDxt/dspace |

public | bitstream_seq | sequence | |

public | bitstreamformatregistry | table | dspace=arwdDxt/dspace |

public | bitstreamformatregistry_seq | sequence | |

public | bundle | table | dspace=arwdDxt/dspace |

public | bundle2bitstream | table | dspace=arwdDxt/dspace |

...

Luis Rojas C. (CATIE)

unread,

Aug 26, 2015, 11:38:51 AM8/26/15

to hel...@centrum.sk, dspac...@lists.sourceforge.net

Helix, review all data base updates and all was applied, but the problem persist.

Some other idea.

Please and thanks

-----Mensaje original-----
De: ivan....@gmail.com [mailto:ivan....@gmail.com] En nombre de helix84 Enviado el: miércoles, 24 de julio de 2013 16:17

Para: Luis Rojas C. (CATIE)
CC: dspac...@lists.sourceforge.net
Asunto: Re: [Dspace-tech] RV: Problen send to repository

helix84

unread,

Aug 26, 2015, 11:38:53 AM8/26/15

to Luis Rojas C. (CATIE), dspac...@lists.sourceforge.net

Sorry, I don't know what else to try. What was the output of the \z command?

Regards,
~~helix84

Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

On Mon, Jul 29, 2013 at 7:26 PM, Luis Rojas C. (CATIE)

helix84

unread,

Aug 26, 2015, 11:38:57 AM8/26/15

to Luis Rojas C. (CATIE), dspac...@lists.sourceforge.net

On Mon, Jul 29, 2013 at 8:59 PM, Luis Rojas C. (CATIE)
<luis...@catie.ac.cr> wrote:
> Sorry, I don't know what is the \z command?
> How can apply this command?

I described it in my last email:

http://dspace.2283337.n4.nabble.com/Problen-send-to-repository-tp4665850p4665989.html

Luis Rojas C. (CATIE)

unread,

Aug 26, 2015, 11:38:59 AM8/26/15

to hel...@centrum.sk, dspac...@lists.sourceforge.net

Sorry, I don't know what is the \z command?
How can apply this command?

Luis

-----Mensaje original-----
De: ivan....@gmail.com [mailto:ivan....@gmail.com] En nombre de helix84

Enviado el: lunes, 29 de julio de 2013 12:48

Para: Luis Rojas C. (CATIE)
CC: dspac...@lists.sourceforge.net

Asunto: Re: RV: [Dspace-tech] RV: Problen send to repository

Luis Rojas C. (CATIE)

unread,

Aug 26, 2015, 11:39:01 AM8/26/15

to hel...@centrum.sk, dspac...@lists.sourceforge.net

Helix this is the result of apply this command with the dspace user:

HOW CAN UNDERSTAND THIS?

-----Mensaje original-----

De: ivan....@gmail.com [mailto:ivan....@gmail.com] En nombre de helix84

Enviado el: lunes, 29 de julio de 2013 13:03

Para: Luis Rojas C. (CATIE)

CC: dspac...@lists.sourceforge.net

Asunto: Re: RV: [Dspace-tech] RV: Problen send to repository

On Mon, Jul 29, 2013 at 8:59 PM, Luis Rojas C. (CATIE) <luis...@catie.ac.cr> wrote:

helix84

unread,

Aug 26, 2015, 11:39:02 AM8/26/15

to Luis Rojas C. (CATIE), dspac...@lists.sourceforge.net

On Mon, Jul 29, 2013 at 9:53 PM, Luis Rojas C. (CATIE)
<luis...@catie.ac.cr> wrote:
> Helix this is the result of apply this command with the dspace user:

I really need to see the full output of that command. This part
doesn't say anything interesting.

Luis Rojas C. (CATIE)

unread,

Aug 26, 2015, 11:39:05 AM8/26/15

to hel...@centrum.sk, dspac...@lists.sourceforge.net

Really this is the full output of this command.

De: Luis Rojas C. (CATIE)
Enviado el: lunes, 29 de julio de 2013 13:54
Para: 'hel...@centrum.sk'
CC: dspac...@lists.sourceforge.net
Asunto: RE: RV: [Dspace-tech] RV: Problen send to repository

Helix this is the result of apply this command with the dspace user:

cid:image001.jpg@01CE8C63.041FD8D0

HOW CAN UNDERSTAND THIS?

-----Mensaje original-----

De: ivan....@gmail.com [mailto:ivan....@gmail.com] En nombre de helix84

Enviado el: lunes, 29 de julio de 2013 13:03

Para: Luis Rojas C. (CATIE)

CC: dspac...@lists.sourceforge.net

Asunto: Re: RV: [Dspace-tech] RV: Problen send to repository

On Mon, Jul 29, 2013 at 8:59 PM, Luis Rojas C. (CATIE) <luis...@catie.ac.cr> wrote:

Luis Rojas C. (CATIE)

unread,

Aug 26, 2015, 11:39:07 AM8/26/15

to hel...@centrum.sk, dspac...@lists.sourceforge.net

Sorry, this is the complete output.

Access privileges

Schema | Name | Type | Access privileges | Column

access privileges

--------+--------------------------------+----------+-------------------+-------

-------------------

public | bi_2_dis | table | |

public | bi_2_dis_seq | sequence | |

public | bi_2_dmap | table | |

public | bi_2_dmap_seq | sequence | |

public | bi_4_dis | table | |

public | bi_4_dis_seq | sequence | |

public | bi_4_dmap | table | |

public | bi_4_dmap_seq | sequence | |

public | bi_item | table | |

public | bi_item_seq | sequence | |

public | bi_private | table | |

public | bi_private_seq | sequence | |

public | bi_withdrawn | table | |

public | bi_withdrawn_seq | sequence | |

public | bitstream | table | |

public | bitstream_seq | sequence | |

public | bitstreamformatregistry | table | |

public | bitstreamformatregistry_seq | sequence | |

public | bundle | table | |

public | bundle2bitstream | table | |

public | bundle2bitstream_seq | sequence | |

public | bundle_seq | sequence | |

public | checksum_history | table | |

public | checksum_history_check_id_seq | sequence | |

public | checksum_results | table | |

public | collection | table | |

public | collection2item | table | |

public | collection2item_seq | sequence | |

public | collection_item_count | table | |

public | collection_seq | sequence | |

public | communities2item | table | |

public | communities2item_seq | sequence | |

public | community | table | |

public | community2collection | table | |

public | community2collection_seq | sequence | |

public | community2community | table | |

public | community2community_seq | sequence | |

public | community2item | view | |

public | community_item_count | table | |

public | community_seq | sequence | |

public | dcvalue | view | |

public | dcvalue_seq | sequence | |

public | eperson | table | |

public | eperson_seq | sequence | |

public | epersongroup | table | |

public | epersongroup2eperson | table | |

public | epersongroup2eperson_seq | sequence | |

public | epersongroup2workspaceitem | table | |

public | epersongroup2workspaceitem_seq | sequence | |

public | epersongroup_seq | sequence | |

public | fileextension | table | |

public | fileextension_seq | sequence | |

public | group2group | table | |

public | group2group_seq | sequence | |

public | group2groupcache | table | |

public | group2groupcache_seq | sequence | |

public | handle | table | |

public | handle_seq | sequence | |

public | harvested_collection | table | |

public | harvested_collection_seq | sequence | |

public | harvested_item | table | |

public | harvested_item_seq | sequence | |

public | history_seq | sequence | |

public | historystate_seq | sequence | |

public | item | table | |

public | item2bundle | table | |

public | item2bundle_seq | sequence | |

public | item_seq | sequence | |

public | metadatafieldregistry | table | |

public | metadatafieldregistry_seq | sequence | |

public | metadataschemaregistry | table | |

public | metadataschemaregistry_seq | sequence | |

public | metadatavalue | table | |

public | metadatavalue_seq | sequence | |

public | most_recent_checksum | table | |

public | registrationdata | table | |

public | registrationdata_seq | sequence | |

public | resourcepolicy | table | |

public | resourcepolicy_seq | sequence | |

public | subscription | table | |

public | subscription_seq | sequence | |

public | tasklistitem | table | |

public | tasklistitem_seq | sequence | |

public | versionhistory | table | |

public | versionhistory_seq | sequence | |

public | versionitem | table | |

public | versionitem_seq | sequence | |

public | workflowitem | table | |

public | workflowitem_seq | sequence | |

public | workspaceitem | table | |

public | workspaceitem_seq | sequence | |

(91 rows)

De: Luis Rojas C. (CATIE)
Enviado el: lunes, 29 de julio de 2013 14:46
Para: 'hel...@centrum.sk'
CC: dspac...@lists.sourceforge.net
Asunto: RV: RV: [Dspace-tech] RV: Problen send to repository

Really this is the full output of this command.

De: Luis Rojas C. (CATIE)
Enviado el: lunes, 29 de julio de 2013 13:54
Para: 'hel...@centrum.sk'
CC: dspac...@lists.sourceforge.net
Asunto: RE: RV: [Dspace-tech] RV: Problen send to repository

Helix this is the result of apply this command with the dspace user:

cid:image001.jpg@01CE8C63.041FD8D0

HOW CAN UNDERSTAND THIS?

-----Mensaje original-----

De: ivan....@gmail.com [mailto:ivan....@gmail.com] En nombre de helix84

Enviado el: lunes, 29 de julio de 2013 13:03

Para: Luis Rojas C. (CATIE)

CC: dspac...@lists.sourceforge.net

Asunto: Re: RV: [Dspace-tech] RV: Problen send to repository

On Mon, Jul 29, 2013 at 8:59 PM, Luis Rojas C. (CATIE) <luis...@catie.ac.cr> wrote:

helix84

unread,

Aug 26, 2015, 11:39:07 AM8/26/15

to Luis Rojas C. (CATIE), dspac...@lists.sourceforge.net

On Mon, Jul 29, 2013 at 10:46 PM, Luis Rojas C. (CATIE)
<luis...@catie.ac.cr> wrote:
> Really this is the full output of this command.

Press Enter or Spacebar to see the next page. Then right-click in the
window, select, then copy the text and paste it here.

helix84

unread,

Aug 26, 2015, 11:39:08 AM8/26/15

to Luis Rojas C. (CATIE), dspac...@lists.sourceforge.net

Is repoforestal your dspace user? Run the psql command as the postgres
user, not the repoforestal user, to actually see something in the
Access privileges column.

Reply all

Reply to author

Forward