Both my Postgres (working version) and Oracle setup have the same 42 tables, there are no tables missing I compared both databases table for table .
And just on a side the dspace test-email doesn't work with the Postgres either, but I have no problems with sending emails on the Postgres install Thanks, Kelly Brown Database Analyst Massey Library | Bibliothèque Massey Royal Military College of Canada | Collège militaire royal du Canada Telephone / Téléphone: (613) 541-6000 x 6979 E-Mail / Couriel: [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of helix84 Sent: July 11, 2012 9:45 AM To: Kelly Brown Cc: [email protected] Subject: Re: [Dspace-tech] Oracle 11g and DSpace 1.8.1 problems On Wed, Jul 11, 2012 at 3:27 PM, Kelly Brown <[email protected]> wrote: > The create-administrator output is attached the error is the following: > Exception: null java.lang.NullPointerException So it seems like a database issue after all. column is an empty string here: https://github.com/DSpace/DSpace/blob/20943b7192cfaa5caa13d0bebf72a472c8c29bd9/dspace-api/src/main/java/org/dspace/storage/rdbms/DatabaseManager.java#L508 Which is returned by getPrimaryKeyColumn(ctable) here: https://github.com/DSpace/DSpace/blob/20943b7192cfaa5caa13d0bebf72a472c8c29bd9/dspace-api/src/main/java/org/dspace/storage/rdbms/DatabaseManager.java#L476 And the table in question is epersongroup: https://github.com/DSpace/DSpace/blob/20943b7192cfaa5caa13d0bebf72a472c8c29bd9/dspace-api/src/main/java/org/dspace/eperson/Group.java#L684 > The database test works fine. Well, it's a test of connecting to database. The problem is that (some?) tables were not created. Can you send us a list of tables in your dspace tablespace? (You can also compare it to your other DSpace installation and see which tables are missing). > The email seems to be the issue as well as, I am using the same credentials > as the install I have with Postgres db and everything works there. There should be "Email sent successfully!" at the end, so maybe you didn't set mail.server (and possibly other related options) in dspace.cfg correctly. Regards, ~~helix84 ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
