Re: [Dspace-tech] Internal System Error after Login
Andrea Bollini writes: > > > Hi Mary, > it looks like you have an incomplete database. > Are you trying to upgrade a previous installation or it is a fresh > one? > take a look to this filehttps://github.com/Cineca/DSpace/blob/dspace-cris- master/dspace/etc/postgres/addon-crismodule.sql > or if you use oraclehttps://github.com/Cineca/DSpace/blob/dspace-cris- master/dspace/etc/oracle/addon-crismodule.sql > on line 79 you have the rpage table definition with the sourceref > column. > If you are updating an existent dspace-cris installation be sure > to runhttps://github.com/Cineca/DSpace/blob/dspace-cris- master/dspace/etc/postgres/update-crismodule_321_to_4.sql > (see line 12 for reference) > Hope this help, > Andrea > Il 25/09/2014 08.03, Mary Choi ha scritto: > > > > > Hi all, > > > I > have just installed DSpace-CRIS Installation > (Development for 4.x.x) and > discovered that there is a problem with the account > registration and login. It could validate the accounts so > there should be no problem with the database connection. > After checking the logs, I found out that the problem was > the column researcher0_.sourceref does not exist but I had > no idea on how to solve this problem. Any ideas? Thank > you for your help. > > Here are > the messages shown in dspace.log: > > 2014-09-25 12:02:13,799 INFO > org.dspace.authenticate.PasswordAuthentication > anonymous:session_id=80CE880BB2219B91D5669975E7DFBFA2:ip_addr=175.159.73 .163:authenticate:attempting > password auth of user=email- q89rzv0o...@public.gmane.org > 2014-09-25 12:02:13,814 WARN > org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL > Error: 0, SQLState: 42703 > 2014-09-25 12:02:13,814 ERROR > org.hibernate.engine.jdbc.spi.SqlExceptionHelper > ERROR: column researcher0_.sourceref does not exist > Position: 103 > > > Best Regards, > > Mary > > > > -- > 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 > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > > -- > Andrea Bollini > Soluzioni per la Ricerca Istituzionale > Cineca > > Via dei Tizii, 6 > 00185 Roma, Italy > tel. +39 06 44 486 087 - mob. +39 348 82 77 525 > http://www.cineca.it > > > -- > Slashdot TV. Videos for Nerds. Stuff that Matters. > http://pubads.g.doubleclick.net/gampad/clk? id=160591471&iu=/4140/ostg.clktrk > > -- > Slashdot TV. Videos for Nerds. Stuff that Matters. > http://pubads.g.doubleclick.net/gampad/clk? id=160591471&iu=/4140/ostg.clktrk The actual situation was actually quite messy. I was gonna install a dspace cris instance on a server with an existing dspace 3 instance but problems aroused and I'm facing this problem at the moment. I just gave it a shot and the problem is solved. Thank you very much Andrea! Do you mind if I post the solution to other websites where I issued the same question? -- 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 DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] Internal System Error after Login
Hi Mary, it looks like you have an incomplete database. Are you trying to upgrade a previous installation or it is a fresh one? take a look to this file https://github.com/Cineca/DSpace/blob/dspace-cris-master/dspace/etc/postgres/addon-crismodule.sql or if you use oracle https://github.com/Cineca/DSpace/blob/dspace-cris-master/dspace/etc/oracle/addon-crismodule.sql on line 79 you have the rpage table definition with the sourceref column. If you are updating an existent dspace-cris installation be sure to run https://github.com/Cineca/DSpace/blob/dspace-cris-master/dspace/etc/postgres/update-crismodule_321_to_4.sql (see line 12 for reference) Hope this help, Andrea Il 25/09/2014 08.03, Mary Choi ha scritto: Hi all, I have just installed DSpace-CRIS Installation (Development for 4.x.x) and discovered that there is a problem with the account registration and login. It could validate the accounts so there should be no problem with the database connection. After checking the logs, I found out that the problem was the column researcher0_.sourceref does not exist but I had no idea on how to solve this problem. Any ideas? Thank you for your help. Here are the messages shown in dspace.log: 2014-09-25 12:02:13,799 INFO org.dspace.authenticate.PasswordAuthentication @ anonymous:session_id=80CE880BB2219B91D5669975E7DFBFA2:ip_addr=175.159.73.163:authenticate:attempting password auth of user=em...@xxx.com 2014-09-25 12:02:13,814 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: 42703 2014-09-25 12:02:13,814 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ ERROR: column researcher0_.sourceref does not exist Position: 103 Best Regards, Mary -- 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 DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Andrea Bollini Soluzioni per la Ricerca Istituzionale Cineca Via dei Tizii, 6 00185 Roma, Italy tel. +39 06 44 486 087 - mob. +39 348 82 77 525 http://www.cineca.it -- Slashdot TV. Videos for Nerds. Stuff that Matters. http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
[Dspace-tech] Internal System Error after Login
Hi all, I have just installed DSpace-CRIS Installation (Development for 4.x.x) and discovered that there is a problem with the account registration and login. It could validate the accounts so there should be no problem with the database connection. After checking the logs, I found out that the problem was the column researcher0_.sourceref does not exist but I had no idea on how to solve this problem. Any ideas? Thank you for your help. Here are the messages shown in dspace.log: 2014-09-25 12:02:13,799 INFO org.dspace.authenticate.PasswordAuthentication @ anonymous:session_id=80CE880BB2219B91D5669975E7DFBFA2:ip_addr=175.159.73.163:authenticate:attempting password auth of user=em...@xxx.com 2014-09-25 12:02:13,814 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: 42703 2014-09-25 12:02:13,814 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ ERROR: column researcher0_.sourceref does not exist Position: 103 Best Regards, Mary -- 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 DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
[Dspace-tech] Internal System Error after Login
Hi all, I have just installed DSpace-CRIS Installation (Development for 4.x.x) and discovered that there is a problem with the account registration and login. It could validate the accounts so there should be no problem with the database connection. After checking the logs, I found out that the problem was the column researcher0_.sourceref does not exist but I had no idea on how to solve this problem. Any ideas? Thank you for your help. Here are the messages shown in dspace.log: 2014-09-25 12:02:13,799 INFO org.dspace.authenticate.PasswordAuthentication @ anonymous:session_id=80CE880BB2219B91D5669975E7DFBFA2:ip_addr=175.159.73.163:authenticate:attempting password auth of user=em...@xxx.com 2014-09-25 12:02:13,814 WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ SQL Error: 0, SQLState: 42703 2014-09-25 12:02:13,814 ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper @ ERROR: column researcher0_.sourceref does not exist Position: 103 Best Regards, Mary -- 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 DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
[Dspace-tech] Internal system error after login
Hi, I installed Dspace 1.5.2 on Windows XP Sp3. The installation is successful, I can access dspace at http://localhost:8080/jspui. Then I login to myspace with admin user after that I received the message " Internal System Error: The system has experienced an internal error. Please try to do what you were doing again, and if the problem persists, please contact us so we can fix the problem". Anybody know the reason? Please suggest me. I attach the log file. Thanks. My software detail: Dspace 1.5.2 PostgreSQL 8.0.3 Apache Tomcat 5.5 apache ant-1.6.5 Java JRE/JDK 1.5.0 apache-maven-2.1.0 dspace-err.log Description: Binary data -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech