Re: [Dspace-tech] Internal System Error after Login
Andrea Bollini a.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:
!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--
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 at
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 at
SQL
Error: 0, SQLState: 42703
2014-09-25 12:02:13,814 ERROR
org.hibernate.engine.jdbc.spi.SqlExceptionHelper at
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=154622311iu=/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=160591471iu=/4140/ostg.clktrk
--
Slashdot TV. Videos for Nerds. Stuff that Matters.
http://pubads.g.doubleclick.net/gampad/clk?
id=160591471iu=/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=154622311iu=/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=154622311iu=/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=160591471iu=/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=154622311iu=/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=154622311iu=/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
