On further investigation, here's an error I receive while the database conversion is under way: http://pastebin.com/qHFBFBji
Specifically: 2015-11-17 15:51:31,385 ERROR org.dspace.storage.rdbms.DatabaseRegistryUpdater @ Error attempting to update Bitstream Format and/or Metadata Registries org.postgresql.util.PSQLException: ERROR: value too long for type character varying(48) Given that, it's likely that the database conversion isn't completing. Here's the command line response when creating a new administrator: dspace@host:/klib/app/dspace/5.3-jeff/bin$ ./dspace create-administrator Creating an initial administrator account E-mail address: [email protected] First name: Bill Last name: Carson Password will not display on screen. Password: Again to confirm: Is the above data correct? (y or n): y Exception: Invalid metadata field: [eperson.lastname] java.sql.SQLException: Invalid metadata field: [eperson.lastname] at org.dspace.content.DSpaceObject.updateMetadata(DSpaceObject.java:122) at org.dspace.eperson.EPerson.update(EPerson.java:1056) at org.dspace.administer.CreateAdministrator.createAdministrator(CreateAdministrator.java:259) at org.dspace.administer.CreateAdministrator.negotiateAdministratorDetails(CreateAdministrator.java:206) at org.dspace.administer.CreateAdministrator.main(CreateAdministrator.java:82) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:226) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:78) dspace@host:/klib/app/dspace/5.3-jeff/bin$ Thanks for your time and assistance. -Jeff ________________________________________ From: Andrea Schweer <[email protected]> Sent: Tuesday, November 17, 2015 3:54 PM To: Jeffrey Sheldon; [email protected] Subject: Re: [dspace-tech] 5.3 migration script drops columns from 4.3 database Hi Jeff, On 18/11/15 10:41, Jeffrey Sheldon wrote: > Folks, > > I noticed in our DSpace 5.3 trials that a Java exception was being thrown > whenever I tried to access any link which includes /admin/epeople. > Essentially, the resource isn't found. > > I ran a number of upgrade tests and discovered that the table "eperson" > remained intact after a DSpace deploy ("ant update"), but once Tomcat was > started and DSpace 5.3 invoked the database migration script, my table for > "eperson" changed in the following manner: > > DSpace 4.3 table "eperson": > eperson_id,email,password,firstname,lastname,can_log_in,require_certificate,self_registered,last_active,sub_frequency,phone,netid,language,salt,digest_algorithm > > DSpace 5.3 table "eperson" after a migration from 4.3: > eperson_id,email,password,can_log_in,require_certificate,self_registered,last_active,sub_frequency,netid,salt,digest_algorithm > > Of note, the name, language, and phone columns have disappeared. I've > noticed some other substantial changes in other tables which might or might > not be affected in the same way, but in this case I can absolutely confirm > that something is errant. These changes are correct. DSpace 5 introduces "metadata for all". The information you mention is now stored in the metadatavalue table, with a resource_type_id of 7 indicating that the corresponding row is for an eperson (https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/core/Constants.java#L41). > Other than the Java exception, I can't create a new administrator on the > command line since that process can't find the name fields to populate. Could you send the stack trace you get when you try to create a new administrator, please? For the stacktrace you put into pastebin, are you absolutely sure that your code is at 5.3? The line here: Caused by: java.lang.NullPointerException at org.dspace.eperson.EPerson.searchResultCount(EPerson.java:438) indicates the error occurs here: https://github.com/DSpace/DSpace/blob/dspace-5.3/dspace-api/src/main/java/org/dspace/eperson/EPerson.java#L438 cheers, Andrea -- Dr Andrea Schweer IRR Technical Specialist, ITS Information Systems The University of Waikato, Hamilton, New Zealand +64-7-837 9120 -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
