Hi Wally, and the rest of list 

I check the database and tables and it seems that all have the same owner. I 
also just discovered that just will not let me upload records when I use 
metadata 'editor' and 'citation' but if I do not use I can upload both new 
collections as in previous.

I do not know if it is due to the system or database


 Listado de relaciones
 Esquema |             Nombre                    |   Tipo        | Dueño
---------+--------------------------------+-----------+--------
 public  | bi_2_dis                                     | tabla         | dspace
 public  | bi_2_dis_seq                             | secuencia | dspace
 public  | bi_2_dmap                                 | tabla         | dspace
 public  | bi_2_dmap_seq                            secuencia | dspace
 public  | bi_4_dis                                      | tabla        | dspace
 public  | bi_4_dis_seq                              | secuencia | dspace
 public  | bi_4_dmap                                  | tabla        | dspace
 public  | bi_4_dmap_seq                          | secuencia | dspace
 public  | bi_item                                        | tabla         | 
dspace
 public  | bi_item_seq                                 | secuencia | dspace
 public  | bi_withdrawn                               | tabla         | dspace
 public  | bi_withdrawn_seq                       | secuencia | dspace
 public  | bitstream                                      | tabla         | 
dspace
 public  | bitstream_seq                               | secuencia | dspace
 public  | bitstreamformatregistry                | tabla         | dspace
 public  | bitstreamformatregistry_seq        | secuencia | dspace
 public  | bundle                                            | tabla           
| dspace
 public  | bundle2bitstream                           | tabla          | dspace
 public  | bundle2bitstream_seq                   | secuencia   | dspace
 public  | bundle_seq                                    | secuencia    | dspace
 public  | checksum_history                          | tabla           | dspace
 public  | checksum_history_check_id_seq  | secuencia   | dspace
 public  | checksum_results                          | tabla           | dspace
 public  | collection                                       | tabla           | 
dspace
 public  | collection2item                              | tabla           | 
dspace
 public  | collection2item_seq                      | secuencia    | dspace
 public  | collection_item_count                   | tabla            | dspace
 public  | collection_seq                                | secuencia    | dspace
 public  | communities2item                          | tabla           | dspace
 public  | communities2item_seq                  | secuencia    | dspace
 public  | community                                      | tabla            | 
dspace
 public  | community2collection                    | tabla            | dspace
 public  | community2collection_seq            | secuencia     | dspace
 public  | community2community                  | tabla             | dspace
 public  | community2community_seq          | secuencia     | dspace
 public  | community2item                            | vista              | 
dspace
 public  | community_item_count                 | tabla              | dspace
 public  | community_seq                              | secuencia      | dspace
 public  | dcvalue                                           | vista            
   | dspace
 public  | dcvalue_seq                                   | secuencia       | 
dspace
 public  | dcvalue                                           | vista            
   | dspace
 public  | dcvalue_seq                                   | secuencia       | 
dspace
 public  | doi                                                  | tabla         
      | dspace
 public  | doi_seq                                          | secuencia       | 
dspace
 public  | eperson                                          | tabla             
  | dspace
 public  | eperson_seq                                  | secuencia       | 
dspace
 public  | epersongroup                                 | tabla              | 
dspace
 public  | epersongroup2eperson                  | tabla              | dspace
 public  | epersongroup2eperson_seq          | secuencia       | dspace
 public  | epersongroup2workspaceitem      | tabla               | dspace
 public  | epersongroup2workspaceitem_seq | secuencia    | dspace
 public  | epersongroup_seq                         | secuencia      | dspace
 public  | fileextension                                  | tabla              
| dspace
 public  | fileextension_seq                          | secuencia      | dspace
 public  | group2group                                  | tabla              | 
dspace
 public  | group2group_seq                          | secuencia      | dspace
 public  | group2groupcache                        | tabla              | dspace
 public  | group2groupcache_seq                | secuencia      | dspace
 public  | handle                                           | tabla             
 | dspace
 public  | handle_seq                                   | secuencia      | 
dspace
 public  | harvested_collection                    | tabla              | dspace
 public  | harvested_collection_seq            | secuencia      | dspace
 public  | harvested_item                            | tabla              | 
dspace
 public  | harvested_item_seq                    | secuencia      | dspace
 public  | history_seq                                  | secuencia      | 
dspace
 public  | historystate_seq                          | secuencia     | dspace
 public  | item                                              | tabla            
 | dspace
 public  | item2bundle                                 | tabla             | 
dspace
 public  | item2bundle_seq                          | secuencia    | dspace
 public  | item_seq                                      | secuencia     | 
dspace
 public  | metadatafieldregistry                  | tabla             | dspace
 public  | metadatafieldregistry_seq          | secuencia     | dspace
 public  | metadataschemaregistry            | tabla             | dspace
 public  | metadataschemaregistry_seq     | secuencia     | dspace
 public  | metadatavalue                             | tabla             | 
dspace
 public  | metadatavalue_seq                     | secuencia     | dspace
 public  | most_recent_checksum               | tabla             | dspace
 public  | registrationdata                           | tabla             | 
dspace
 public  | registrationdata_seq                   | secuencia     | dspace
 public  | requestitem                                 | tabla             | 
dspace
 public  | requestitem_seq                         | secuencia     | dspace
 public  | resourcepolicy                             | tabla             | 
dspace
 public  | resourcepolicy_seq                     | secuencia     | dspace
 public  | subscription                                 | tabla            | 
dspace
 public  | subscription_seq                         | secuencia     | dspace
 public  | tasklistitem                                  | tabla            | 
dspace
 public  | tasklistitem_seq                          | secuencia    | dspace
 public  | versionhistory                              | tabla            | 
dspace
 public  | versionhistory_seq                      | secuencia    | dspace
 public  | versionitem                                 | tabla            | 
dspace
 public  | versionitem_seq                         | secuencia    | dspace
 public  | webapp                                       | tabla            | 
dspace
 public  | webapp_seq                                | secuencia   | dspace
 public  | workflowitem                              | tabla           | dspace
 public  | workflowitem_seq                      | secuencia   | dspace
 public  | workspaceitem                           | tabla           | dspace
 public  | workspaceitem_seq                   | secuencia   | dspace
(95 filas)





Date: Fri, 26 Sep 2014 10:50:20 -0400
From: [email protected]
To: [email protected]
Subject: Re: [Dspace-tech] FW:  4.2 dspace don't allow to upload records



I had this problem and it 
turned out that dspace was not the owner of some of the tables in the 
postgres database.  I dumped the database to a text file and then went 
in with an editor and made sure dspace owned all the tables related to 
the application.  Then reimported the database.  That fixed it.



- Wally



Wally Grotophorst

Associate University Librarian

George Mason University

Fairfax, Virginia 22030

(703) 993-9005 





ʚïɞ...liss ...εïз wrote:

  
  
  
sorry... I'm sending the logs
Date: Thu, 25 Sep 2014 18:43:01 -0400
Subject: Re: 
[Dspace-tech] 4.2 dspace don't allow to upload records
From: 
[email protected]
To: [email protected]

Attached
 the log please! 
Em 25/09/2014 12:58, "ʚïɞ...liss ...εïз" 
<[email protected]>
 escreveu:
hi all,
I've 
installed dspace v4.2   but I made the migration of the database I had 
in dspace 1.8 and everything ok I can upload records but when I create a
 new collection sometimes I can upload and sometimes I can't

 I
 don't know what I must do in postgresql
                                          

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

Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer

Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports

Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper

Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer

http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________

DSpace-tech mailing list

[email protected]

https://lists.sourceforge.net/lists/listinfo/dspace-tech

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

                                          

  ------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk

  _______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

                                          
------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Reply via email to